Report subaccounts by region

FOCUS Versions

v1.3 v1.4

Context

FinOps Practitioners must identify if there are any data residency/ localization/ sovereignty inconsistencies. In order to identify any potential anomalies, they would like to see if the resource being billed for exists in the same geography as the primary payer account. If they do not exist in the same geography, the team would like it flagged for analysis.

FOCUS SQL Query

SELECT
  ServiceProviderName,
  SubAccountId,
  RegionId,
  RegionName,
  COUNT(1)
FROM focus_data_table
WHERE ChargePeriodStart  >= ? AND ChargePeriodEnd < ?
GROUP BY
  ServiceProviderName,
  SubAccountId,
  RegionId,
  RegionName

FOCUS Datasets

Contract Commitment Cost and Usage

FOCUS Columns

Service Provider Name Sub Account ID Region ID Region Name Charge Period Start Charge Period End

FinOps Practitioner

Previous Get historical usage and rates to enable cost forecasting Next Reconcile Cost and Usage to Invoice Detail by Invoice ID