Using SMS 2003 SQL Views to Create Custom Reports



A new document has been released to the Web that 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, examples of how the views can be joined to other views to retrieve desired data, and detailed information about the SMS views and view categories.


The document can be downloaded at:


The document is also available to read online by going to the Operate SMS or Technical Reference section at:


Let us know what you think!




Doug Eby, MCSE, MCP

Senior Technical Writer

Windows & Enterprise Management Division – UA



Comments (3)

  1. Anonymous says:

    Nice work Doug and team! The download is not up yet but you can view it on the site. Original source:

  2. Brian Tucker says:

    Thanks for the post, but the links on the MSFT sit don’t work. Will check back…