Cisco Cisco Content Security Management Appliance M390 Guía Del Usuario
3-11
AsyncOS 8.1 for Cisco Content Security Management User Guide
Chapter 3 Working With Reports
Exporting Report Data as a Comma-Separated Values (CSV) File
You can export raw data to a comma-separated values (CSV) file, which you can access and manipulate
using database applications such as Microsoft Excel. For different ways to export data, see
using database applications such as Microsoft Excel. For different ways to export data, see
Because CSV exports include only raw data, exported data from a web-based report page may not
include calculated data such as percentages, even if that data appears in the web-based report.
include calculated data such as percentages, even if that data appears in the web-based report.
For email message tracking and reporting data, the exported CSV data will display all data in GMT
regardless of what is set on the Security Management appliance. This simplifies using data
independently from the appliance, particularly when referencing data from appliances in multiple time
zones.
regardless of what is set on the Security Management appliance. This simplifies using data
independently from the appliance, particularly when referencing data from appliances in multiple time
zones.
The following example is an entry from a raw data export of the Anti-Malware category report, where
Pacific Daylight Time (PDT) is displayed as GMT - 7 hours:
Pacific Daylight Time (PDT) is displayed as GMT - 7 hours:
Begin Timestamp, End Timestamp, Begin Date, End Date, Name, Transactions Monitored,
Transactions Blocked, Transactions Detected
1159772400.0, 1159858799.0, 2006-10-02 07:00 GMT, 2006-10-03 06:59 GMT, Adware, 525,
2100, 2625
Note
Category headers are different for each type of report.
If you export localized CSV data, the headings may not be rendered properly in some browsers. This
occurs because some browsers may not use the proper character set for the localized text. To work around
this problem, you can save the file to your local machine, and open the file on any web browser using
File > Open. When you open the file, select the character set to display the localized text.
If you export localized CSV data, the headings may not be rendered properly in some browsers. This
occurs because some browsers may not use the proper character set for the localized text. To work around
this problem, you can save the file to your local machine, and open the file on any web browser using
File > Open. When you open the file, select the character set to display the localized text.
Table 3-6
Viewing Raw Data Entries
Category Header
Value
Description
Begin Timestamp
1159772400.0
Query start time in number of seconds from
epoch.
epoch.
End Timestamp
1159858799.0
Query end time in number of seconds from
epoch.
epoch.
Begin Date
2006-10-02 07:00 GMT
Date the query began.
End Date
2006-10-03 06:59 GMT
Date the query ended.
Name
Adware
Name of the malware category.
Transactions Monitored
525
Number of transactions monitored.
Transactions Blocked
2100
Number of transactions blocked.
Transactions Detected
2625
Total number of transactions:
Number of transactions detected + Number of
transactions blocked.
transactions blocked.