Csv file generator report, Generating a csv file generator report, Generating an sql queries list – HP Insight Control User Manual
Page 35: Sample performance management csv file
Performance management Summary Report for 131.111.1.73 Hardware Configuration as of 03/16/2004
Reporting from 03/16/2004 to 03/19/2004
% Major
% Minor
% Normal
Subsystem
0
4.0
96.0
Processors
CSV File Generator report
CSV File Generator generates comma-separated value (CSV) files for importing into desktop analysis or
reporting tools. The CSV file documents each individual sample for every component analyzed, collecting
different measurements for each. All report formats can generate reports for either one designated system
or a group of systems as a whole.
Generating a CSV File Generator Report
1.
Select a server from the All Systems Page of Systems Insight Manager console, Reports
→Performance
Management
→CSV File Generator. A new window appears displaying the selected server that has
logged data.
2.
3.
Enter the appropriate dates in the Extract Data From and Extract Data To boxes to get the period for
which you want to generate the report.
4.
Enter an appropriate file name with a .csv extension in the File Name box.
5.
Click Generate File. The report appears in a separate browser window.
NOTE:
The report can be generated for one server at a time and for a maximum period of one month
despite the total logged duration.
Generating an SQL queries list
1.
From the CSV File Generator screen, select the server for which you want to generate a list.
2.
Click Show SQL queries. The SQL query appears in a separate browser window.
Sample performance management CSV file
Insight Control performance management enables you to generate many reports, and each user can have
a different set of requirements. Therefore, performance management supplies all performance information
gathered in a .csv file that can be read by many desktop reporting tools, including Microsoft Excel.
The following figure depicts a summary report generated in .csv file format and that appear in Microsoft
Excel. This file format contains fully annotated performance data in a table, enabling information to be
displayed and manipulated in a wide variety of data analysis and graphing applications.
CSV File Generator report
35