5.9.2 Exporting reports in CSV or HTML format by using a command
By using the jpcrpt command, you can implement batch processing that outputs a report to a file regularly at a predetermined time, or outputs multiple reports to a file in one operation. The jpcrpt command outputs reports in CSV or HTML format. The report types that the jpcrpt command can output depend on the version of PFM - Web Console. The following table describes which report types can be output by which versions of PFM - Web Console.
Type of output |
08-00 |
08-11 or later |
|
---|---|---|---|
Report |
CSV output |
Yes |
Yes |
HTML output |
No |
Yes |
|
Registered report |
CSV output |
No |
Yes |
HTML output |
No |
Yes |
|
Combination report |
HTML output |
No |
Yes |
For details on the jpcrpt command, see the manual JP1/Performance Management Reference.
- Notes:
-
When you output a report in CSV format, the following field information appears in the file even if it is not selected for report output.
-
In realtime reports
The Record Time field and ODBC key field information are appended to the file.
-
In historical reports (for a single agent)
The Date and Time field and ODBC key field information are appended to the file.
-
In historical reports (for multiple agents)
The Date and Time field, Agent Host field, Agent Instance field and ODBC key field information are appended to the file.
For details on ODBC key fields, see the documentation for PFM - Agent.
-