Exporting Report Data

Exporting to Excel


You can export most tabular reports to Microsoft® Excel . Dashboards and drill-down pages that support export functionality have the export to Excel icon available in the toolbar. You may also see the download to CSV icon

The following options are covered here:

Exporting Public Cloud Tabular Reports

Note: The pop-up blocker must be turned off for Densify in all supported browsers.

The process below and any limitations are the same for all public and private cloud tabular reports.

  1. In the Densify Console navigate to the cloud report you want to export.
  2. Define the scope of your report, if applicable. For example, using one or more of the following filters:
  3. Click the Export to Excel button located at the top-right of the toolbar. This button is disabled when there is no data to export or if export is not supported for the dashboard/page. Tabular data is exported to an Excel spreadsheet. Charts and graphs are not currently exported.
  4. You can see the progress of the export in the lower left corner of your browser window. Save the Excel spreadsheet file with a new name.

The export file is appropriately named and is saved to the download folder defined by your browser. The file includes all pages of the report. The first row of the spreadsheet includes the name of the dashboard or page, the date and time of the export and the name of the user who exported the data.

When you are exporting filtered lists, only the systems that match the filtering criteria are exported to the Excel file. When working with the guest filter and dynamic attributes, you may want to refresh the list before exporting it. See Using the Guest Filter

Exporting from the Instance Optimization Details Pages

Due to the volume of data being aggregated and formatted, when exporting tables from the Instance Optimization Details page, you may see the following message:

This message indicates that the report is being built in the background. To view the report:

  1. Click OK to close the warning message.
  2. Allow a few minutes for the report generation to complete. This will take, on average 3-5 min or up to 10 min, depending on the number of records in the report. You can navigate away from this page and return to view the export progress.
  3. Click the Export icon again, while your session is still active, to view the generated report.

Exporting Container Reports

Cluster Breakdown and Namespace Breakdown Tabs

You can export the content from the Cluster Breakdown, Namespace Breakdown tabs to see the full set of data.  Data can be export to XLSX format.

Click the Export to Excel () icon to export the tabular data.

Data Tab

When viewing the Data tab, you can configure the tabular data using the filters, grouping options and data controls and then export the data to a .CSV file.

Click the download to .CSV icon () to export the content of the currently displayed table to .CSV format.

Details Tab

When you are viewing the Details report, all of container data will be exported from this tab. Even if the Details report is filtered, (i.e. as from the Data tab) the complete set of unfiltered data is exported.

Click the Export to Excel () icon to export the tabular data.

Note: Currently, when you export the contents of the Details tab, the resulting Excel extract may not exactly match the counts displayed on the dashboard. This page is still under development. Contact [email protected] for details. [CRB-50345, CRB-45436] While the Details page uses the RDB data, the export still references live attributes. Additionally the exported data is missing some columns, and as a result the extract shows data with "Current Size", from the latest data load which is different from the older data that is in the RDB. This is why the dashboard report counts do not match the exported data.

Exporting Cloud Cost Reports

You can export the content of any of the Cloud Cost reports by clicking the export icon, located on the right side of the page.

You can export the content from both the tabular view and the drilled down details report to see the full set of data. Data can be export to CSV or XLSX formats. Some tabular reports may support PDF format, but not all, due to sizing limitations. Data exported to .XLSX is not paginated.

Charts can only be exported to PDF format. The currently displayed chart type is exported to PDF. Charts can also be exported as .CSV and .XLSX. In this case, you will get the tabular data on which the chart is based.

You may need to scroll horizontally to see the download icon on some Cloud Cost tabular reports due to the amount of data on the screen.

Review and change the filename before saving the file, exports from the same page/report will have the same filename and will overwrite an existing, saved report.