with my_data AS (
select key_value2, rollup_timestamp, average
from mgmt$metric_daily
where target_type = 'osm_cluster' and key_value like 'DATA%' and column_label = 'Total Bytes'
and rollup_timestamp >= sysdate-14
)
select * from my_data
pivot
( sum(average/1024/1024/1024)
for key_value2
IN ('ASM',
'EILPRD1',
'EILPRDDOV',
'EILPRDSUN',
'NEWDSS02DOV',
'NEWDSS03PRD',
'NEWDSSOAP01',
'NEWDSSOAP04',
'NEWSOA02DOV',
'NEWSOAP01',
'NEWSOAP04',
'NEWTOLTTP01',
'ORCDBAUZ01',
'SBYDSS02DOV',
'SBYDSS02PRD',
'SBYDSS03PRD',
'SBYDSSOAP01',
'SBYSOA02SUN',
'SBYSOAP01',
'SBYSOAP042',
'SBYTOLTTP01',
'STBDSSOAP04',
'WMPRD',
'WMPRDDOV',
'WMPRDSUN')
)
order by rollup_timestamp;