Here are some useful scripts to check and update AD Integration settings using the Command Shell.  Thanks to Lincoln Atkinson for helping me figure this one out. Check current Ldap query get-managementserver | where {$_.name -eq " fqdn "...

This will set a failover Management Server for a Gateway role, leaving the currently configured primary Management Server. Beware of word wrap on the last two lines (should be one line). $gw = get-GatewayManagementServer | where {$_.Name -eq " gw_fqdn...

So, here’s a quick post on this error.  I did a quick web search for this, just to see if anyone posted the same, and didn’t get any hits (something I always do before posting). Problem This is very common during an upgrade from SP1 to R2. ...

While creating some content late last year and playing around with the getClassPath script , I put together this chart of the Windows Server 200x Operating System class structure.  I stumbled across it while perusing my file system and, since I had...

Agent Proxy needs to be enabled for several different management packs features to work properly.  Active Directory, Cluster and Exchange are just a few common management packs requiring Agent Proxy to be enabled. Enabling the Agent Proxy security...

Get-NotificationRecipient | foreach-object {$_.devices | where {$_.protocol -eq "smtp"}} | select name,address   Command Shell Main Menu

Do you have some domain controllers that are appearing in a “not monitored” state? There are several reasons why an object would have a “not monitored” state.  There are two very common reasons why a domain controller appears in this state if you...

I ran across an issue recently where several CScript processes would peg the CPU for several seconds at a time.  You may have run across the same issue, and read some other articles about updating CScript to the latest version (5.7).  But, what...

In this series, I’m going to talk about multiple Management Groups sharing a single Data Warehouse. I’ll try to clarify two common questions that come out of this scenario. Part 1 – Operations Manager Reporting Instance Where do these...

Ever wonder which Management Pack you stored a particular group in?  Here’s the answer. ForEach ($Group in get-MonitoringObjectGroup) {If ($Group.DisplayName -eq " <group_name> ") {get-MonitoringClass | where {$_.Id -eq $Group.Id...

In this series, I’m going to talk about multiple Management Groups sharing a single Data Warehouse.  I’ll try to clarify two common questions that come out of this scenario. Part 1 – Operations Manager Reporting Instance Where do these components...

Came across an issue today that was really just a matter of me not reading the fine print.  I figured a quick post on this could help someone with the same issue. The problem While attempting to install a database using DBCreateWizard , I was receiving...

I was working with a large customer last week, and found some very interesting performance metrics which impact console sessions.  This particular customer pushes the limits of Operations Manager 2007 in every way.  They have 6000+ agents in...

Here is a script that will output agent failover status. Simply copy the script below into the Command Shell on any Management Server, including the Root Management Server.  The results will show you a list of agents currently connected to that Management...

/*Get each logical disk size, for each agent computer, by OS version. This helps in calculating the Logical Disk Free Space Monitor from my earlier post .  You can copy results into Excel, sort by system and non-system drives, and perform an average...

get-alert | where {$_.name -match " Alert Name "} | get-AlertHistory | select Time* command shell main menu

This will return the list of Failover Management Servers for specified agent. get-agent | where {$_.computername -eq " netbios computername "} | Get-FailoverManagementServer | select computername command shell main menu

This will return the top ten events collected. FYI – Given the sheer number of events collected and stored in the OperationsManager database, this query may take a minute to return results. $array = @();foreach ($number in Get-Event | foreach-object ...

If you have multiple Management Groups, this can be handy to switch between them while in the same Command Shell session. Always be aware of which Management Group you’re connected to while in the Command Shell! This example assumes your session is...

Sharing this list of random SQL queries I have found useful on different occasions. Refer to report dataset samples page for SQL queries you can use for custom reporting needs. Updated: 08-05-2011 OperationsManager OperationsManagerDW...

SELECT     SourceMonitoringObjectDisplayName AS 'Group', TargetMonitoringObjectDisplayName AS 'Member' FROM         RelationshipGenericView WHERE     (SourceMonitoringObjectDisplayName...

SELECT     ManagedEntityGenericView.DisplayName, ManagedEntityGenericView.FullName FROM         ManagedEntityGenericView INNER JOIN                          ...

This will return which [typed] class the specified task will run against. foreach ($targetId in get-task | where {$_.displayname -match " task name "} | foreach-object {$_.get_target().id.tostring()}) {get-monitoringclass | where {$_.id -eq...

Got a new one today.  HTH. Foreach ($discovery in (get-discovery | foreach-object {$_.DataSource}))     {     if ($discovery.Configuration -match "IntervalSeconds> seconds <")        ...

Since I just wrote an article on how to use the Logical Disk Free Space monitor , I figured this would be a nice compliment to that post.  I highly recommend reading that article to get an understanding of this monitor before moving forward with...