Microsoft Virtualization Discussions

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

jeff_spiegel
3,240 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

3 REPLIES 3

adaikkap
3,240 Views

Only views are exposed, and the tables are not.

Regards

adai

jeff_spiegel
3,240 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

adaikkap
3,240 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

Public