Active IQ Unified Manager Discussions

DFM (7mode) DB data schema


I inherited a scripts that retrieves some data directly from DFM DB. I have to modify some of its SQL queries but I am not familiar with DFM DB data schema. Where can I find descriptions of views? (I do not have access to DFM per se - I can only run DB queries.)



If you can work with someone in your company that is an administrator (local or domain for Windows) or root (Linux) on the UM server (you didn't list a version or host OS), then you can ask them to query (via CLI) the syscatalog for the views.  UM 5.2.2 Views all end in the string 'View' and are owned by the DFMGROUP.  Once you have a list, you should be able to query contents (per your post), but if not, then the same person/people that provided the list from the UM servers should be able to run a query against the view names and provide the view details.



Alternatively, if you can't get hold of anybody, just open the OCUM web UI login screen and click on "help".

You don't need to login, just goto "https://<OCUM-ip or hostname>:8443"


The DB Schema is documented in the online help under "Reports --> Database Schema"




regards, Niels


NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner