SQL Queries Archives - System Center Central

Sample scripts to compare agents and management packs between management groups in Operations Manager

Posted by Cameron Fuller on June 23rd, 2014

The SQL and PowerShell scripts can be used to compare management packs loaded into two different management groups and agents reporting into two different management groups. Both PowerShell and SQL options are available in the zip file.

CSV Free Space SQL Query

Posted by Jan Struwig on May 2nd, 2013

CSV Free Space Query, execute this script against your OpsMgrDB (Operational) to return results for Cluster Shared Volumes Free Space. Very useful if you want to create a report for CSV Free Space similar to the Disk Free Space Report. Below is a screenshot of the information displayed when using the query to create a […]

SQL Queries for Operations Manager

Posted by Pete Zerger on May 9th, 2011

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: […]