4h.197. Distinct Objects per Resource (OCI360_REPORTS_COST) 4h.197. Distinct Objects per Resource (OCI360_REPORTS_COST)
| # | product/service | RESOURCE_ID_PREF | TOTAL_DISTINCT_RESOURCES |
|---|---|---|---|
| 1 | DATABASE | ocid1.autonomousdatabase.oc1.iad | 1 |
| 2 | BLOCK_STORAGE | ocid1.bootvolume.oc1.iad | 5 |
| 3 | DATABASE | ocid1.dbsystem.oc1.iad | 2 |
| 4 | COMPUTE | ocid1.instance.oc1.iad | 5 |
| 5 | NETWORK | ocid1.vnic.oc1.iad | 8 |
| 6 | BLOCK_STORAGE | ocid1.volume.oc1.iad | 2 |
| 7 | OBJECTSTORE | 9 | |
| 8 | TELEMETRY | 4 |
#: click on a column heading to sort on it
Report Usage info is between 2020-05-11 and 2020-06-20.
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
lineItem/referenceNo VARCHAR2(4000)
lineItem/tenantId VARCHAR2(4000)
lineItem/intervalUsageStart VARCHAR2(4000)
lineItem/intervalUsageEnd VARCHAR2(4000)
product/service VARCHAR2(4000)
product/compartmentId VARCHAR2(4000)
product/compartmentName VARCHAR2(4000)
product/region VARCHAR2(4000)
product/availabilityDomain VARCHAR2(4000)
product/resourceId VARCHAR2(4000)
usage/billedQuantity VARCHAR2(4000)
usage/billedQuantityOverage VARCHAR2(4000)
cost/subscriptionId VARCHAR2(4000)
cost/productSku VARCHAR2(4000)
product/Description VARCHAR2(4000)
cost/unitPrice VARCHAR2(4000)
cost/unitPriceOverage VARCHAR2(4000)
cost/myCost VARCHAR2(4000)
cost/myCostOverage VARCHAR2(4000)
cost/currencyCode VARCHAR2(4000)
cost/billingUnitReadable VARCHAR2(4000)
cost/overageFlag 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)
SELECT "product/service",
substr(resource_id,1,instr(resource_id,'.',1,4)-1) resource_id_pref,
count(*) total_distinct_resources
FROM ( select distinct "product/service", "product/resourceId" resource_id
from OCI360_REPORTS_COST )
GROUP BY "product/service", substr(resource_id,1,instr(resource_id,'.',1,4)-1)
ORDER BY resource_id_pref,total_distinct_resources DESC;
8 rows selected.