Report subaccounts by region

Asset Library / FinOps Use Cases / Report subaccounts by region

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 Columns

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

FOCUS SQL Query

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

Related KPIs

Percentage of Normalized, Queryable Data within Repository

Calculate percentage of normalized and queryable data in data warehouse, repository, or similar, vs Accounts Payable Invoice.

The main output of this capability is a data repository of normalized, queryable data from which reporting, analysis, and visualization of cloud cost and usage will occur. This KPI is about organizing the foundation for insights and making it accessible for cost-insight products.