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.

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.