Hi Wayne,
It looks like you're looking to do an overcommit report with utilization, see below. Note that this combines Storage and Storage Pool Capacity with Internal Volume Capacity:
SELECT dwh_capacity.storage_dimension.name AS 'Storage System Name',
dwh_capacity.storage_pool_dimension.name AS 'Storage Pool Name',
dwh_capacity.storage_and_storage_pool_capacity_fact.rawCapacityMB/1024 AS 'Aggregate Total Raw Space (GB)',
dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB/1024 AS 'Aggregate Total Space (GB)',
dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB/1024 AS 'Aggregate Used Space (GB)',
dwh_capacity.storage_and_storage_pool_capacity_fact.usedcapacityMB/dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB AS 'Aggregate Used Space (%)',
(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB - dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024 AS 'Aggregate Available Space (GB)',
SUM(dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB)/1024 AS 'Provisioned Volume Capacity (GB)',
(SUM(dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB)/dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB) AS 'Over-Commit Ratio (%)'
FROM dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN dwh_capacity.storage_dimension
ON dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND dwh_capacity.storage_dimension.manufacturer = 'NetApp'
JOIN dwh_capacity.storage_pool_dimension
ON dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
AND dwh_capacity.storage_pool_dimension.name <> 'N/A'
JOIN dwh_capacity.date_dimension
ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.Tk
AND dwh_capacity.date_dimension.latest = 1
JOIN dwh_capacity.internal_volume_capacity_fact
ON dwh_capacity.storage_pool_dimension.tk = dwh_capacity.internal_volume_capacity_fact.storagePoolTk
AND dwh_capacity.date_dimension.tk = dwh_capacity.internal_volume_capacity_fact.dateTk
GROUP BY
dwh_capacity.storage_pool_dimension.tk
Unfortunately, 6.4.x did not come with the capability to aggregate the flexvol capacity in the Storage and Storage Pool Capacity data mart by default. As a result, we had to use the above as a workaround. We've then added this in our 7.0 release so that you can easily drag and drop the data without having to do any SQL.