Reporting quick start

Create a sample custom report to experience exploring views and scheduling reports. This quick start report finds a list of volumes that you might want to move to the cloud tier because there is a fair amount of inactive (cold) data. You will open the Performance: All Volumes view, customize the view using filters and columns, save the custom view as a report, and schedule the report to share once a week.

Before you begin

About this task

Follow the steps below to:

Procedure

  1. In the left navigation pane, click Storage > Volumes.
  2. In the View menu, select Performance > All Volumes.
  3. Click Show/Hide to make sure the Disk Types column appears in the view.
    Add or remove other columns to create a view that contains the fields that are important for your report.
  4. Drag the Disk Types column next to the Cloud Recommendation column.
  5. Click the filter icon to add the following three filters, and then click Apply Filter:
    • Disk Types contains FabricPool
    • Cloud Recommendation contains tier
    • Cold Data greater than 10 GB
    Note that each filter is joined with a logical AND so that all volumes returned must meet all the criteria. You can add a maximum of five filters.
  6. Click the top of the Cold Data column to sort the results so that the volumes with the most cold data appear at the top of the view.
  7. When the view is customized, the view name is Unsaved View. Name the view to reflect what the view is showing, for example Vols change tiering policy. When done, click the check mark or press Enter to save the view with the new name.
  8. Download the report as a CSV, Excel, or PDF file to see the output before you schedule or share it.
    Open the file with an installed application, such as Microsoft Excel (CSV or Excel) or Adobe Acrobat (PDF), or save the file.
    Note: You can further customize your report using complex filters, sorts, pivot tables, or charts by downloading the view as an Excel file. After you open the file in Excel, use the advanced features to customize your report. When satisfied, upload the Excel file. This file, with its customizations, is applied to the view when the report is run.

    For more information on customizing reports using Excel, see Sample Microsoft Excel reports.

  9. Click the Scheduled Reports button on the inventory page. All scheduled reports relating to the object, in this case volumes, appear in the list.
  10. Click Add Schedule to add a new row to the Report Schedules page so you can define the schedule characteristics for the new report.
  11. Enter a name for the report and complete the other report fields, then click the check mark () 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.

    The following sample report is in CSV format:

    The following sample report is in PDF format:

After you finish

Based on the results shown in the report, you might want to use ONTAP System Manager or the ONTAP CLI to change the tiering policy to auto or all for certain volumes to offload more cold data to the cloud tier.