2011-04-15 02:36 PM
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?
2011-04-20 09:35 AM
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.
2011-04-20 08:13 PM
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.
else you can use the dfm perf data reterive to get what you want.This is explained in the below post.