topic Re: OCUM 7.2 Performance report in Active IQ Unified Manager Discussions

OCUM 7.2 Performance report

Abhishar — Wed, 04 Jun 2025 13:54:31 GMT

I am looking for OCUM custom report to collect performance that contains Volume/Aggregate (iops, r/w latency) without using Oncommand Insight.

Re: OCUM 7.2 Performance report

Dhiman — Tue, 20 Mar 2018 06:10:47 GMT

Hi Abhishar,

Performance reports are supported from OnCommand Unified Manager 7.3. You can consume performance reports in two ways:

1. Directly from the UI; navigate to Performance --> (click any object Clusters, Nodes, Aggregates, Volumes, Ports, SVMS, LUNS, LIFs) --> export the content to your desktop as a CSV file bly clicking on the export button. The data exported is point in time

2. Almost all the DB tables are open in "read-only" mode for reporting purposes. Connect to UM DB via JDBC (with a UM DB user with "Report Schema" role).

Note: The performance data here are available in samples...

For example if you are looking to find IOPS information for certain volumes, you need to do the following:

The IO statistics are available in the sample_qos_volume_workload_<clusterId> tables. So you can walk the netapp_model.volume table and find it’s corresponding id in the netapp_model.workload table. Then use the workload id to get the stats in the corresponding sample table.

Hope this helps!

Thanks,

Dhiman

Re: OCUM 7.2 Performance report

Abhishar — Mon, 26 Mar 2018 12:02:14 GMT

Thanks Dhiman, We are using OCUM 7.2p1 I tried to connect the OCUM DB but its only showing me OCUM_REPORT DB only.

Not able to connect UM Peformance DB.

Can you please help.

Re: OCUM 7.2 Performance report

Dhiman — Wed, 28 Mar 2018 14:02:20 GMT

Hi,

For viewing Performance Schema, you will need to upgrade to UM 7.3. Please see my blog https://blog.netapp.com/more-ways-to-extract-the-data-you-need-from-oncommand-unified-manager to get more ideas on this.

Thanks,

Dhiman