Cisco Cisco Content Security Management Appliance M1070 ユーザーガイド
3-9
Cisco IronPort AsyncOS 8.0 for 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
(Web Security) A custom
subset of report data, for
example data for a particular
user.
subset of report data, for
example data for a particular
user.
•
•
In Web Tracking, perform a
search, then click the
Printable Download link on
the Web Tracking page.
Choose PDF or CSV format.
search, then click the
Printable Download link on
the Web Tracking page.
Choose PDF or CSV format.
PDFs may not include all information
available on the web page. Specifically, PDFs
include:
available on the web page. Specifically, PDFs
include:
•
Up to 1,000 transactions.
•
If you display details, up to 100 related
transactions.
transactions.
•
Up to 3000 characters per related
transaction.
transaction.
CSV files include all raw data matching the
search criteria.
search criteria.
(Email Security) A custom
subset of data, for example
data for a particular user.
subset of data, for example
data for a particular user.
•
In Message Tracking,
perform your search, then
click the Export link above
the search results.
perform your search, then
click the Export link above
the search results.
Message tracking search results and CSV file
include up to 1000 results, depending on the
limit you specified in your search criteria.
include up to 1000 results, depending on the
limit you specified in your search criteria.
Table 3-5
Printing and Exporting Report Data (continued)
To Get This
PDF
CSV
Do This
Notes
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.