Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 185910 - Last Review: February 25, 2007 - Revision: 4.2
SMS database schema is not published
This article was previously published under Q185910
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?"
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.
For more
information, click the following article numbers to view the articles in the
Microsoft Knowledge Base:
134717Â
(http://kbalertz.com/Feedback.aspx?kbNumber=134717/
)
Query results display only first data record
150814Â
(http://kbalertz.com/Feedback.aspx?kbNumber=150814/
)
Creating Audited Software report with Crystal Reports
153534Â
(http://kbalertz.com/Feedback.aspx?kbNumber=153534/
)
Retrieving SMSVIEW data using Microsoft Access
181556Â
(http://kbalertz.com/Feedback.aspx?kbNumber=181556/
)
Cannot query on historical inventory with SmsView.exe
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
| kbdatabase kbinfo KB185910 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate