Exporting reports
You can export the following reports, pages, and device groups from the console:
- Most reports on the Reports page
- All pages in the Devices, Applications, and History areas
The report or page can be downloaded to your computer in any of the following file formats:
- Comma Separated Values (.csv)
- Microsoft Excel Open XML Spreadsheet (.xlsx)
- Extensible Markup Language (.xml)
If you want to change the report before you export it, you can edit the report's filters, or add or remove columns. Your changes are reflected in the exported report, even if you don't actively save your changes.
The following limitations apply to report exports:
- To ensure that the report export is successful, limit the number of report columns to 100.
- Changes to a report's sort order are not reflected in the exported report.
To export a report:
- Log in to the Secure Endpoint Console as a user with View permissions for the report or page that you want to export. To export the Actions page in the History area, you need to be granted View permissions for one of the supported actions.
-
On the navigation bar, do one of the following:
- To export a page in the Devices area, click Devices.
- To export a report, click Reports.
- To export a page in the History area, click History.
- To export a device group, click Devices and select the device group.
-
Open the report, page or device group that you want to export.
If you don't need to change any filters or columns before you export a report, you don't need to open it. In any view of the Reports page, click (Export) on the action toolbar. The Export Report dialog opens. Go to step 6.
-
To change the information included in the report before you export it, edit the report's filters and change the columns included in the report.
If you applied a custom sort order to the report's data, it's not reflected in the exported report. Sort the report's data after it's exported.
-
On the action toolbar, click (Export) to open the Export Report dialog. If the Export option isn't available, you can't export this type of report.
-
Click the Format field and select one of the following options:
Option Description CSV (.csv) with column names Exports the report (including column headers) in Comma Separated Values (.csv) file format CSV (.csv) without column names Exports the report (excluding column headers) in Comma Separated Values (.csv) file format Excel (.xlsx) Exports the report (including column headers) in Microsoft Excel Open XML Spreadsheet (.xlsx) file format
If the report contains more than 1 million rows, select the CSV format. Reports of this size are not supported in Excel.
XML (.xml) Exports the report in Extensible Markup Language (.xml) file format If you select one of the CSV options and then view the exported file in Excel, some UTF-8 characters may not display correctly. If you want to view the exported file in Excel, select the Excel option.
-
By default, all dates and times in the report are presented in the time zone set in your browser. To present them in another time zone, click the Time Zone field and do one of the following:
- To apply a new time zone to this report export only, search for and select the time zone.
-
To apply a new time zone to this report export, and set it as the default value to show in the Time Zone field for all future scheduled and exported reports:
-
Search for the time zone.
-
Hover over the time zone name and click Set default. The time zone under the field is updated to your selection.
This setting is user specific; it does not update the Time Zone field for other users.
-
To set it back to the time zone set in your browser, select Use my time zone.
-
Click
. The export process starts. Note that depending on the size of the report, it can take a few minutes for the report to download and open. The exported report is saved with the following filename:<report name>_yyyy-mm-dd-hh-mm(<time zone>).<file extension>
-
Review the report.
If you export an XML formatted report that contains a very large amount of data, we recommend using Notepad ++ to view its content.
If No data shows in a report column, this value is converted to a blank value when the report is exported.