oci360 4g.171. Other Objects - Hourly - Constant Usage (OCI360_REPORTS_USAGE)


# product/service product/resource product/compartmentId product/compartmentName product/region product/availabilityDomain product/resourceId TO_CHAR(TO_NUMBER(T1."USAGE/CONSUMEDQUAN TO_CHAR(TO_NUMBER(T1."USAGE/BILLEDQUANTI Difference usage/consumedQuantityUnits usage/consumedQuantityMeasure
1 DATABASE PIC_STANDARD_CONVERSION_METER_DBAAS ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000229 compt_dev_db us-ashburn-1 CYtq:US-ASHBURN-AD-1 ocid1.autonomousdatabase.oc1.iad.000000000000000000000000000000000000000000000000000000000138 72000 72000 0 TB_MS STORAGE_SIZE
2 DATABASE PIC_STANDARD_CONVERSION_METER_DBAAS ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000229 compt_dev_db us-ashburn-1 CYtq:US-ASHBURN-AD-1 ocid1.autonomousdatabase.oc1.iad.000000000000000000000000000000000000000000000000000000000138 3600000 3600000 0 MS OCPUS
3 TELEMETRY PIC_METRIC_CONSUMPTION ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000210 compt_dev_app us-ashburn-1   oci_blockstore 244 244 0 COUNT DATAPOINTS
4 TELEMETRY PIC_METRIC_CONSUMPTION ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000210 compt_dev_app us-ashburn-1   oci_computeagent 488 488 0 COUNT DATAPOINTS
5 TELEMETRY PIC_METRIC_CONSUMPTION ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000229 compt_dev_db us-ashburn-1   oci_blockstore 244 244 0 COUNT DATAPOINTS

#: click on a column heading to sort on it
Report Usage info is between 2020-05-29 and 2020-06-28.

 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)


SELECT DISTINCT
       t1."product/service"
      ,t1."product/resource"
      ,t1."product/compartmentId"
      ,t1."product/compartmentName"
      ,t1."product/region"
      ,t1."product/availabilityDomain"
      ,t1."product/resourceId"
      ,TO_CHAR(TO_NUMBER(t1."usage/consumedQuantity"))
      ,TO_CHAR(TO_NUMBER(t1."usage/billedQuantity"))
      ,TO_CHAR(TO_NUMBER(t1."usage/consumedQuantity") - TO_NUMBER(t1."usage/billedQuantity")) "Difference"
      ,t1."usage/consumedQuantityUnits"
      ,t1."usage/consumedQuantityMeasure"
FROM  OCI360_REPORTS_USAGE t1, OCI360_REPORTS_USAGE_TEMP t2
WHERE  (
       substr(t1."product/resourceId",1,instr(t1."product/resourceId",'.',1,2)-1)
       NOT IN ('ocid1.instance',
               'ocid1.volumebackup',
               'ocid1.bootvolumebackup',
               'ocid1.volume',
               'ocid1.bootvolume',
               'ocid1.vnic')
OR     nvl(substr(t1."product/resourceId",1,instr(t1."product/resourceId",'.',1,1)-1),'x') != 'ocid1'
      )
AND   t1."product/resourceId" = t2."product/resourceId" (+)
AND   t1."product/resource" = t2."product/resource" (+)
AND   t2."product/resource" is null AND t2."product/resourceId" is null;


5 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:59:39