Sample Queries Using the Configuration Manager SQL Views
Updated: January 1, 2014
Applies To: System Center 2012 Configuration Manager, System Center 2012 Configuration Manager SP1, System Center 2012 R2 Configuration Manager
This section provides sample queries for many System Center 2012 Configuration Manager SQL view categories, to help demonstrate how the views can be joined to other views when creating reports.
In This Section
Sample Queries for Application Management in Configuration Manager
Sample Queries for Client Deployment in Configuration Manager
Sample Queries for Compliance Settings in Configuration Manager
Sample Queries for Content Management in Configuration Manager
Sample Queries for Endpoint Protection in Configuration Manager
Sample Queries for Mobile Device Management in Configuration Manager
Sample Queries for Network Access Protection in Configuration Manager
Sample Queries for Operating System Deployment in Configuration Manager
Sample Queries for Power Management in Configuration Manager
Sample Queries for Site Administration in Configuration Manager
Sample Queries for Software Metering in Configuration Manager
Sample Queries for Software Updates in Configuration Manager
Sample Queries for Status and Alerts in Configuration Manager