Subscribe

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

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)

Only views are exposed, and the tables are not.

Regards

adai

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

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)

Hi

     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