SQL Queries

CSV Free Space SQL Query

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

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