SMS database schema is not published

Article translations Article translations
Article ID: 185910 - View products that this article applies to.
This article was previously published under Q185910
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

SUMMARY

A common question for Systems Management Server support is "How do I run queries against the Systems Management Server database?" Another common question is "Where can I find the Systems Management Server database schema?"

MORE INFORMATION

The database schema is not published. Microsoft reserves the right to alter the database schema to improve performance or add functionality. A published schema would lend itself to static assumptions for access to Systems Management Server data. If the schema is changed, those assumptions are no longer valid.

Because the schema is not available, Microsoft strongly recommends that you not query directly against the Systems Management Server database. Instead, you should perform queries for information from the database in one of two ways. You can query internally through the Systems Management Server Administrator program, or externally by using Microsoft Excel, Microsoft Access, Microsoft SQL Server, Crystal Reports, or similar programs, and then only through the Systems Management Server Views generated by Systems Management Server SQL View Generator.

REFERENCES

For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
134717 Query results display only first data record
150814 Creating Audited Software report with Crystal Reports
153534 Retrieving SMSVIEW data using Microsoft Access
181556 Cannot query on historical inventory with SmsView.exe

Properties

Article ID: 185910 - Last Review: February 21, 2014 - Revision: 4.2
APPLIES TO
  • Microsoft Systems Management Server 2003
  • Microsoft Systems Management Server 2.0 Standard Edition
  • Microsoft Systems Management Server 1.0 Standard Edition
  • Microsoft Systems Management Server 1.1 Standard Edition
  • Microsoft Systems Management Server 1.2 Standard Edition
Keywords: 
kbnosurvey kbarchive kbdatabase kbinfo KB185910

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com