Reporting scripts
This appendix provides three different versions of an example script to create a showback report.
For considerations regarding a showback report and for more information about how to use and modify the script, see 5.1.4, “Creating input for your chargeback report” on page 126.
This appendix contains the following reporting scripts:
Overview
The following sections show three different versions of an example script that creates a showback report:
•In “Sample script with native SQL statement” on page 244, you find the native SQL statement that is used in all versions. This native SQL statement can be used to run natively and in applications that support DB2 SQL, for example, Microsoft Excel 2013.
•If you want to run the showback report regularly as a batch report, see “runshowbackexport.bat” on page 249 and “showbackexport.sql” on page 249.
•You can use “Sample script for Cognos” on page 253 to run the showback report in Cognos.
Sample script with native SQL statement
Example B-1 shows the showback.sql script.
Example B-1 showback.sql example
with t1 as (
 
SELECT cast(AL1.name as VARCHAR(70)) as volid, Strip(AL2.UNKNOWN_HOST_NAME) as hostname
FROM TPCREPORT.STORAGEVOLUME AL1 inner join TPCREPORT.STORAGEVOLUME_PATH AL2 on (AL1.STORAGE_VOLUME_ID=AL2.STORAGE_VOLUME_ID)
and (AL1.BACKEND_DISK_ID is NULL) and (AL1.DETECTABLE = 'True')
 
 
group by AL1.name, AL2.UNKNOWN_HOST_NAME ),
 
 
t2 as (
SELECT e.volid,e.hostname,
XMLELEMENT(
NAME "volid", XMLELEMENT(
NAME "volid", e.volid
),
XMLELEMENT(
NAME "hostname", e.hostname
)
)
AS "Result"
FROM t1 E
),
 
t3 as (
SELECT volid, rtrim(
replace (
replace (
XMLSERIALIZE(CONTENT XMLAGG(XMLELEMENT(NAME "hostname", t2.hostname)
ORDER BY t2.hostname
)
as varchar (5000)),
'<hostname>',''), '</hostname>',','),';')
AS hostname
FROM t2
group by volid
),
tnum as (
select count(hostname) as numservers, volid from t1 group by volid
),
t4 as (
SELECT
AL1.STORAGE_VOLUME_ID
, cast(AL1.name as VARCHAR(70)) as volid
, AL1.ELEMENT_NAME as Volumename
, AL1.SPACE/ (1024*1024*1024) as Capacity
, AL1.REAL_SPACE / (1024*1024*1024) as Allocated_Space
, AL1.CONSUMED_SPACE/ (1024*1024*1024) as Used_Space
, AL2.POOL_ID
, AL2.Display_NAME as Poolname
, AL2.UDP1
, AL2.UDP2
, AL2.UDP3
, AL3.DISPLAY_NAME as Storagesubsystemname1
, AL3.UDP1 as StorageSubsystem_Custom_Tag1
, AL3.UDP2 as StorageSubsystem_Custom_Tag2
, AL3.UDP3 as StorageSubsystem_Custom_Tag3
, case
when AL3.User_Provided_Name is not null then AL3.User_Provided_Name
else
case
when AL3.TYPE = 'FAStT' then substr(AL3.DISPLAY_NAME,1, length (AL3.DISPLAY_NAME)-37)
when AL3.TYPE = 'DS4000' then substr(AL3.DISPLAY_NAME,8,posstr(substr(AL3.DISPLAY_NAME,8, length(AL3.DISPLAY_NAME)),'-')-1)
when AL3.TYPE = 'DS5000' then substr(AL3.DISPLAY_NAME,8,posstr(substr(AL3.DISPLAY_NAME,8, length(AL3.DISPLAY_NAME)),'-')-1)
else AL3.DISPLAY_NAME
end
end as Storagesubsystemname
, AL1.SPACE_EFFICIENT_VOLUME
, AL1.ENCRYPTABLE
, AL1.ENCRYPTED
, AL1.MIRROR_COUNT
, AL1.OPERATIONAL_STATUS
, AL1.DETECTABLE
, AL1.RAID_LEVEL
, AL1.IS_COMPRESSED
, AL4.POOL_TIER_ID as TPC_TIER
, AL1.BLOCK_SIZE
FROM TPCREPORT.STORAGEVOLUME AL1 LEFT OUTER JOIN TPC.T_RES_VDISK_COPY AL6 ON (AL1.STORAGE_VOLUME_ID=AL6.SVID)
and (AL1.DETECTABLE = 'True')and (AL1.BACKEND_DISK_ID is NULL)
left outer join TPCREPORT.STORAGESUBSYSTEM AL3 on AL1.SUBSYSTEM_ID=AL3.SUBSYSTEM_ID
left outer join TPCREPORT.STORAGEPOOL AL2 on AL6.POOL_ID=AL2.POOL_ID
left outer join TPC.T_RES_STORAGE_POOL AL4 on AL2.POOL_ID=AL4.POOL_ID
-- and AL6.IS_PRIMARY =1
),
 
tt as (
select
AL2.POOL_ID
,AL5.EASY_TIER as Pool_EasyTier
,AL5.EASY_TIER_STATUS as Pool_EasyTier_Status
from TPCREPORT.STORAGEPOOL AL2
left outer join TPCREPORT.Storagesubsystem_Tiering_Info AL5 on AL5.Entity_ID=AL2.POOL_ID
group by AL2.POOL_ID, AL5.EASY_TIER, AL5.EASY_TIER_STatus
),
 
 
t5 as (
SELECT
AL2.name as appgroup
, cast(AL3.name as VARCHAR(70)) as volid
FROM TPC.T_GROUP2RES AL1, TPC.T_GROUP AL2, TPCREPORT.STORAGEVOLUME AL3
WHERE (AL2.GROUP_ID=AL1.GROUP_ID AND AL1.RESOURCE_ID=AL3.STORAGE_VOLUME_ID) AND (AL1.RES_TYPE=194 AND AL2.FLAGS=6)
group by AL3.name, AL2.name ),
 
t6 as (
SELECT a.volid, a.appgroup,
XMLELEMENT(
NAME "volid", XMLELEMENT(
NAME "volid", a.volid
),
XMLELEMENT(
NAME "appgroup", a.appgroup
)
)
AS "Appresult"
FROM t5 A
),
 
t7 as (
SELECT volid, rtrim(
replace (
replace (
XMLSERIALIZE(CONTENT XMLAGG(XMLELEMENT(NAME "appgroup", t6.appgroup)
ORDER BY t6.appgroup
)
as varchar (500)),
'<appgroup>',''), '</appgroup>',','),';')
AS appgroup
FROM t6
group by volid
),
 
 
 
t8 as (
SELECT
cast(AL1.name as VARCHAR(70)) as volid
, AL2.TIER || ': ' || (cast(AL2.TIER_SPACE *512/(1024*1024*1024) as varchar(10))) as Tier_Capacity
FROM TPCREPORT.STORAGEVOLUME AL1, TPCREPORT.STORAGESUBSYSTEM_TIERING_INFO AL2
WHERE (AL1.STORAGE_VOLUME_ID=AL2.ENTITY_ID)
group by AL1.name,AL2.TIER, AL2.TIER_SPACE
),
t9 as (
SELECT e.volid,e.Tier_Capacity,
XMLELEMENT(
NAME "volid", XMLELEMENT(
NAME "volid", e.volid
),
XMLELEMENT(
NAME "Tier_Capacity", e.Tier_Capacity
)
)
AS "Result"
FROM t8 E
),
 
t10 as (
SELECT volid, rtrim(
replace (
replace (
XMLSERIALIZE(CONTENT XMLAGG(XMLELEMENT(NAME "Tier_Capacity", t9.Tier_Capacity)
ORDER BY t9.Tier_Capacity
)
as varchar (500)),
'<Tier_Capacity>',''), '</Tier_Capacity>',','),';')
AS Tier_Capacity
FROM t9
group by volid
)
 
select
t4.Volumename
, t4.volid
,case
when tnum.numservers = 0 then 'No Hosts mapped'
else substr (t3.hostname,1,length(t3.hostname)- 1)
end as Hostlist
, tnum.numservers as NUMHosts
-- , case
-- when (t4.Storagesubsystemname1 like 'SVC%') or (t4.Storagesubsystemname1 like 'Storwize%') then t4.MIRROR_COUNT
-- else 1
-- end as MIRROR_COUNT
, t4.Capacity
, t4.Allocated_Space
, t4.Used_Space
,t4.Pool_ID
, t4.Poolname
, t4.UDP1 as Pool_Custom_Tag1
, t4.UDP2 as Pool_Custom_Tag2
, t4.UDP3 as Pool_Custom_Tag3
, t4.Storagesubsystemname as Storage_System
, t4.SPACE_EFFICIENT_VOLUME as ThinProvisioned
, t4.ENCRYPTABLE
, t4.ENCRYPTED
, t4.OPERATIONAL_STATUS as Status
, case when t4.RAID_LEVEL = -1 then 'unavailable' else cast(t4.RAID_LEVEL as varchar(10)) end as Raid_level
-- , t4.RAID_LEVEL
, t4.IS_COMPRESSED
, t4.TPC_TIER as SpectrumControl_Tier
-- , t4.BLOCK_SIZE
, tt.Pool_EasyTier
, tt.Pool_EasyTier_Status
, t4.StorageSubsystem_Custom_Tag1
, t4.StorageSubsystem_Custom_Tag2
, t4.StorageSubsystem_Custom_Tag3
, substr (t10.Tier_Capacity,1,length(t10.Tier_Capacity)- 1) as Vol_Tier_Capacity
, substr (t7.appgroup,1,length(t7.appgroup)- 1) as Applist
, current_date as Current_date
from t3 inner join t4 on (t3.volid = t4.volid)
inner join tnum on (t3.volid = tnum.volid)
left outer join t7 on (t4.volid = t7.volid) left outer join t10 on (t4.volid = t10.volid)
left outer join tt on (t4.pool_id = tt.pool_id)
with ur for read only
Sample script to run as a batch report
If you want to run the showback report regularly as a batch report, use the scripts that are shown in “runshowbackexport.bat” on page 249 and “showbackexport.sql” on page 249.
runshowbackexport.bat
Example B-2 shows the .bat file that is used to run “showbackexport.sql” on page 249.
Example B-2 The .bat file to run runshowbackexport
if "%DB2CLP%" == "" db2cmd /c /i /w %0 %* & goto :eof
db2 connect to tpcdb user db2admin using pwd
db2 -tvf db2 -tvf C:showbackshowbackexport.sql
showbackexport.sql
Example B-3 on page 249 shows the showbackexport.sql script, which exports the results to a batch report.
Example B-3 Export the showback.sql results to a CSV file
EXPORT TO "C:showbackshowback.csv" OF DEL MODIFIED BY COLDEL; MESSAGES "C:showbackshowback.log"
 
 
with t1 as (
 
SELECT cast(AL1.name as VARCHAR(70)) as volid, Strip(AL2.UNKNOWN_HOST_NAME) as hostname
FROM TPCREPORT.STORAGEVOLUME AL1 inner join TPCREPORT.STORAGEVOLUME_PATH AL2 on (AL1.STORAGE_VOLUME_ID=AL2.STORAGE_VOLUME_ID)
and (AL1.BACKEND_DISK_ID is NULL) and (AL1.DETECTABLE = 'True')
 
 
group by AL1.name, AL2.UNKNOWN_HOST_NAME ),
 
 
t2 as (
SELECT e.volid,e.hostname,
XMLELEMENT(
NAME "volid", XMLELEMENT(
NAME "volid", e.volid
),
XMLELEMENT(
NAME "hostname", e.hostname
)
)
AS "Result"
FROM t1 E
),
 
t3 as (
SELECT volid, rtrim(
replace (
replace (
XMLSERIALIZE(CONTENT XMLAGG(XMLELEMENT(NAME "hostname", t2.hostname)
ORDER BY t2.hostname
)
as varchar (5000)),
'<hostname>',''), '</hostname>',','),';')
AS hostname
FROM t2
group by volid
),
tnum as (
select count(hostname) as numservers, volid from t1 group by volid
),
t4 as (
SELECT
AL1.STORAGE_VOLUME_ID
, cast(AL1.name as VARCHAR(70)) as volid
, AL1.ELEMENT_NAME as Volumename
, AL1.SPACE/ (1024*1024*1024) as Capacity
, AL1.REAL_SPACE / (1024*1024*1024) as Allocated_Space
, AL1.CONSUMED_SPACE/ (1024*1024*1024) as Used_Space
, AL2.POOL_ID
, AL2.Display_NAME as Poolname
, AL2.UDP1
, AL2.UDP2
, AL2.UDP3
, AL3.DISPLAY_NAME as Storagesubsystemname1
, AL3.UDP1 as StorageSubsystem_Custom_Tag1
, AL3.UDP2 as StorageSubsystem_Custom_Tag2
, AL3.UDP3 as StorageSubsystem_Custom_Tag3
, case
when AL3.User_Provided_Name is not null then AL3.User_Provided_Name
else
case
when AL3.TYPE = 'FAStT' then substr(AL3.DISPLAY_NAME,1, length (AL3.DISPLAY_NAME)-37)
when AL3.TYPE = 'DS4000' then substr(AL3.DISPLAY_NAME,8,posstr(substr(AL3.DISPLAY_NAME,8, length(AL3.DISPLAY_NAME)),'-')-1)
when AL3.TYPE = 'DS5000' then substr(AL3.DISPLAY_NAME,8,posstr(substr(AL3.DISPLAY_NAME,8, length(AL3.DISPLAY_NAME)),'-')-1)
else AL3.DISPLAY_NAME
end
end as Storagesubsystemname
, AL1.SPACE_EFFICIENT_VOLUME
, AL1.ENCRYPTABLE
, AL1.ENCRYPTED
, AL1.MIRROR_COUNT
, AL1.OPERATIONAL_STATUS
, AL1.DETECTABLE
, AL1.RAID_LEVEL
, AL1.IS_COMPRESSED
, AL4.POOL_TIER_ID as TPC_TIER
, AL1.BLOCK_SIZE
FROM TPCREPORT.STORAGEVOLUME AL1 LEFT OUTER JOIN TPC.T_RES_VDISK_COPY AL6 ON (AL1.STORAGE_VOLUME_ID=AL6.SVID)
and (AL1.DETECTABLE = 'True')and (AL1.BACKEND_DISK_ID is NULL)
left outer join TPCREPORT.STORAGESUBSYSTEM AL3 on AL1.SUBSYSTEM_ID=AL3.SUBSYSTEM_ID
left outer join TPCREPORT.STORAGEPOOL AL2 on AL6.POOL_ID=AL2.POOL_ID
left outer join TPC.T_RES_STORAGE_POOL AL4 on AL2.POOL_ID=AL4.POOL_ID
-- and AL6.IS_PRIMARY =1
),
 
tt as (
select
AL2.POOL_ID
,AL5.EASY_TIER as Pool_EasyTier
,AL5.EASY_TIER_STATUS as Pool_EasyTier_Status
from TPCREPORT.STORAGEPOOL AL2
left outer join TPCREPORT.Storagesubsystem_Tiering_Info AL5 on AL5.Entity_ID=AL2.POOL_ID
group by AL2.POOL_ID, AL5.EASY_TIER, AL5.EASY_TIER_STatus
),
 
 
t5 as (
SELECT
AL2.name as appgroup
, cast(AL3.name as VARCHAR(70)) as volid
FROM TPC.T_GROUP2RES AL1, TPC.T_GROUP AL2, TPCREPORT.STORAGEVOLUME AL3
WHERE (AL2.GROUP_ID=AL1.GROUP_ID AND AL1.RESOURCE_ID=AL3.STORAGE_VOLUME_ID) AND (AL1.RES_TYPE=194 AND AL2.FLAGS=6)
group by AL3.name, AL2.name ),
 
t6 as (
SELECT a.volid, a.appgroup,
XMLELEMENT(
NAME "volid", XMLELEMENT(
NAME "volid", a.volid
),
XMLELEMENT(
NAME "appgroup", a.appgroup
)
)
AS "Appresult"
FROM t5 A
),
 
t7 as (
SELECT volid, rtrim(
replace (
replace (
XMLSERIALIZE(CONTENT XMLAGG(XMLELEMENT(NAME "appgroup", t6.appgroup)
ORDER BY t6.appgroup
)
as varchar (500)),
'<appgroup>',''), '</appgroup>',','),';')
AS appgroup
FROM t6
group by volid
),
 
 
 
t8 as (
SELECT
cast(AL1.name as VARCHAR(70)) as volid
, AL2.TIER || ': ' || (cast(AL2.TIER_SPACE *512/(1024*1024*1024) as varchar(10))) as Tier_Capacity
FROM TPCREPORT.STORAGEVOLUME AL1, TPCREPORT.STORAGESUBSYSTEM_TIERING_INFO AL2
WHERE (AL1.STORAGE_VOLUME_ID=AL2.ENTITY_ID)
group by AL1.name,AL2.TIER, AL2.TIER_SPACE
),
t9 as (
SELECT e.volid,e.Tier_Capacity,
XMLELEMENT(
NAME "volid", XMLELEMENT(
NAME "volid", e.volid
),
XMLELEMENT(
NAME "Tier_Capacity", e.Tier_Capacity
)
)
AS "Result"
FROM t8 E
),
 
t10 as (
SELECT volid, rtrim(
replace (
replace (
XMLSERIALIZE(CONTENT XMLAGG(XMLELEMENT(NAME "Tier_Capacity", t9.Tier_Capacity)
ORDER BY t9.Tier_Capacity
)
as varchar (500)),
'<Tier_Capacity>',''), '</Tier_Capacity>',','),';')
AS Tier_Capacity
FROM t9
group by volid
)
 
select
t4.Volumename
, t4.volid
,case
when tnum.numservers = 0 then 'No Hosts mapped'
else substr (t3.hostname,1,length(t3.hostname)- 1)
end as Hostlist
, tnum.numservers as NUMHosts
-- , case
-- when (t4.Storagesubsystemname1 like 'SVC%') or (t4.Storagesubsystemname1 like 'Storwize%') then t4.MIRROR_COUNT
-- else 1
-- end as MIRROR_COUNT
, t4.Capacity
, t4.Allocated_Space
, t4.Used_Space
,t4.Pool_ID
, t4.Poolname
, t4.UDP1 as Pool_Custom_Tag1
, t4.UDP2 as Pool_Custom_Tag2
, t4.UDP3 as Pool_Custom_Tag3
, t4.Storagesubsystemname as Storage_System
, t4.SPACE_EFFICIENT_VOLUME as ThinProvisioned
, t4.ENCRYPTABLE
, t4.ENCRYPTED
, t4.OPERATIONAL_STATUS as Status
, case when t4.RAID_LEVEL = -1 then 'unavailable' else cast(t4.RAID_LEVEL as varchar(10)) end as Raid_level
-- , t4.RAID_LEVEL
, t4.IS_COMPRESSED
, t4.TPC_TIER as SpectrumControl_Tier
-- , t4.BLOCK_SIZE
, tt.Pool_EasyTier
, tt.Pool_EasyTier_Status
, t4.StorageSubsystem_Custom_Tag1
, t4.StorageSubsystem_Custom_Tag2
, t4.StorageSubsystem_Custom_Tag3
, substr (t10.Tier_Capacity,1,length(t10.Tier_Capacity)- 1) as Vol_Tier_Capacity
, substr (t7.appgroup,1,length(t7.appgroup)- 1) as Applist
, current_date as Current_date
from t3 inner join t4 on (t3.volid = t4.volid)
inner join tnum on (t3.volid = tnum.volid)
left outer join t7 on (t4.volid = t7.volid) left outer join t10 on (t4.volid = t10.volid)
left outer join tt on (t4.pool_id = tt.pool_id)
with ur for read only
 
;
Sample script for Cognos
Example B-4 shows how you can use the showback_Cognos_xml.txt script to run the generate a showback report in Cognos.
Example B-4 Cognos XML showback script example
<report xmlns="http://developer.cognos.com/schemas/report/9.0/" useStyleVersion="10" expressionLocale="en-gb">
<modelPath>/content/folder[@name=&apos;IBM Spectrum Control Packages&apos;]/package[@name=&apos;Capacity and Relationships&apos;]/model[@name=&apos;2015-12-03T23:00:55.249Z&apos;]</modelPath>
<drillBehavior/>
<layouts>
<layout>
<reportPages>
<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
<contents>
<list horizontalPagination="true" refQuery="Query2" name="List1">
<noDataHandler>
<contents>
<block>
<contents>
<textItem>
<dataSource>
<staticValue>No Data Available</staticValue>
</dataSource>
<style>
<CSS value="padding:10px 18px;"/>
</style>
</textItem>
</contents>
</block>
</contents>
</noDataHandler>
<style>
<CSS value="border-collapse:collapse"/>
<defaultStyles>
<defaultStyle refStyle="ls"/>
</defaultStyles>
</style>
<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="VOLUMENAME"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="VOLUMENAME"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="VOLID"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="VOLID"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="HOSTLIST"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="HOSTLIST"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="NUMHOSTS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="NUMHOSTS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="CAPACITY"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="CAPACITY"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="ALLOCATED_SPACE"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="ALLOCATED_SPACE"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="USED_SPACE"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="USED_SPACE"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="POOLNAME"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="POOLNAME"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="POOL_CUSTOM_TAG1"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="POOL_CUSTOM_TAG1"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="POOL_CUSTOM_TAG2"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="POOL_CUSTOM_TAG2"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="POOL_CUSTOM_TAG3"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="POOL_CUSTOM_TAG3"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="STORAGE_SYSTEM"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="STORAGE_SYSTEM"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="THINPROVISIONED"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="THINPROVISIONED"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="ENCRYPTABLE"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="ENCRYPTABLE"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="ENCRYPTED"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="ENCRYPTED"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="STATUS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="STATUS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="RAID_LEVEL"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="RAID_LEVEL"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="IS_COMPRESSED"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="IS_COMPRESSED"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="SPECTRUMCONTROL_TIER"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="SPECTRUMCONTROL_TIER"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="POOL_EASYTIER"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="POOL_EASYTIER"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="POOL_EASYTIER_STATUS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="POOL_EASYTIER_STATUS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="STORAGESUBSYSTEM_CUSTOM_TAG1"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="STORAGESUBSYSTEM_CUSTOM_TAG1"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="STORAGESUBSYSTEM_CUSTOM_TAG2"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="STORAGESUBSYSTEM_CUSTOM_TAG2"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="STORAGESUBSYSTEM_CUSTOM_TAG3"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="STORAGESUBSYSTEM_CUSTOM_TAG3"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="VOL_TIER_CAPACITY"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="VOL_TIER_CAPACITY"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="APPLIST"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="APPLIST"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="CURRENT_DATE"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="CURRENT_DATE"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents>
</pageBody>
<pageHeader>
<contents>
<block><style><defaultStyles><defaultStyle refStyle="ta"/></defaultStyles></style>
<contents>
<textItem><style><defaultStyles><defaultStyle refStyle="tt"/></defaultStyles></style>
<dataSource>
<staticValue/>
</dataSource>
</textItem>
</contents>
</block>
</contents>
<style>
<defaultStyles>
<defaultStyle refStyle="ph"/>
</defaultStyles>
<CSS value="padding-bottom:10px"/>
</style>
</pageHeader>
<pageFooter>
<contents>
<table>
<tableRows>
<tableRow>
<tableCells>
<tableCell>
<contents>
<date>
<style>
<dataFormat>
<dateFormat/>
</dataFormat>
</style>
</date>
</contents>
<style>
<CSS value="vertical-align:top;text-align:left;width:25%"/>
</style>
</tableCell>
<tableCell>
<contents>
<pageNumber/>
</contents>
<style>
<CSS value="vertical-align:top;text-align:center;width:50%"/>
</style>
</tableCell>
<tableCell>
<contents>
<time>
<style>
<dataFormat>
<timeFormat/>
</dataFormat>
</style>
</time>
</contents>
<style>
<CSS value="vertical-align:top;text-align:right;width:25%"/>
</style>
</tableCell>
</tableCells>
</tableRow>
</tableRows>
<style>
<defaultStyles>
<defaultStyle refStyle="tb"/>
</defaultStyles>
<CSS value="border-collapse:collapse;width:100%"/>
</style>
</table>
</contents>
<style>
<defaultStyles>
<defaultStyle refStyle="pf"/>
</defaultStyles>
<CSS value="padding-top:10px"/>
</style>
</pageFooter>
</page>
</reportPages>
</layout>
</layouts>
<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" value="true" output="no"/><XMLAttribute name="listSeparator" value="," output="no"/><XMLAttribute name="RS_modelModificationTime" value="2015-12-03T23:00:55.343Z" output="no"/></XMLAttributes><queries><query name="Query2">
<source>
<sqlQuery name="SQL2" dataSource="TPCDB" type="passThrough">
<sqlText>with t1 as (
 
SELECT cast(AL1.name as VARCHAR(70)) as volid, Strip(AL2.UNKNOWN_HOST_NAME) as hostname
FROM TPCREPORT.STORAGEVOLUME AL1 inner join TPCREPORT.STORAGEVOLUME_PATH AL2 on (AL1.STORAGE_VOLUME_ID=AL2.STORAGE_VOLUME_ID)
and (AL1.BACKEND_DISK_ID is NULL) and (AL1.DETECTABLE = &apos;True&apos;)
 
 
group by AL1.name, AL2.UNKNOWN_HOST_NAME ),
 
 
t2 as (
SELECT e.volid,e.hostname,
XMLELEMENT(
NAME &quot;volid&quot;, XMLELEMENT(
NAME &quot;volid&quot;, e.volid
),
XMLELEMENT(
NAME &quot;hostname&quot;, e.hostname
)
)
AS &quot;Result&quot;
FROM t1 E
),
 
t3 as (
SELECT volid, rtrim(
replace (
replace (
XMLSERIALIZE(CONTENT XMLAGG(XMLELEMENT(NAME &quot;hostname&quot;, t2.hostname)
ORDER BY t2.hostname
)
as varchar (5000)),
&apos;&lt;hostname&gt;&apos;,&apos;&apos;), &apos;&lt;/hostname&gt;&apos;,&apos;,&apos;),&apos;;&apos;)
AS hostname
FROM t2
group by volid
),
tnum as (
select count(hostname) as numservers, volid from t1 group by volid
),
t4 as (
SELECT
AL1.STORAGE_VOLUME_ID
, cast(AL1.name as VARCHAR(70)) as volid
, AL1.ELEMENT_NAME as Volumename
, AL1.SPACE/ (1024*1024*1024) as Capacity
, AL1.REAL_SPACE / (1024*1024*1024) as Allocated_Space
, AL1.CONSUMED_SPACE/ (1024*1024*1024) as Used_Space
, AL2.POOL_ID
, AL2.Display_NAME as Poolname
, AL2.UDP1
, AL2.UDP2
, AL2.UDP3
, AL3.DISPLAY_NAME as Storagesubsystemname1
, AL3.UDP1 as StorageSubsystem_Custom_Tag1
, AL3.UDP2 as StorageSubsystem_Custom_Tag2
, AL3.UDP3 as StorageSubsystem_Custom_Tag3
, case
when AL3.User_Provided_Name is not null then AL3.User_Provided_Name
else
case
when AL3.TYPE = &apos;FAStT&apos; then substr(AL3.DISPLAY_NAME,1, length (AL3.DISPLAY_NAME)-37)
when AL3.TYPE = &apos;DS4000&apos; then substr(AL3.DISPLAY_NAME,8,posstr(substr(AL3.DISPLAY_NAME,8, length(AL3.DISPLAY_NAME)),&apos;-&apos;)-1)
when AL3.TYPE = &apos;DS5000&apos; then substr(AL3.DISPLAY_NAME,8,posstr(substr(AL3.DISPLAY_NAME,8, length(AL3.DISPLAY_NAME)),&apos;-&apos;)-1)
else AL3.DISPLAY_NAME
end
end as Storagesubsystemname
, AL1.SPACE_EFFICIENT_VOLUME
, AL1.ENCRYPTABLE
, AL1.ENCRYPTED
, AL1.MIRROR_COUNT
, AL1.OPERATIONAL_STATUS
, AL1.DETECTABLE
, AL1.RAID_LEVEL
, AL1.IS_COMPRESSED
, AL4.POOL_TIER_ID as TPC_TIER
, AL1.BLOCK_SIZE
FROM TPCREPORT.STORAGEVOLUME AL1 LEFT OUTER JOIN TPC.T_RES_VDISK_COPY AL6 ON (AL1.STORAGE_VOLUME_ID=AL6.SVID)
and (AL1.DETECTABLE = &apos;True&apos;)and (AL1.BACKEND_DISK_ID is NULL)
left outer join TPCREPORT.STORAGESUBSYSTEM AL3 on AL1.SUBSYSTEM_ID=AL3.SUBSYSTEM_ID
left outer join TPCREPORT.STORAGEPOOL AL2 on AL6.POOL_ID=AL2.POOL_ID
left outer join TPC.T_RES_STORAGE_POOL AL4 on AL2.POOL_ID=AL4.POOL_ID
-- and AL6.IS_PRIMARY =1
),
 
tt as (
select
AL2.POOL_ID
,AL5.EASY_TIER as Pool_EasyTier
,AL5.EASY_TIER_STATUS as Pool_EasyTier_Status
from TPCREPORT.STORAGEPOOL AL2
left outer join TPCREPORT.Storagesubsystem_Tiering_Info AL5 on AL5.Entity_ID=AL2.POOL_ID
group by AL2.POOL_ID, AL5.EASY_TIER, AL5.EASY_TIER_STatus
),
 
 
t5 as (
SELECT
AL2.name as appgroup
, cast(AL3.name as VARCHAR(70)) as volid
FROM TPC.T_GROUP2RES AL1, TPC.T_GROUP AL2, TPCREPORT.STORAGEVOLUME AL3
WHERE (AL2.GROUP_ID=AL1.GROUP_ID AND AL1.RESOURCE_ID=AL3.STORAGE_VOLUME_ID) AND (AL1.RES_TYPE=194 AND AL2.FLAGS=6)
group by AL3.name, AL2.name ),
 
t6 as (
SELECT a.volid, a.appgroup,
XMLELEMENT(
NAME &quot;volid&quot;, XMLELEMENT(
NAME &quot;volid&quot;, a.volid
),
XMLELEMENT(
NAME &quot;appgroup&quot;, a.appgroup
)
)
AS &quot;Appresult&quot;
FROM t5 A
),
 
t7 as (
SELECT volid, rtrim(
replace (
replace (
XMLSERIALIZE(CONTENT XMLAGG(XMLELEMENT(NAME &quot;appgroup&quot;, t6.appgroup)
ORDER BY t6.appgroup
)
as varchar (500)),
&apos;&lt;appgroup&gt;&apos;,&apos;&apos;), &apos;&lt;/appgroup&gt;&apos;,&apos;,&apos;),&apos;;&apos;)
AS appgroup
FROM t6
group by volid
),
 
 
 
t8 as (
SELECT
cast(AL1.name as VARCHAR(70)) as volid
, AL2.TIER || &apos;: &apos; || (cast(AL2.TIER_SPACE *512/(1024*1024*1024) as varchar(10))) as Tier_Capacity
FROM TPCREPORT.STORAGEVOLUME AL1, TPCREPORT.STORAGESUBSYSTEM_TIERING_INFO AL2
WHERE (AL1.STORAGE_VOLUME_ID=AL2.ENTITY_ID)
group by AL1.name,AL2.TIER, AL2.TIER_SPACE
),
t9 as (
SELECT e.volid,e.Tier_Capacity,
XMLELEMENT(
NAME &quot;volid&quot;, XMLELEMENT(
NAME &quot;volid&quot;, e.volid
),
XMLELEMENT(
NAME &quot;Tier_Capacity&quot;, e.Tier_Capacity
)
)
AS &quot;Result&quot;
FROM t8 E
),
 
t10 as (
SELECT volid, rtrim(
replace (
replace (
XMLSERIALIZE(CONTENT XMLAGG(XMLELEMENT(NAME &quot;Tier_Capacity&quot;, t9.Tier_Capacity)
ORDER BY t9.Tier_Capacity
)
as varchar (500)),
&apos;&lt;Tier_Capacity&gt;&apos;,&apos;&apos;), &apos;&lt;/Tier_Capacity&gt;&apos;,&apos;,&apos;),&apos;;&apos;)
AS Tier_Capacity
FROM t9
group by volid
)
 
select
t4.Volumename
, t4.volid
,case
when tnum.numservers = 0 then &apos;No Hosts mapped&apos;
else substr (t3.hostname,1,length(t3.hostname)- 1)
end as Hostlist
, tnum.numservers as NUMHosts
-- , case
-- when (t4.Storagesubsystemname1 like &apos;SVC%&apos;) or (t4.Storagesubsystemname1 like &apos;Storwize%&apos;) then t4.MIRROR_COUNT
-- else 1
-- end as MIRROR_COUNT
, t4.Capacity
, t4.Allocated_Space
, t4.Used_Space
,t4.Pool_ID
, t4.Poolname
, t4.UDP1 as Pool_Custom_Tag1
, t4.UDP2 as Pool_Custom_Tag2
, t4.UDP3 as Pool_Custom_Tag3
, t4.Storagesubsystemname as Storage_System
, t4.SPACE_EFFICIENT_VOLUME as ThinProvisioned
, t4.ENCRYPTABLE
, t4.ENCRYPTED
, t4.OPERATIONAL_STATUS as Status
, case when t4.RAID_LEVEL = -1 then &apos;unavailable&apos; else cast(t4.RAID_LEVEL as varchar(10)) end as Raid_level
-- , t4.RAID_LEVEL
, t4.IS_COMPRESSED
, t4.TPC_TIER as SpectrumControl_Tier
-- , t4.BLOCK_SIZE
, tt.Pool_EasyTier
, tt.Pool_EasyTier_Status
, t4.StorageSubsystem_Custom_Tag1
, t4.StorageSubsystem_Custom_Tag2
, t4.StorageSubsystem_Custom_Tag3
, substr (t10.Tier_Capacity,1,length(t10.Tier_Capacity)- 1) as Vol_Tier_Capacity
, substr (t7.appgroup,1,length(t7.appgroup)- 1) as Applist
, current_date as Current_date
from t3 inner join t4 on (t3.volid = t4.volid)
inner join tnum on (t3.volid = tnum.volid)
left outer join t7 on (t4.volid = t7.volid) left outer join t10 on (t4.volid = t10.volid)
left outer join tt on (t4.pool_id = tt.pool_id)
with ur for read only</sqlText>
<mdProjectedItems><mdProjectedItem name="VOLUMENAME"/><mdProjectedItem name="VOLID"/><mdProjectedItem name="HOSTLIST"/><mdProjectedItem name="NUMHOSTS"/><mdProjectedItem name="CAPACITY"/><mdProjectedItem name="ALLOCATED_SPACE"/><mdProjectedItem name="USED_SPACE"/><mdProjectedItem name="POOL_ID"/><mdProjectedItem name="POOLNAME"/><mdProjectedItem name="POOL_CUSTOM_TAG1"/><mdProjectedItem name="POOL_CUSTOM_TAG2"/><mdProjectedItem name="POOL_CUSTOM_TAG3"/><mdProjectedItem name="STORAGE_SYSTEM"/><mdProjectedItem name="THINPROVISIONED"/><mdProjectedItem name="ENCRYPTABLE"/><mdProjectedItem name="ENCRYPTED"/><mdProjectedItem name="STATUS"/><mdProjectedItem name="RAID_LEVEL"/><mdProjectedItem name="IS_COMPRESSED"/><mdProjectedItem name="SPECTRUMCONTROL_TIER"/><mdProjectedItem name="POOL_EASYTIER"/><mdProjectedItem name="POOL_EASYTIER_STATUS"/><mdProjectedItem name="STORAGESUBSYSTEM_CUSTOM_TAG1"/><mdProjectedItem name="STORAGESUBSYSTEM_CUSTOM_TAG2"/><mdProjectedItem name="STORAGESUBSYSTEM_CUSTOM_TAG3"/><mdProjectedItem name="VOL_TIER_CAPACITY"/><mdProjectedItem name="APPLIST"/><mdProjectedItem name="CURRENT_DATE"/></mdProjectedItems></sqlQuery></source>
<selection><dataItem name="VOLUMENAME"><expression>[SQL2].[VOLUMENAME]</expression></dataItem><dataItem name="VOLID"><expression>[SQL2].[VOLID]</expression></dataItem><dataItem name="HOSTLIST"><expression>[SQL2].[HOSTLIST]</expression></dataItem><dataItem name="NUMHOSTS"><expression>[SQL2].[NUMHOSTS]</expression></dataItem><dataItem name="CAPACITY"><expression>[SQL2].[CAPACITY]</expression></dataItem><dataItem name="ALLOCATED_SPACE"><expression>[SQL2].[ALLOCATED_SPACE]</expression></dataItem><dataItem name="USED_SPACE"><expression>[SQL2].[USED_SPACE]</expression></dataItem><dataItem name="POOLNAME"><expression>[SQL2].[POOLNAME]</expression></dataItem><dataItem name="POOL_CUSTOM_TAG1"><expression>[SQL2].[POOL_CUSTOM_TAG1]</expression></dataItem><dataItem name="POOL_CUSTOM_TAG2"><expression>[SQL2].[POOL_CUSTOM_TAG2]</expression></dataItem><dataItem name="POOL_CUSTOM_TAG3"><expression>[SQL2].[POOL_CUSTOM_TAG3]</expression></dataItem><dataItem name="STORAGE_SYSTEM"><expression>[SQL2].[STORAGE_SYSTEM]</expression></dataItem><dataItem name="THINPROVISIONED"><expression>[SQL2].[THINPROVISIONED]</expression></dataItem><dataItem name="ENCRYPTABLE"><expression>[SQL2].[ENCRYPTABLE]</expression></dataItem><dataItem name="ENCRYPTED"><expression>[SQL2].[ENCRYPTED]</expression></dataItem><dataItem name="STATUS"><expression>[SQL2].[STATUS]</expression></dataItem><dataItem name="RAID_LEVEL"><expression>[SQL2].[RAID_LEVEL]</expression></dataItem><dataItem name="IS_COMPRESSED"><expression>[SQL2].[IS_COMPRESSED]</expression></dataItem><dataItem name="SPECTRUMCONTROL_TIER"><expression>[SQL2].[SPECTRUMCONTROL_TIER]</expression></dataItem><dataItem name="POOL_EASYTIER"><expression>[SQL2].[POOL_EASYTIER]</expression></dataItem><dataItem name="POOL_EASYTIER_STATUS"><expression>[SQL2].[POOL_EASYTIER_STATUS]</expression></dataItem><dataItem name="STORAGESUBSYSTEM_CUSTOM_TAG1"><expression>[SQL2].[STORAGESUBSYSTEM_CUSTOM_TAG1]</expression></dataItem><dataItem name="STORAGESUBSYSTEM_CUSTOM_TAG2"><expression>[SQL2].[STORAGESUBSYSTEM_CUSTOM_TAG2]</expression></dataItem><dataItem name="STORAGESUBSYSTEM_CUSTOM_TAG3"><expression>[SQL2].[STORAGESUBSYSTEM_CUSTOM_TAG3]</expression></dataItem><dataItem name="VOL_TIER_CAPACITY"><expression>[SQL2].[VOL_TIER_CAPACITY]</expression></dataItem><dataItem name="APPLIST"><expression>[SQL2].[APPLIST]</expression></dataItem><dataItem name="CURRENT_DATE"><expression>[SQL2].[CURRENT_DATE]</expression></dataItem></selection>
</query></queries></report>
 
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset