Configuration Manager Writers - Announcements, Comments and other Stuff

This blog is used by the Configuration Manager Writing team to keep you informed about the content we are writing, the availability of new documents, updates to documents, and other news. This blog is also intended to collect feedback from you our custome


Using SMS 2003 SQL Views to Create Custom Reports

  • Comments 3
  • Likes



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



Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment