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

[jeff_spiegel]

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]

Only views are exposed, and the tables are not.

Regards

adai

[jeff_spiegel]

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

[adaikkap]

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