Sample Queries Using the Configuration Manager SQL Views

Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2

Appendix A provides sample queries for each Configuration Manager 2007 SQL view category, to help demonstrate how the views can be joined to other views when creating reports.

In This Section

Site View Sample Query

Status View Sample Queries

Client Health View Sample Queries

Collection View Sample Queries

Software Distribution View Sample Queries

Software Updates View Sample Queries

Operating System Deployment View Sample Queries

Asset Intelligence View Sample Query

Software Metering View Sample Queries

Reporting View Sample Queries

Desired Configuration Management View Sample Queries

Query View Sample Query

Mobile Device Management View Sample Queries

Network Access Protection View Sample Queries

Discovery View Sample Queries

Hardware Inventory View Sample Queries

Software Inventory View Sample Queries

Wake On LAN View Sample Queries

Security View Sample Queries

See Also

Concepts

SMS Provider WMI Schema Reference

Other Resources

Scenarios for Creating Custom Reports
Exercises for Creating Custom Reports
SQL Server Reference

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, e-mail SMSdocs@microsoft.com.