/content/folder[@name='Packages']/package[@name='Volume Capacity']/model[@name='2014-10-01T17:24:31.770Z'] No Data Available select dataCenter as "Location ID", Site_Name as "Site Name", serialNumber as "Serial Number", name as "Storage Name" from storage [SQL1].[Location ID][SQL1].[Site Name][SQL1].[Serial Number][SQL1].[Storage Name] [Host Visible Volumes].[Storage].[Storage].[Storage].[Storage Name]Storage Name[Host Visible Volumes].[Storage]Storage[Host Visible Volumes].[Storage].[Storage]Storage[Host Visible Volumes].[Storage].[Storage].[Storage]Storage[Host Visible Volumes].[Service Level].[Service Level].[Service Level].[Service Level Name]Service Level Name[Host Visible Volumes].[Service Level]Service Level[Host Visible Volumes].[Service Level].[Service Level]Service Level[Host Visible Volumes].[Service Level].[Service Level].[Service Level]Service Level[Host Visible Volumes].[Host].[Host].[Host].[Host Name]Host Name[Host Visible Volumes].[Host]Host[Host Visible Volumes].[Host].[Host]Host[Host Visible Volumes].[Host].[Host].[Host]Host[Host Visible Volumes].[Host].[Host].[Host].[Additional Hosts]Additional Hosts[Host Visible Volumes].[Host]Host[Host Visible Volumes].[Host].[Host]Host[Host Visible Volumes].[Host].[Host].[Host]Host[Host Visible Volumes].[Host].[Host].[Host].[Host Ip]Host Ip[Host Visible Volumes].[Host]Host[Host Visible Volumes].[Host].[Host]Host[Host Visible Volumes].[Host].[Host].[Host]Host[Host Visible Volumes].[Storage].[Storage].[Volume].[Volume Name]Volume Name[Host Visible Volumes].[Storage]Storage[Host Visible Volumes].[Storage].[Storage]Storage[Host Visible Volumes].[Storage].[Storage].[Volume]Volume[Host Visible Volumes].[Capacity (GB)].[Accessed Volume Capacity (GB)]Accessed Volume Capacity (GB)[Host Visible Volumes].[Capacity (GB)]Capacity (GB) [Query1].[Storage Name] = [Query2].[Storage Name] [Query1].[Location ID][Query1].[Site Name][Query1].[Serial Number][Query1].[Storage Name][Query2].[Service Level Name][Query2].[Host Name]if ([Host Name] contains '.') then (substring([Host Name],1,position('.',[Host Name])-1)) else ([Host Name])[Query2].[Additional Hosts][Query2].[Host Ip][Query2].[Volume Name][Query2].[Accessed Volume Capacity (GB)] [Host Name] <> 'N/A'LUN Report