SQL Queries for Operations Manager

SQL Queries for Operations Manager to use in Dashboards and Gadgets including:

  • Alerts per Day
  • Count of CU Versions in OpsMgr
  • Database Used and Free Space
  • OpsMgr Agent Health Percentage
  • Processor Utilization
  • TCP Port Query Performance
  • Top Alerts by Alert Count
  • Top Alerts by Repeat Count
  • Processor Utilization History
  • Website Current Connection History

New additions:

Alerts gathered per minute for the last hour
All Server processor utilization most recent counter
Events gathered per minute for the last hour
Top alerts generated per minute for the last hour
Top events gathered per minute for the last hour
Top performance counters gathered per minute for the last hour
Performance counters gathered per minute for the last hour