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.
Schema View Reference
Provides reference information for the schema views.
Discovery View Reference
Provides reference information for the discovery views.
Inventory View Reference
Provides reference information for the hardware and software inventory views.
Status View Reference
Provides reference information for the status views.
Collection View Reference
Provides reference information for the collection views.
Query View Reference
Provides reference information for the query view.
Report View Reference
Provides reference information for the report views.
Security View Reference
Provides reference information for the security views.
Site View Reference
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.
Related Links