Is there information in the grid control database that I can query to find the total size and used space for instances of ASM? I am running Cloud Control 126.96.36.199 and monitoring 25+ servers all with ASM instances. We have alerting that will send notifications when they get to a certain used percentage but I would like to generate a report that lists all ASM diskgroups that I can email to myself and another DBA.
I am pretty new to digging into the tables and views withing the cloud control database so any help would be appreciated.
DK2010 thanks for sharing my blog post. Blackhills I am glad you find the report helpful. I have a few other blog post on creating reports from the data in OEM repository. There is one for database storage growth and also dynamically generating TNS entries. I have created a whole database server inventory system using the OEM repoistory data.
Below is my blog post the few post I have on reports using data in OEM are back in June. The other one you may like the is similar to my ASM report is the database storage.