[OCI-DWH][MySQL] ECS Used and Raw Reporting in dwh_capacity

With a recent patch (ICI-10092) for the EMC ECS as Storage (ECS 7.3.3+) datasource, we can now trend the Used and Raw capacity for EMC ECS storage arrays.

The following query below pulls the information from dwh_capacity.disk_group_capacity_fact and compares it with dwh_inventory.storage. When you run the query, you see the capacity figures from disk_group_capacity_fact are identical to rawCapacity in storage.

SELECT
    s.name
  , s.family
  , FLOOR(capacityMB/(1024*1024)) AS 'CapacityTB (from dwh_capacity)'
  , FLOOR(usedCapacityMB/(1024*1024)) AS 'UsedCapacityTB (from dwh_capacity)'
  , FLOOR(t0.rawCapacityMB/1048576) AS 'RawCapacityTB (from dwh_inventory)'
FROM dwh_capacity.disk_group_capacity_fact AS f
JOIN dwh_capacity.storage_dimension AS s ON s.tk = f.storageTk
JOIN (SELECT name, rawCapacityMB FROM dwh_inventory.storage WHERE family = 'ECS') AS t0 ON t0.name = s.name
WHERE f.dateTk = (SELECT MAX(dateTk) FROM dwh_capacity.storage_and_storage_pool_capacity_fact)
AND s.family = 'ECS'
ORDER BY 1;