Exporting Report Data

Exporting to Excel

#380120

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.

The following options are covered here:

Exporting Tabular Reports

Note: The pop-up blocker must be turned off for all 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 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 Breakdown and Details Reports

You can export the content from the Cluster Breakdown, Namespace Breakdown and Details tabs to see the full set of data.  Data can be export to XLSX format. Some tabular reports may support PDF format, but not all, due to sizing limitations.

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

Note: Currently, when you export the contents of Details tab, the resulting Excel extract may not exactly match the counts displayed on the dashboard. This page is still under development. Contact Support@Densify.com for details.

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.