Direct mysql query of opmanager data
Hi,
I'm looking to perform a number of queries with a scripted monitor in AppManager to poll summary data from OpManager. The underlying database seems to be a real mess, and I am struggling to see where the actual group availability data is. I want to start by polling the availability of each of the groups in the infrasttucture snapshot... can anyone tell me the table where the good stuff lives? i've waded though schema's and mysqldump's for clues, but i'm still blind really...
any help appreciated
I'm looking to perform a number of queries with a scripted monitor in AppManager to poll summary data from OpManager. The underlying database seems to be a real mess, and I am struggling to see where the actual group availability data is. I want to start by polling the availability of each of the groups in the infrasttucture snapshot... can anyone tell me the table where the good stuff lives? i've waded though schema's and mysqldump's for clues, but i'm still blind really...
any help appreciated