4g.171. Other Objects - Hourly - Constant Usage (OCI360_REPORTS_USAGE) 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.