/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='2016-02-10T18:34:33.482Z'] Storage Trending Report No Data Available No Data Available No Data Available Overall - Total SELECT dwh_inventory.storage.name AS 'Array', dwh_inventory.application.name AS 'Application', dwh_inventory.business_entity.tenant AS 'Tenant', dwh_inventory.business_entity.lob AS 'Line of Business', dwh_inventory.business_entity.businessUnit AS 'Business Unit', dwh_inventory.business_entity.project AS 'Project' FROM dwh_inventory.storage LEFT JOIN dwh_inventory.storage_to_application ON dwh_inventory.storage.id = dwh_inventory.storage_to_application.storageId LEFT JOIN dwh_inventory.application ON dwh_inventory.storage_to_application.applicationId = dwh_inventory.application.id LEFT JOIN dwh_inventory.business_entity ON dwh_inventory.application.businessEntityId = dwh_inventory.business_entity.id [SQL1].[Array][SQL1].[Application][SQL1].[Tenant][SQL1].[Line of Business][SQL1].[Business Unit][SQL1].[Project] [Physical Capacity].[Storage].[Storage].[Storage].[Storage Name]Storage Name[Physical Capacity].[Storage]Storage[Physical Capacity].[Storage].[Storage]Storage[Physical Capacity].[Storage].[Storage].[Storage]Storage[Physical Capacity].[Storage].[Storage].[Storage Pool].[Storage Pool Name]Storage Pool Name[Physical Capacity].[Storage]Storage[Physical Capacity].[Storage].[Storage]Storage[Physical Capacity].[Storage].[Storage].[Storage Pool]Storage Pool[Physical Capacity].[Capacity (GB)].[Capacity (GB)]Capacity (GB)[Physical Capacity].[Capacity (GB)]Capacity (GB)[Physical Capacity].[Capacity (GB)].[Used Capacity (GB)]Used Capacity (GB)[Physical Capacity].[Capacity (GB)]Capacity (GB)[Physical Capacity].[Capacity (GB)].[Unused Capacity (GB)]Unused Capacity (GB)[Physical Capacity].[Capacity (GB)]Capacity (GB)[Physical Capacity].[Projected Capacity (GB)].[Projected Capacity (GB)]Projected Capacity (GB)[Physical Capacity].[Projected Capacity (GB)]Projected Capacity (GB)[Physical Capacity].[Projected Capacity (GB)].[Projected Used Capacity (GB)]Projected Used Capacity (GB)[Physical Capacity].[Projected Capacity (GB)]Projected Capacity (GB)[Physical Capacity].[Date].[Date].[Month].[Full Date]Full Date[Physical Capacity].[Date]Date[Physical Capacity].[Date].[Date]Date[Physical Capacity].[Date].[Date].[Month]Month[Physical Capacity].[Latest Date] [Array_BussEnty].[Array] = [Query1].[Storage Name] [Array_BussEnty].[Tenant][Array_BussEnty].[Line of Business][Query1].[Storage Name][Query1].[Capacity (GB)][Query1].[Used Capacity (GB)][Query1].[Unused Capacity (GB)][Query1].[Projected Capacity (GB)][Query1].[Projected Used Capacity (GB)][Query1].[Full Date] [Tenant] contains ?Tenant?Storage Trending Report