Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

Microsoft Systems Management Server (SMS) 2003 Reporting uses Microsoft SQL Server views to provide access to data from the tables in the SMS site SQL database and to offer an efficient reporting option. The SMS site SQL database contains a large collection of information about the network, computers, users, user groups, and many other components of the computing environment. This database also contains objects that represent SMS items such as advertisements, packages, queries, reports, and status messages.
SMS administrators need to understand the different categories of the views, how they are related to Windows Management Instrumentation (WMI), and how they can be used to create effective reports. 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.

Files

Status: Deleted This download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to December 2014.

No files found

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

Microsoft Word or Word Viewer

1. Click the Download button in the upper right-hand corner of this page to start the download.
2. Do one of the following:

• To start the installation immediately, click Open or Run this program from its current location.
• To copy the download to your computer for installation at a later time, click Save or Save this program to disk.