Exporting Monitoring Events
With Ping Monitor, you can easily export the monitoring events to the CSV file format for future analysis or processing by an automated tool. You can export events displayed in the Events table of Statistics. To export the events, click the Export button from the toolbar. You are proposed to choose between exporting the selected events and all displayed events. Also can you press the Export button from the Organize Ribbon group on the Program page, when the view is focused. It is also possible to use the pop-up menu of the view to export events. The Export Events Wizard will appear on the screen Pic 1.
The first page of the Export Events Wizard is the welcome page used to introduce you to the feature the wizard is supposed to help you with. After reading the welcome information, press Next to continue with export.
On the next page of the Export Events Wizard, you are offered to choose a file you are going to save the events to and the CSV format options. The file path should be provided to the Export To field Pic 2. You can choose the encoding to be used for saving the data as well as the field delimiter and the text qualifier. While performing export, you may also define if you would like the column header to be present in the resulting file, which would make it easier for you to identify each column – this feature can be enabled using the Include column header option.
After you are ready with configuring the export options, press Finish to proceed with export. The file containing the events will be created in the path specified.
The CSV file with the connectivity events consists of four columns, which are the following:
Index |
Header |
Description |
|---|---|---|
1 |
Type |
The type of the generated connectivity event. |
2 |
Host |
The host the event is generated for. |
3 |
Description |
The logged event description. |
4 |
Time |
The time when the event was logged. |
Sample exported data in the CSV format
"Type","Host","Description","Time" "Up","h-00632.emcosoftware.com","The state of the 'h-00632.emcosoftware.com' host was changed to 'Up'. The connection was restored after being down for 00:00:19.","2019-08-05 02:12:19" "Down","h-00632.emcosoftware.com","The state of the 'h-00632.emcosoftware.com' host was changed to 'Down'. The connection was lost. Ping reply was not received within the allotted time (IP status: 11010).","2019-08-05 02:12:00" "Up","h-00261.emcosoftware.com","The state of the 'h-00261.emcosoftware.com' host was changed to 'Up'. The connection was restored after being down for 00:00:09.","2019-08-05 02:11:55" "Down","h-00261.emcosoftware.com","The state of the 'h-00261.emcosoftware.com' host was changed to 'Down'. The connection was lost. Ping reply was not received within the allotted time (IP status: 11010).","2019-08-05 02:11:46" "Down","h-00434.emcosoftware.com","The state of the 'h-00434.emcosoftware.com' host was changed to 'Down'. The connection was lost. Ping reply was not received within the allotted time (IP status: 11010).","2019-08-05 02:11:45" "Up","h-00986.emcosoftware.com","The state of the 'h-00986.emcosoftware.com' host was changed to 'Up'. The connection was restored after being down for 00:00:18.","2019-08-05 02:11:38" "Up","h-00632.emcosoftware.com","The state of the 'h-00632.emcosoftware.com' host was changed to 'Up'. The connection was restored after being down for 00:00:39.","2019-08-05 02:11:29" "Down","h-00986.emcosoftware.com","The state of the 'h-00986.emcosoftware.com' host was changed to 'Down'. The connection was lost. Ping reply was not received within the allotted time (IP status: 11010).","2019-08-05 02:11:20" "Up","h-00897.emcosoftware.com","The state of the 'h-00897.emcosoftware.com' host was changed to 'Up'. The connection was restored after being down for 00:00:09.","2019-08-05 02:11:14" "Down","h-00897.emcosoftware.com","The state of the 'h-00897.emcosoftware.com' host was changed to 'Down'. The connection was lost. Ping reply was not received within the allotted time (IP status: 11010).","2019-08-05 02:11:05" "Down","h-00632.emcosoftware.com","The state of the 'h-00632.emcosoftware.com' host was changed to 'Down'. The connection was lost. Ping reply was not received within the allotted time (IP status: 11010).","2019-08-05 02:10:50" "Up","h-00484.emcosoftware.com","The state of the 'h-00484.emcosoftware.com' host was changed to 'Up'. The connection was restored after being down for 00:00:09.","2019-08-05 02:10:36" |
The CSV file with the host monitoring events consists of five columns, which are the following:
Index |
Header |
Description |
|---|---|---|
1 |
Title |
The logged event title. |
2 |
Severity |
The logged event severity level. |
3 |
Description |
The logged event description. |
4 |
Time |
The time when the event was logged. |
5 |
Error Code |
The error code for the event, if any. |
Sample exported data in the CSV format
"Title","Severity","Description","Time","Error Code" "Connection Quality","Information","The connection quality for the 'h-00020.emcosoftware.com' host was changed to 'Warning'.","2019-08-05 01:43:50", "Host State","Information","The state of the 'h-00020.emcosoftware.com' host was changed to 'Up'. The connection was restored after being down for 00:00:09.","2019-08-05 01:41:40", "Host State","Warning","The state of the 'h-00020.emcosoftware.com' host was changed to 'Down'. The connection was lost. Ping reply was not received within the allotted time (IP status: 11010).","2019-08-05 01:41:31", "Connection Quality","Information","The connection quality for the 'h-00020.emcosoftware.com' host was changed to 'Bad'.","2019-08-05 01:41:21", "Connection Quality","Information","The connection quality for the 'h-00020.emcosoftware.com' host was changed to 'Warning'.","2019-08-05 01:38:40", "Host State","Information","The state of the 'h-00020.emcosoftware.com' host was changed to 'Up'. The connection was restored after being down for 00:00:09.","2019-08-05 01:37:00", "Host State","Warning","The state of the 'h-00020.emcosoftware.com' host was changed to 'Down'. The connection was lost. Ping reply was not received within the allotted time (IP status: 11010).","2019-08-05 01:36:51", "Connection Quality","Information","The connection quality for the 'h-00020.emcosoftware.com' host was changed to 'Bad'.","2019-08-05 01:36:46", "Connection Quality","Information","The connection quality for the 'h-00020.emcosoftware.com' host was changed to 'Warning'.","2019-08-05 01:31:04", "Host State","Information","The state of the 'h-00020.emcosoftware.com' host was changed to 'Up'. The connection was restored after being down for 00:00:59.","2019-08-05 01:28:29", |