4g.147. Distinct Objects per Resource (OCI360_REPORTS_USAGE) 4g.147. Distinct Objects per Resource (OCI360_REPORTS_USAGE)
| # | RESOURCE_PRODUCT | RESOURCE_ID_PREF | TOTAL_DISTINCT_RESOURCES |
|---|---|---|---|
| 1 | PIC_STANDARD_CONVERSION_METER_DBAAS | ocid1.autonomousdatabase.oc1.iad | 1 |
| 2 | PIC_BLOCK_STORAGE_STANDARD_FREE | ocid1.bootvolume.oc1.iad | 1 |
| 3 | PIC_STANDARD_PERFORMANCE | ocid1.bootvolume.oc1.iad | 1 |
| 4 | PIC_STANDARD_STORAGE | ocid1.bootvolume.oc1.iad | 1 |
| 5 | PIC_BLOCK_STORAGE_STANDARD | ocid1.dbsystem.oc1.iad | 2 |
| 6 | PIC_DATABASE_CLOUD_ENTERPRISE_EDITION | ocid1.dbsystem.oc1.iad | 2 |
| 7 | PIC_COMPUTE_STANDARD_E2 | ocid1.instance.oc1.iad | 1 |
| 8 | PIC_COMPUTE_VM_STANDARD_E2_MICRO_FREE | ocid1.instance.oc1.iad | 1 |
| 9 | PIC_COMPUTE_OUTBOUND_DATA_TRANSFER | ocid1.vnic.oc1.iad | 4 |
| 10 | PIC_BLOCK_STORAGE_STANDARD_FREE | ocid1.volume.oc1.iad | 1 |
| 11 | PIC_STANDARD_PERFORMANCE | ocid1.volume.oc1.iad | 3 |
| 12 | PIC_STANDARD_STORAGE | ocid1.volume.oc1.iad | 3 |
| 13 | PIC_OBJECT_STORAGE_TIERED | ocid1.volumebackup.oc1.iad | 4 |
| 14 | PIC_COMPUTE_OUTBOUND_DATA_TRANSFER | 4 | |
| 15 | PIC_METRIC_CONSUMPTION | 3 | |
| 16 | PIC_OBJECT_STORAGE_REQUEST_TIERED | 4 | |
| 17 | PIC_OBJECT_STORAGE_TIERED | 3 |
#: 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 resource_product,
substr(resource_id,1,instr(resource_id,'.',1,4)-1) resource_id_pref,
count(*) total_distinct_resources
FROM ( select distinct "product/resource" resource_product, "product/resourceId" resource_id
from OCI360_REPORTS_USAGE )
GROUP BY resource_product, substr(resource_id,1,instr(resource_id,'.',1,4)-1)
ORDER BY resource_id_pref,resource_product,total_distinct_resources DESC;
17 rows selected.