topic Operations manager database access to data in tables (not views) in Microsoft Virtualization Discussions

Operations manager database access to data in tables (not views)

jeff_spiegel — Thu, 05 Jun 2025 06:56:31 GMT

I have read TR 3690 which show me how to get access to the datafabric manager and performance advisor data using databse access. I followed the directions, installed a Sybase client, setup a user using the DFM commands and was able to connect. However, this only allows me to access the views. I want to be able to see the data in all the TABLES so that I can run sql commands to view this data and export it to my own database to make custom reports.

Can someone tell me how I can get access to the data in the tables and not just the views?

Thanks!

Jeff

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

Re: Operations manager database access to data in tables (not views)

adaikkap — Sat, 16 Apr 2011 01:08:13 GMT

Only views are exposed, and the tables are not.

Regards

adai

Re: Operations manager database access to data in tables (not views)

jeff_spiegel — Wed, 20 Apr 2011 16:35:57 GMT

Adai - thanks for the response. So here is my question then - I would like access to all the readings for disk busy. I'm trying to graph how busy the disks are and when. I know the Management console does this but i want some custom graphs for the month for peak and non-peak hours. I guess I could write a powershell script to query the filer every so often for the busiest disk, but since Ops Manager is already doing this I would like access to this data. I can't find it in the views. Am I missing it?

Thanks so much.

Jeff

Re: Operations manager database access to data in tables (not views)

adaikkap — Thu, 21 Apr 2011 03:13:45 GMT

Performance Advisor Data is not store in db, its stored in flat files.

The TR listed in the top most post,say how to access PA data.

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

else you can use the dfm perf data reterive to get what you want.This is explained in the below post.

http://communities.netapp.com/message/52507#52507

Regards

adai