Appendix A: SMS 2003 SQL Server View Reference
It is essential to know what data each of the Microsoft Systems Management Server (SMS) 2003 SQL Server views contain and how the views are related to each other to be able to effectively write queries and create reports with the desired SMS 2003 output. This appendix provides detailed information about each of the view categories, what kind of data each of the views contain, and what view column can be joined together with other views in queries and reports.
Provides reference information for the schema views.
Provides reference information for the discovery views.
Provides reference information for the hardware and software inventory views.
Provides reference information for the status views.
Provides reference information for the collection views.
Provides reference information for the query view.
Provides reference information for the report views.
Provides reference information for the security views.
Provides reference information for the site views.
Software Distribution View Reference
Provides reference information for the software distribution views.
Software Metering View Reference
Provides reference information for the software metering views.
Software Update View Reference
Provides reference information for the software update views.