Creating a Report of available ASM candidate disks from the OEM Repository

A while ago I was reviewing the metric extensions of our Enterprise Manager Cloud Control 13.2.0.0, we use to administer a couple of hundred databases. All acceptance and production databases are installed on Linux RAC-clusters with underlying ASM storage. One of the custom reports summarized the size and number of LUN’s, using a query I had found on the internet:

SELECT target_name,

diskgroup,

MAX (DECODE (seq, 7, VALUE))               as REDUNDANCY,

MAX (DECODE (more...)