Microsoft KB Archive/134717

= SMS: Query Results Display Only First Data Record =

Article ID: 134717

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 1.0 Standard Edition
 * Microsoft Systems Management Server 1.1 Standard Edition
 * Microsoft Systems Management Server 1.2 Standard Edition

-



This article was previously published under Q134717





SYMPTOMS
When you query on a PC Architecture Group with multiple data records for its attributes, the SMS Query results display only the first data record. This may not necessarily be the value that the query was based on. However, the computer that the information was returned for is the correct computer.

The Disk, Packages, Services, and Audited Software groups could have multiple data records.



CAUSE
This is a limitation of the SMS Administrator utility.



WORKAROUND
To see the detailed information in the data record that matches the query, double click on a client in the list to reveal the Personal Computer properties for that system.

In order to view multiple data records for more than one client at a time, use a different SQL query tool that is capable of generating reports. Systems Management Server is accompanied by a copy of Crystal Reports for this purpose. It installs with a number of predefined queries and reports to view your SMS data. Other tools such as Microsoft Access or Microsoft Query are also capable of generating similar reports. Before you use those applications to query the Systems Management Server database, run SMSVIEW to create the necessary SQL views.

For more information on using SMSVIEW, query on SMSVIEW in the Microsoft Knowledgebase and see Appendix I of the Systems Management Server "Administrator's Guide."



STATUS
This is by product design.

Additional query words: prodsms sms ad-hoc wrong incorrect drive a

Keywords: kbdatabase kbinterop KB134717

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.