4h.192. Services Utilization (OCI360_REPORTS_COST) 4h.192. Services Utilization (OCI360_REPORTS_COST)
| # | Service | Date Min | Date Max | subscriptionId | SKU | Currency | Units | Total Cost |
|---|---|---|---|---|---|---|---|---|
| 1 | OBJECTSTORE | 2020-05-14T21:00Z | 2020-06-20T10:00Z | 7732965 | B91627 | USD | 10000 HOURS REQUESTS | .137458939935 |
| 2 | DATABASE | 2020-05-29T16:00Z | 2020-06-03T13:00Z | 7732965 | B88322 | USD | ONE GiB MONTHS STORAGE_SIZE | 5.084005375 |
| 3 | BLOCK_STORAGE | 2020-05-20T15:00Z | 2020-06-03T13:00Z | 7732965 | B91961 | USD | ONE GiB MONTHS STORAGE_SIZE | .1948731003 |
| 4 | BLOCK_STORAGE | 2020-05-20T15:00Z | 2020-06-03T13:00Z | 7732965 | B91962 | USD | ONE GiB MONTHS PERFORMANCE_UNITS | .1299155614 |
| 5 | DATABASE | 2020-05-29T16:00Z | 2020-06-03T13:00Z | 7732965 | B90570 | USD | ONE HOURS OCPUS | 6.4438 |
| 6 | COMPUTE | 2020-05-29T15:00Z | 2020-06-03T13:00Z | 7732965 | B90425 | USD | ONE HOURS OCPUS | 2.9763916668 |
#: 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" "Service",
MIN("lineItem/intervalUsageStart") "Date Min",
MAX("lineItem/intervalUsageStart") "Date Max",
"cost/subscriptionId" "subscriptionId",
"cost/productSku" "SKU",
"cost/currencyCode" "Currency",
"cost/billingUnitReadable" "Units",
TO_CHAR(SUM("cost/myCost")) "Total Cost"
FROM OCI360_REPORTS_COST t1
GROUP BY "product/service",
"cost/subscriptionId",
"cost/productSku",
"cost/currencyCode",
"cost/billingUnitReadable"
HAVING SUM("cost/myCost")>0;
6 rows selected.