Data export in Management Console

You can export monthly device statistics from the Management Console to a spreadsheet in the .xlsx file format.

Export files created by the Console contain all the data that is currently displayed in the Devices table. If the data spans across multiple pages, all the pages are exported.

How to Export

  1. From the Customer list, select the customer to export statistics for
  2. If needed, apply any additional filters to change the list of devices displayed

    For example using the Account Type filter to show only Microsoft 365 devices

    You cannot use checkboxes to select devices for export

  3. From the Columns list, select all the columns you want to be displayed in the export
  4. Click the Export button on top of the Devices widget

There are two report types to choose from in here:

  1. Aggregated device statistics - This is a report of monthly device statistics which contains only selected columns in the dashboard
  2. Maximum Value report (NEW) - This is a report of monthly device statistics which contains the maximum value usage

Configure Aggregated Device Statistics report

  1. Select Aggregated device statistics under Report type
  2. Select the Export month of data to view
  3. Choose an Export Output type. This can be either:
    • One .xlsx file containing data for all customers
    • Multiple .xlsx files each one containing data for one customer
  4. Select an appropriate data size output. This can be:
    • Human readable format (Gigabytes and Terabytes)
    • Gigabytes only
    • Bytes only
  5. Click Export

When clicking Export, a file explorer box will appear to select the download location. If nothing appears, ensure your browser is set to allow pop-ups from Backup Manager.

Configuring Maximum Value reports

  1. Select Maximum Value Report under Report type
  2. Select the Export month of data to view
  3. Choose an Export Output type. This can be either:
    • One .xlsx file containing data for all customers
    • Multiple .xlsx files each one containing data for one customer
  4. Click Export

When clicking Export, a file explorer box will appear to select the download location. If nothing appears, ensure your browser is set to allow pop-ups from Backup Manager.