Command Shell Examples
Useful SQL Queries
April, 2009 - Jonathan Almquist on Operations Manager - Site Home - TechNet Blogs
Sign in
Jonathan Almquist on Operations Manager
Search my blog
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Tag Cloud
Authoring
Custom Reports
Exchange 2010 MP
Performance Tips
Powershell
Report Datasets
SCOM 2012
TSQL (misc)
Tuning
Options
About
Email Blog Author
RSS for posts
RSS for comments
Atom
OK
Archive
Archives
February 2012
(1)
January 2012
(2)
November 2011
(2)
September 2011
(1)
August 2011
(8)
July 2011
(1)
June 2011
(4)
May 2011
(2)
April 2011
(15)
January 2011
(8)
December 2010
(1)
October 2010
(8)
August 2010
(2)
July 2010
(2)
June 2010
(2)
May 2010
(6)
April 2010
(4)
March 2010
(5)
February 2010
(1)
January 2010
(4)
December 2009
(9)
November 2009
(14)
October 2009
(1)
September 2009
(4)
August 2009
(1)
July 2009
(1)
June 2009
(3)
May 2009
(1)
April 2009
(15)
March 2009
(44)
February 2009
(4)
November 2008
(6)
September 2008
(1)
August 2008
(4)
July 2008
(2)
April 2008
(2)
March 2008
(9)
February 2008
(1)
December 2007
(1)
April, 2009
TechNet Blogs
>
Jonathan Almquist on Operations Manager
>
April, 2009
Jonathan Almquist on Operations Manager
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Jonathan Almquist on Operations Manager
Logical Disk Free Space Monitor
Posted
over 4 years ago
by
Jonathan Almquist
44
Comments
Throughout my years working with MOM and Operations Manager 2007, periodically I hear complaints about Operations Manager not alerting on low disk space conditions, or that administrators are receiving false alerts. Just about every time I've been called...
Jonathan Almquist on Operations Manager
All disk sizes (GB)
Posted
over 4 years ago
by
Jonathan Almquist
15
Comments
/*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...
Jonathan Almquist on Operations Manager
Exclude Drive from Logical Disk Free Space Monitoring: Part 1
Posted
over 4 years ago
by
Jonathan Almquist
13
Comments
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...
Jonathan Almquist on Operations Manager
How to measure Operations Manager database performance
Posted
over 4 years ago
by
Jonathan Almquist
5
Comments
In order to make any kind of performance tuning recommendations, it is first necessary to capture a baseline of normal operating conditions. What I’d like to demonstrate in this post is how to measure the performance of your Operations Manager database...
Jonathan Almquist on Operations Manager
Operations Manager 2007 SQL Queries
Posted
over 4 years ago
by
Jonathan Almquist
4
Comments
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...
Jonathan Almquist on Operations Manager
Agent Failover Status
Posted
over 4 years ago
by
Jonathan Almquist
2
Comments
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...
Jonathan Almquist on Operations Manager
All groups and their contained instances
Posted
over 4 years ago
by
Jonathan Almquist
2
Comments
SELECT SourceMonitoringObjectDisplayName AS 'Group', TargetMonitoringObjectDisplayName AS 'Member' FROM RelationshipGenericView WHERE (SourceMonitoringObjectDisplayName...
Jonathan Almquist on Operations Manager
Top 10 Events
Posted
over 4 years ago
by
Jonathan Almquist
2
Comments
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 ...
Jonathan Almquist on Operations Manager
Get Failover MS List for Agent Computer
Posted
over 4 years ago
by
Jonathan Almquist
0
Comments
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
Jonathan Almquist on Operations Manager
Get Alert History by Alert Name
Posted
over 4 years ago
by
Jonathan Almquist
0
Comments
get-alert | where {$_.name -match " Alert Name "} | get-AlertHistory | select Time* command shell main menu
Jonathan Almquist on Operations Manager
All groups
Posted
over 4 years ago
by
Jonathan Almquist
0
Comments
SELECT ManagedEntityGenericView.DisplayName, ManagedEntityGenericView.FullName FROM ManagedEntityGenericView INNER JOIN ...
Jonathan Almquist on Operations Manager
Return discoveries running on specific interval
Posted
over 4 years ago
by
Jonathan Almquist
0
Comments
Got a new one today. HTH. Foreach ($discovery in (get-discovery | foreach-object {$_.DataSource})) { if ($discovery.Configuration -match "IntervalSeconds> seconds <") ...
Jonathan Almquist on Operations Manager
What does this task target?
Posted
over 4 years ago
by
Jonathan Almquist
0
Comments
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...
Jonathan Almquist on Operations Manager
Switch to another MG in Command Shell session
Posted
over 4 years ago
by
Jonathan Almquist
0
Comments
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...
Jonathan Almquist on Operations Manager
Command Shell: Be careful with Date-Time criteria and calculations
Posted
over 4 years ago
by
Jonathan Almquist
0
Comments
Nathan left a comment on one of my posts the other day. See thread: Is alert grooming working? Well, Nathan helped me find a problem with my script. The problem was the Date-Time criteria I was using for my calculations to verify whether or...
Page 1 of 1 (15 items)