Peter Jane wrote a small guide on how to create queries in System Center Configuration Manager 2012. This guide is perfect for beginners in SCCM 2012 or 2007.
More Useful Orchestrator Database Queries
Orchestrator team blog is publishing article after article and this is a sign that the community is getting stronger. Find out the most useful Orchestrator Database Queries.
SQL queries for SCOM and PowerShell script for monitor performance counters
Here are the two scripts:
- SQL queries to get data from SCOM Databases:
- PowerShell script to get CPU, Memory and Storage performance values: