Using SMS 2003 SQL Views to Create Custom Reports
Brief Description
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.
On This Page
Quick Details
| File Name: | SMS2003CustomReports.exe |
| Version: | 1.0 |
| Date Published: | 9/12/2006 |
| Language: | English |
| Download Size: | 176 KB |
| Estimated Download Time: | 1 min 56K |
Overview
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. 
Top of page
System Requirements
- Supported Operating Systems: Windows XP
Microsoft Word or Word Viewer Top of page
Instructions
- Click the Download button in the upper right-hand corner of this page to start the download.
- 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.
Top of page
What Others Are Downloading
Top of page
