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
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
Desired Configuration Management View Sample Queries
Mobile Device Management View Sample Queries
Network Access Protection View Sample Queries
Hardware Inventory View Sample Queries
Software Inventory View Sample Queries