4g.152. Service: BLOCK_STORAGE - GB_MS STORAGE_SIZE between 2020-05-29 and 2020-06-28 (OCI360_REPORTS_USAGE)
Notes:
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
lineItem/referenceNo VARCHAR2(4000)
lineItem/tenantId VARCHAR2(4000)
lineItem/intervalUsageStart VARCHAR2(4000)
lineItem/intervalUsageEnd VARCHAR2(4000)
product/service VARCHAR2(4000)
product/resource VARCHAR2(4000)
product/compartmentId VARCHAR2(4000)
product/compartmentName VARCHAR2(4000)
product/region VARCHAR2(4000)
product/availabilityDomain VARCHAR2(4000)
product/resourceId VARCHAR2(4000)
usage/consumedQuantity VARCHAR2(4000)
usage/billedQuantity VARCHAR2(4000)
usage/consumedQuantityUnits VARCHAR2(4000)
usage/consumedQuantityMeasure VARCHAR2(4000)
lineItem/isCorrection VARCHAR2(4000)
lineItem/backreferenceNo VARCHAR2(4000)
tags/Oracle-Tags.CreatedBy VARCHAR2(4000)
tags/Oracle-Tags.CreatedOn VARCHAR2(4000)
tags/orcl-cloud.free-tier-retained VARCHAR2(4000)
tags/backup VARCHAR2(4000)
WITH tot as
(SELECT SUM("usage/consumedQuantity") total_global
FROM OCI360_REPORTS_USAGE
where "product/service" = 'BLOCK_STORAGE' AND TRIM("usage/consumedQuantityUnits" || ' ' || "usage/consumedQuantityMeasure") = 'GB_MS STORAGE_SIZE'
)
SELECT "product/resource" || ' - ' || SUM("usage/consumedQuantity") resource_name,
SUM("usage/consumedQuantity") total,
trim(to_char(round(SUM("usage/consumedQuantity")/decode(total_global,0,1,total_global),4)*100,'990D99')) percent
FROM OCI360_REPORTS_USAGE, tot
where "product/service" = 'BLOCK_STORAGE' AND TRIM("usage/consumedQuantityUnits" || ' ' || "usage/consumedQuantityMeasure") = 'GB_MS STORAGE_SIZE'
GROUP BY "product/resource",total_global;
3 rows selected.
oci360 (c) 2020, All rights reserved. oci360 v20.06 (2020-06-25) based on moat369 v2002 (2020-02-27). Timestamp: 2020-06-30T15:58:05