15.3 Example of using Microsoft Excel to extract performance data

The following uses Microsoft Excel 2003 as an example to show the procedure for extracting the CPU usage rate of the Web application server that was collected in PFM - Agent for Platform (Windows), to a Microsoft Excel worksheet.

1. In Microsoft Excel, choose Data, Get External Data, and then New Database Query.

2. In the Choose Data Source dialog box, click the Databases tab.

3. On the Databases page, select Performance Management.

4. Click the OK button.

   The Query Wizard - Choose Columns dialog box appears.

   In Available tables and columns, each field name of a PFM - Agent or PFM - RM record is displayed as a PFM - Manager name.

   For details on the PFM - Manager names used for each record field, see the chapters that describe records in the PFM - Agent or PFM - RM manuals.

5. In Available tables and columns, select a table and column from which data is extracted, and then click the Next button.

   The selected table and column appears in Columns in your query.

   Then, from the NT_PI table, add the following items to Columns in your query.

   Item name	Description
   PI_DATETIME	The record key indicating the record creation date and time.
   PI_PCT_TOTAL_PROCESSOR_TIME	Processor usage (%).
   PI_DEVICEID	A host name on which PFM - Agent or PFM - RM is running.

   Tip

   You must specify at least one ODBC key field for a query. If you click the Finish button without specifying any fields, the KAVE07013-E message is output. For details on ODBC key fields, see 15.4.4 Specifying common key fields.

6. Click the Next button.

7. In the Query Wizard - Extract Data dialog box, specify the conditions for data extraction.

   In Column to extract, each field name of a PFM - Agent or PFM - RM record is displayed as the PFM - Manager name.

   Note:

   Symbols that you can use to specify conditions are: =, <>, >, <=, <, and <=.

8. Click the Next button.

9. In the Query Wizard - Sort Order Settings dialog box, specify the sort order for the extracted data.

10. Click the Next button.

11. In the Query Wizard - Finish dialog box, select Return data to Microsoft Excel and then click the Finish button.

12. When the query wizard has finished, specify the output destination for the extracted data in the Extract External Data to Microsoft Excel dialog box and then click the OK button.

    The extracted performance data is output to the specified output destination.

To Page Top