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

jeff_spiegel · ‎2011-04-15

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

adaikkap · ‎2011-04-15

Only views are exposed, and the tables are not.

Regards

adai

jeff_spiegel · ‎2011-04-20

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