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: http://www.microsoft.com/downloads/details.aspx?familyid=9d6f3a2f-52c6-4574-b8b0-16846da2fc55&displaylang=en.
The document is also available to read online by going to the Operate SMS or Technical Reference section at: http://www.microsoft.com/technet/prodtechnol/sms/sms2003/default.mspx.
Let us know what you think!
Doug Eby, MCSE, MCP
Senior Technical Writer
Windows & Enterprise Management Division – UA
Thanks for the post, but the links on the MSFT sit don't work. Will check back...
Nice work Doug and team! The download is not up yet but you can view it on the site. Original source:
PingBack from http://systemcenter.wordpress.com/2006/09/12/using-sms-2003-sql-views-to-create-custom-reports/