DOCUMENT:Q276271 06-AUG-2002 [sms] TITLE :SMS: Using the SMS Extract Utility for SMS Reporting PRODUCT :Microsoft Systems Management Server PROD/VER::2.0 OPER/SYS: KEYWORDS:kbsms200 ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft Systems Management Server version 2.0 ------------------------------------------------------------------------------- SUMMARY ======= You can use the Microsoft BackOffice Resource Kit SMS Extract utility to produce reports in Microsoft Excel. You cannot produce new queries with this tool, however, you can find the results of any existing query. MORE INFORMATION ================ To import the results of an existing SMS query into an Excel workbook, follow these steps: 1. In Excel 97, on the File menu, click New. 2. Click the Smsextract.xlt template on which to base the new workbook. 3. Depending on your Excel settings, when you create the new workbook, a dialog box may appear that states that the workbook, which you are opening, contains macros. If you want to use this tool, click Enable Macros. If you do not want to run the macros immediately, you can run the ThisWorkbook.Workbook_Open macro at a later time. When the ThisWorkbook.Workbook_Open macro runs, the SMS Login dialog box opens. 4. In the SMS Login dialog box, type the name of the site system that is acting as your site server (do not use leading slashes), your user name (in domain\user syntax), and password. Click OK. The first time you run this tool, you will see a period (.) as the server name value, and SMSDEMO as the user name value. Replace these values by entering your own values for server, and user name. The values that you supply are saved in the registry of the computer that you are using when you run this tool. The next time you use this tool, it obtains the appropriate server, and user name from the registry. Even if you create a new workbook from the template, the server, and user name are read from the registry values of the computer on which you are working. Note: The SMS site administrator must grant WMI permissions to your user account, either by membership in a group that has been granted rights, or individually. 5. The "Select Site Query to Import" dialog box opens. This dialog box displays all the SMS queries that are found on the specified site server. Choose one or more queries to import. By using the CTRL key, you can choose multiple queries. When you have finished choosing the queries that you want to import, click OK. The workbook imports the results returned by each selected query. The result set of each query is displayed in an individual worksheet within the workbook. The columns display the class attribute that are being queried; for each row, there is an instance of data that is returned by the query for that attribute, as shown in the following figure. If a query, such as the "All Systems with Specified Software File Name and File Size" query, requires input, a dialog box appears so that you can type in the necessary value. You are notified when any query returns an empty result, and the tool skips the display of that query. 6. Save the workbook by either accepting the default file name, or by specifying a new file name. You can open, and run a previously saved Query Extract workbook. When you do so, you are prompted to choose whether to resave, or discard the previous data. If you save the data, new spreadsheets are added to the workbook to hold additional result sets. If you choose to discard the data, the old data is removed, and the new workbook will contain only the newly-imported query results. REFERENCES ========== For information about granting rights to WMI data, and the SMS Provider, see Chapter 19, "Creating Administrative Reports," in the Microsoft Systems Management Server 2.0 Administrator's Guide. Additional query words: prodsms extract report reporting ====================================================================== Keywords : kbsms200 Component : ResKit-SupportTool SystemManagement Technology : kbSMSSearch kbSMS200 Version : :2.0 Issue type : kbhowto ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 2002.