4g.168. Computes - Hourly - Constant Usage (OCI360_REPORTS_USAGE) 4g.168. Computes - Hourly - Constant Usage (OCI360_REPORTS_USAGE)
| # | product/service | product/resource | product/compartmentId | product/compartmentName | product/region | product/availabilityDomain | product/resourceId | TO_CHAR(TO_NUMBER("USAGE/CONSUMEDQUANTIT | TO_CHAR(TO_NUMBER("USAGE/BILLEDQUANTITY" | Difference | usage/consumedQuantityUnits | usage/consumedQuantityMeasure |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | COMPUTE | PIC_COMPUTE_VM_STANDARD_E2_MICRO_FREE | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000210 | compt_dev_app | us-ashburn-1 | CYtq:US-ASHBURN-AD-3 | ocid1.instance.oc1.iad.000000000000000000000000000000000000000000000000000000000575 | 3600000 | 3600000 | 0 | MS | OCPUS |
#: 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
"product/service"
,"product/resource"
,"product/compartmentId"
,"product/compartmentName"
,"product/region"
,"product/availabilityDomain"
,"product/resourceId"
,TO_CHAR(TO_NUMBER("usage/consumedQuantity"))
,TO_CHAR(TO_NUMBER("usage/billedQuantity"))
,TO_CHAR(TO_NUMBER("usage/consumedQuantity") - TO_NUMBER("usage/billedQuantity")) "Difference"
,"usage/consumedQuantityUnits"
,"usage/consumedQuantityMeasure"
FROM OCI360_REPORTS_USAGE
WHERE substr("product/resourceId",1,instr("product/resourceId",'.',1,2)-1) = 'ocid1.instance'
AND ("product/resource", "product/resourceId") NOT IN
( SELECT "product/resource", "product/resourceId" FROM OCI360_REPORTS_USAGE_TEMP )
ORDER BY "product/service"
,"product/resource"
,"product/resourceId";
1 rows selected.