5.9.2 Outputting the content of the integrated monitoring database to a CSV file
This subsection explains how to output the content of the integrated monitoring database to a CSV file. For details about the CSV output format and information that can be output in the CSV format, see 3.12.2 Saving event information in the integrated monitoring database (CSV report) in the Job Management Partner 1/Integrated Management - Manager Overview and System Design Guide.
To output information to a CSV file:
-
Specify the attributes of the JP1 events to be output to a CSV file in the jcoevtreport command.
-
Output range
You can specify the output range by specifying the output-target start date option (-s) and the output-target end date option (-e) in the jcoevtreport command.
Also, by specifying the filtering option (-f) in the jcoevtreport command, you can output to a CSV file only those JP1 events that match the condition specified by the system administrator.
Additionally, by specifying the output-and-save output option (-save) in the jcoevtreport command, you can output and save the information of JP1 events registered in the integrated monitoring database. The system administrator can retain information on all JP1 events by regularly outputting and saving this information.
-
Output content
By specifying the output item option (-k) in the jcoevtreport command, you can narrow the information specific to the JP1 events that are to be output to a CSV file.
Furthermore, by specifying the maintenance information output option (-sys) in the jcoevtreport command, you can output to a CSV file the maintenance information on the JP1 events registered in the integrated monitoring database. Since the purpose of outputting the maintenance information is to collect data in the event of an error in the integrated monitoring database, you cannot specify or filter output items.
-
Output destination
For ease of handling, the jcoevtreport command outputs JP1 event information to a separate CSV file each time it is executed. By specifying the -o option in the jcoevtreport command, you can change the name of an output destination file. Output destination file names use the following format: output-file-name_serial-number.csv.
For details about the jcoevtreport command, see jcoevtreport (1. Commands) in the manual Job Management Partner 1/Integrated Management - Manager Command and Definition File Reference.
-
-
Execute the jcoevtreport command to output the JP1 event information registered in the integrated monitoring database to CSV files.