Sample Queries Using the Configuration Manager SQL Views

Betrifft: 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.

Inhalt dieses Abschnitts

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

Siehe auch

Konzepte

SMS Provider WMI Schema Reference

Andere Ressourcen

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

Weitere Informationen finden Sie unter Configuration Manager 2007 – Informationen und Support (möglicherweise in englischer Sprache).
Das Dokumentationsteam erreichen Sie per E-Mail unter: SMSdocs@microsoft.com