topic Re: Operations Manager DB Access in Active IQ Unified Manager Discussions

Operations Manager DB Access

adampound — Thu, 05 Jun 2025 07:18:55 GMT

I have followed http://media.netapp.com/documents/tr-3690.pdf

for setting up database access. I'm able to connect to the views but there doesn't seem to be a view to see the backup jobs status. Is there a way to create a user that can see the DFM tables or is there a view for backup jobs and I'm missing it?

Re: Operations Manager DB Access

adaikkap — Fri, 05 Feb 2010 15:14:40 GMT

You can find the Ops-Mgr Schema in the Ops-Mgr UI General Help->Database Schema.

I have given a example link replace Ops-Mgr with your Ops-Mgr server IP address or FDQN.

http://Ops-Mgr:8080/help/dfm.htm#>>3Ecmd=1>>pan=2

Regards

adai

Re: Operations Manager DB Access

adampound — Fri, 05 Feb 2010 15:25:16 GMT

Thanks for your help but the information I'm looking for isn't in the views. I'm trying to write a simple report that shows the status of our daily backup jobs. I see several backup tables but I can't figure out how to get access to them.

Re: Operations Manager DB Access

adaikkap — Fri, 05 Feb 2010 15:31:35 GMT

Only Ops-Mgr and PA data are exposed via Views,

BackupManager, Disaster Recovery Manager, Protection Manager and Provisioning Manger data are not exposed through views.

What exactly are you looking for in the backup jobs ?

Regards

adai

Re: Operations Manager DB Access

adampound — Fri, 05 Feb 2010 15:37:07 GMT

Basically just the status. We have several different backup systems and we want to have one report that shows the backup statuses for each system. The backup summary page provides all the info I need.

Re: Operations Manager DB Access

adaikkap — Fri, 05 Feb 2010 15:45:35 GMT

What is the version of operation manager you are using?

If DFM 3.8 have you explored data transfer report.

Regards

adai

Re: Operations Manager DB Access

adampound — Fri, 05 Feb 2010 15:49:48 GMT

yes it is 3.8. I will look into datatransfer report.