Appendix B: SMS SQL View Sample Queries
Appendix A provided detailed information about the Microsoft Systems Management Server (SMS) SQL view categories, what kind of data each view contains, and what view columns can be joined to other views in queries and reports. To help demonstrate how the views can be joined to other views when creating reports, this appendix provides sample queries for each view category.
Provides sample queries for discovery views.
Hardware Inventory View Sample Queries
Provides sample queries for hardware inventory views.
Software Inventory View Sample Queries
Provides sample queries for software inventory views.
Provides sample queries for status views.
Collection View Sample Queries
Provides sample queries for collection views.
Provides sample queries for the query view.
Provides sample queries for report views.
Provides sample queries for security views.
Provides sample queries for site views.
Software Distribution View Sample Queries
Provides sample queries for software distribution views.
Software Metering View Sample Queries
Provides sample queries for software metering views.
Software Update View Sample Queries
Provides sample queries for software update views.