Unified Manager databases accessible for custom reporting

Unified Manager uses a MySQL database to store data from the clusters that it is monitoring. Data is persisted into various schemas in the MySQL database.

All table data from the following databases are available:

Database Description
netapp_model Data about the objects on ONTAP controllers.
netapp_model_view Data about the objects on ONTAP controllers, suitable for report tool consumption.
netapp_performance Cluster specific performance counters.
ocum Unified Manager application data and information to support UI filtering, sorting, and the calculation of some derived fields.
ocum_report Data for inventory configuration and capacity-related information.
ocum_report_birt Views for inventory configuration and capacity-related data, suitable for report tool consumption.
opm Performance configuration settings and threshold information.
scalemonitor Data about the Unified Manager application health and performance issues.
vmware_model VMware object data for datastores hosted on NetApp storage.
vmware_model_view Views for VMware object data for datastores hosted on NetApp storage, suitable for report tool consumption.
vmware_performance VMware performance counter data for datastores hosted on NetApp storage.

A reporting user — a Database user with the Report Schema role — is able to access the data in these tables. This user has read-only access to reporting and other database views directly from the Unified Manager database. Note that this user does not have permission to access any tables that contain user data or cluster credential information.

See the Technical Report for Unified Manager Reporting (TR-4565) for more details.