Skip to main content
Active IQ Unified Manager 9.13

Creating a report to show aggregate total versus available capacity charts


You can create a report to analyze storage total and committed capacity in an Excel chart format.

What you'll need

  • You must have the Application Administrator or Storage Administrator role.

Use the following steps to open a Health: All Aggregates view, download the view in Excel, create a total and committed capacity chart, upload the customized Excel file, and schedule the final report.

  1. In the left navigation pane, click Storage > Aggregates.

  2. Select Reports > Download Excel.

    A UI screenshot that shows how to download excel from reports.

    Depending on your browser, you might need to click OK to save the file.

  3. In Excel, open the downloaded file.

  4. If needed, click Enable Editing.

  5. On the data sheet, right-click the Type column and select Sort > Sort A to Z.

    A UI screenshot that shows how to select sort in the type column.

    This will arrange your data by storage type, such as:

    • HDD

    • Hybrid

    • SSD

    • SSD (FabricPool)

  6. Select the Type, Total Data Capacity, and Available Data Capacity columns.

  7. On the Insert menu, select a 3-D column chart.

    The chart appears on the data sheet.

    A UI screenshot that shows the 3D column chart.
  8. Right-click the chart and select Move Chart.

  9. Select New sheet and name the sheet Total Storage Charts.


    Make sure the new sheet appears after the info and data sheets.

  10. Name the chart title Total versus Available Capacity.

  11. Using the Design and Format menus, available when the chart is selected, you can customize how the chart looks.

  12. When satisfied, save the file with your changes. Do not change the file name or location.

    A UI screenshot that shows total versus available capacity chart.
  13. In Unified Manager, select Reports > Upload Excel.


    Make sure you are in the same view where you downloaded the Excel file.

  14. Select the Excel file you have modified.

  15. Click Open.

  16. Click Submit.

    A check mark appears beside the Reports > Upload Excel menu item.

    A UI screenshot that shows how to upload excel to reports.
  17. Click Scheduled Reports.

  18. Click Add Schedule to add a new row to the Report Schedules page so that you can define the schedule characteristics for the new report.


    Select the XLSX format for the report.

  19. Enter a name for the report schedule and complete the other report fields, then click the check mark (blue check) at the end of the row.

    The report is sent immediately as a test. After that, the report generates and is sent by email to the recipients listed using the specified frequency.

Based on the results shown in the report, you might want to balance the load on your aggregates.