Simple OCI Query: Total Allocated & Used GB from Internal Volumes (i.e. FlexVols/Buckets) on a Storage

Just a simple NetApp OnCommand Insight Data Warehouse query to find the sum of total allocated GB and total used GB from all the internal volumes (which might be FlexVols or Buckets) on a named Storage.

SELECT

    SUM(totalAllocatedCapacityMB) / (1024*1024) AS 'Allocated TB'

  , SUM(totalUsedCapacityMB) / (1024*1024) AS 'Used TB'

FROM dwh_inventory.internal_volume AS i

JOIN dwh_inventory.storage AS s ON s.id = i.storageId

WHERE s.name = '{STORAGE_NAME}';