Unified Manager databases accessible for custom reporting
Suggest changes
PDFs
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.
Starting with Unified Manager 7.3, additional schemas are exposed that provide access to additional table data.
All table data from the following databases are available:
| Database | Description |
|---|---|
netapp_model_view |
Data about the objects on ONTAP controllers. |
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 |
Same as above, but this database is consumed by built-in BIRT reports. |
opm |
Performance configuration settings and threshold information. |
scalemonitor |
Data about the Unified Manager application health and performance issues. |
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.