Job Management Partner 1/Performance Management User's Guide

12.3 Example of using Microsoft Excel to extract performance data

This section describes an example of using Microsoft Excel in Windows, to extract performance data of Performance Management.

To extract the CPU usage of a Web application server, as collected by PFM - Agent for Platform (Windows), into a Microsoft Excel worksheet:

1. In Microsoft Excel, choose Data, Get External Data, and then New Database Query.
   The Choose Data Source dialog box appears.
   
2. Click the Databases tab.
   The Databases tab appears.
   
3. Choose 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.

   Point:

   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 12.4.4 Specifying common key fields.

6. Click the Next button.
   The Query Wizard - Extract Data dialog box appears.
   
7. Specify the conditions for extracting the data.
   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.
   The Query Wizard - Sort Order Settings dialog box appears.
   
9. Specify the sort order of data to be extracted.
10. Click the Next button.
    The Query Wizard - Finish dialog box appears.
    
11. Select Return data to Microsoft Excel and click the Finish button.
    When the query wizard finishes, the Query Wizard terminates and the Extract External Data to Microsoft Excel dialog box appears.
    
12. Specify the output destination for data to be extracted and then click the OK button.
    The extracted performance data is output to the specified output destination.
    

[Contents][Back][Next]

All Rights Reserved. Copyright (C) 2009, Hitachi, Ltd.