oci360 4g.152. Service: BLOCK_STORAGE - GB_MS STORAGE_SIZE between 2020-05-29 and 2020-06-28 (OCI360_REPORTS_USAGE)


# RESOURCE_NAME TOTAL PERCENT
1 PIC_STANDARD_STORAGE - 27844606564 27844606564 9.92
2 PIC_OBJECT_STORAGE_TIERED - 2943152803.08594 2943152803.08594 1.05
3 PIC_BLOCK_STORAGE_STANDARD_FREE - 249977767056 249977767056 89.03

#: click on a column heading to sort on it

 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