This discussion is archived
5 Replies Latest reply: Oct 3, 2013 6:02 AM by BlackHills RSS

Query to check ASM usage on multiple servers

BlackHills Newbie
Currently Being Moderated

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 12.1.0.2 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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points