SMS: Query Results Display Only First Data Record

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."