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?
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.
Re: Operations manager database access to data in tables (not views)