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