Find Grid Agent status from Grid Control Repository
76368Jul 1 2011 — edited Jul 6 2011Hi,
I need help on extracting data from Grid Control Repository. My Grid Control database is 10.2.0.5 on Solaris 64bit.
In Grid Control, there is a report in Reports tab (Enterprise Manager Setup -> Agent Information) which displays status of all agents configured. I have similar requirment but I will be filtering databases based on some criteria and some other factors so I need a sqlplus query to extract agent information from Grid repository database.
Can anybody please help to get Agent information from OMS repository using SQL*PLUS
regards,
Ajay