This document provides an overview of the WMI and SMS SQL view schemas, an overview of typical SQL statements that are used when creating reports, an overview of the built-in reports and associated components for creating reports, a demonstration of how the views can be joined to other views to retrieve the desired data, and detailed information about the SMS views and view categories.

Using SMS 2003 SQL Views to Create Custom Reports