4g.148. Service Resources - Sample lines (OCI360_REPORTS_USAGE) 4g.148. Service Resources - Sample lines (OCI360_REPORTS_USAGE)
| # | lineItem/referenceNo | lineItem/tenantId | lineItem/intervalUsageStart | lineItem/intervalUsageEnd | product/service | product/resource | product/compartmentId | product/compartmentName | product/region | product/availabilityDomain | product/resourceId | usage/consumedQuantity | usage/billedQuantity | usage/consumedQuantityUnits | usage/consumedQuantityMeasure | lineItem/isCorrection | lineItem/backreferenceNo | tags/Oracle-Tags.CreatedBy | tags/Oracle-Tags.CreatedOn | tags/orcl-cloud.free-tier-retained | tags/backup |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | zmtWmBaN56GtXB/WrgeyC43fVaWMnz3yB1234QrpSDas9o8KQKorPqaT4s2mXEPtgM4UCXRyYklewvYAoNctAg== | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | 2020-05-31T12:00Z | 2020-05-31T13:00Z | BLOCK_STORAGE | PIC_STANDARD_STORAGE | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000210 | compt_dev_app | us-ashburn-1 | CYtq:US-ASHBURN-AD-2 | ocid1.bootvolume.oc1.iad.000000000000000000000000000000000000000000000000000000000202 | 1.67674224E8 | 1.67674E8 | GB_MS | STORAGE_SIZE | false | oracleidentitycloudservice/[email protected] | 2020-05-29T15:30:44.648Z | |||
| 2 | zmtWmBaN56GtXB/WrgeyC43fVaWMnz3yB1234QrpSDas9o8KQKorPqaT4s2mXEPt5cHGF50Paf8rQ49Q8NJX+Q== | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | 2020-06-01T13:00Z | 2020-06-01T14:00Z | BLOCK_STORAGE | PIC_STANDARD_PERFORMANCE | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000210 | compt_dev_app | us-ashburn-1 | CYtq:US-ASHBURN-AD-2 | ocid1.bootvolume.oc1.iad.000000000000000000000000000000000000000000000000000000000202 | 1.676742144E9 | 1.67674202E9 | GB_MS | PERFORMANCE_UNITS | false | oracleidentitycloudservice/[email protected] | 2020-05-29T15:30:44.648Z | |||
| 3 | zmtWmBaN56GtXB/WrgeyC43fVaWMnz3yB1234QrpSDas9o8KQKorPqaT4s2mXEPtAmZzhHYAGQJ5DwsJEJ4mHg== | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | 2020-06-01T23:00Z | 2020-06-02T00:00Z | OBJECTSTORE | PIC_OBJECT_STORAGE_REQUEST_TIERED | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000225 | Dev | us-ashburn-1 | UnknownBucket | 1.0 | 1.0 | COUNT | REQUESTS | false | ||||||
| 4 | zmtWmBaN56GtXB/WrgeyC43fVaWMnz3yB1234QrpSDas9o8KQKorPqaT4s2mXEPtK8vAJLhhpYRWjcqLjhCvqw== | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | 2020-06-02T06:00Z | 2020-06-02T07:00Z | 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.0 | 3600000.0 | MS | OCPUS | false | oracleidentitycloudservice/[email protected] | 2020-05-20T14:54:00.387Z | true | ||
| 5 | zmtWmBaN56GtXB/WrgeyC43fVaWMnz3yB1234QrpSDas9o8KQKorPqaT4s2mXEPthW15M1BdjNqo86togC/A7A== | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | 2020-06-03T05:00Z | 2020-06-03T06:00Z | OBJECTSTORE | PIC_OBJECT_STORAGE_REQUEST_TIERED | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000220 | A | us-ashburn-1 | UnknownBucket | 1.0 | 1.0 | COUNT | REQUESTS | false | ||||||
| 6 | zmtWmBaN56GtXB/WrgeyC43fVaWMnz3yB1234QrpSDas9o8KQKorPqSw0RJqHX57H0+42LINhUNYq+JTk58wWw== | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | 2020-06-08T04:00Z | 2020-06-08T05:00Z | OBJECTSTORE | PIC_COMPUTE_OUTBOUND_DATA_TRANSFER | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000229 | compt_dev_db | us-ashburn-1 | oci360 | 0.0 | 0.0 | BYTES | DATA_TRANSFERRED | false | oracleidentitycloudservice/[email protected] | 2020-05-14T21:14:55.372Z | ||||
| 7 | zmtWmBaN56GtXB/WrgeyC43fVaWMnz3yB1234QrpSDas9o8KQKorPqSw0RJqHX57sC7QbCTd+/YpWb2nZ0BaOw== | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | 2020-06-08T05:00Z | 2020-06-08T06:00Z | OBJECTSTORE | PIC_OBJECT_STORAGE_REQUEST_TIERED | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000217 | Ops | us-ashburn-1 | UnknownBucket | 1.0 | 1.0 | COUNT | REQUESTS | false | ||||||
| 8 | zmtWmBaN56GtXB/WrgeyC43fVaWMnz3yB1234QrpSDas9o8KQKorPqSw0RJqHX57HZlee/qB2Y4PbcMWuuVjdA== | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | 2020-06-08T11:00Z | 2020-06-08T12:00Z | OBJECTSTORE | PIC_OBJECT_STORAGE_TIERED | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000229 | compt_dev_db | us-ashburn-1 | idgimbpbaoa7/oci360 | 5365807.5 | 5365807.5 | GB_MS | STORAGE_SIZE | false | oracleidentitycloudservice/[email protected] | 2020-05-14T21:14:55.372Z | ||||
| 9 | zmtWmBaN56GtXB/WrgeyC43fVaWMnz3yB1234QrpSDas9o8KQKorPqSw0RJqHX57d+tXh890eD9+BakGlELNxQ== | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | 2020-06-11T08:00Z | 2020-06-11T09:00Z | OBJECTSTORE | PIC_OBJECT_STORAGE_REQUEST_TIERED | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000216 | compt_dev | us-ashburn-1 | UnknownBucket | 1.0 | 1.0 | COUNT | REQUESTS | false | ||||||
| 10 | zmtWmBaN56GtXB/WrgeyC43fVaWMnz3yB1234QrpSDas9o8KQKorPqSw0RJqHX57jtuFFSaaShHXtOXGBryK9w== | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | 2020-06-15T12:00Z | 2020-06-15T13:00Z | OBJECTSTORE | PIC_OBJECT_STORAGE_TIERED | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000229 | compt_dev_db | us-ashburn-1 | idgimbpbaoa7/oci360 | 5365807.5 | 5365000.0 | GB_MS | STORAGE_SIZE | false | oracleidentitycloudservice/[email protected] | 2020-05-14T21:14:55.372Z | ||||
| 11 | zmtWmBaN56GtXB/WrgeyC43fVaWMnz3yB1234QrpSDas9o8KQKorPqSw0RJqHX57aFk8LEs56B6WT7RBF9sn0w== | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | 2020-06-17T22:00Z | 2020-06-17T23:00Z | OBJECTSTORE | PIC_COMPUTE_OUTBOUND_DATA_TRANSFER | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000229 | compt_dev_db | us-ashburn-1 | pnb_bucket | 0.0 | 0.0 | BYTES | DATA_TRANSFERRED | false | oracleidentitycloudservice/[email protected] | 2020-06-12T14:25:37.187Z | ||||
| 12 | zmtWmBaN56GtXB/WrgeyC43fVaWMnz3yB1234QrpSDas9o8KQKorPqSw0RJqHX57V7Upi4ZgH7Dh/1g3HhYoVg== | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | 2020-06-18T01:00Z | 2020-06-18T02:00Z | OBJECTSTORE | PIC_OBJECT_STORAGE_TIERED | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000229 | compt_dev_db | us-ashburn-1 | idgimbpbaoa7/oci360_bucket | 70147.12 | 70000.0 | GB_MS | STORAGE_SIZE | false | [email protected] | 2020-05-20T14:04:10.722Z |
#: 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 t1.*
FROM OCI360_REPORTS_USAGE SAMPLE(0.1) t1;
12 rows selected.