Report subaccounts by region

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.

← Governance, Policy & Risk

Source: FOCUS MCP snapshot
FOCUS editions: v1.0, v1.1, v1.2
Queries: 1
Mode: Read-only
Library snapshot (UTC): 2026-10-08

This query uses the Provider column. Provider is deprecated in v1.3 and will be removed in v1.4.

Personas: FinOps Practitioner
Capabilities: Governance, Policy & Risk, Reporting & Analytics
KPIs: Percentage of Normalized, Queryable Data within Repository

Report subaccounts by region

Runs on sample

Source: FOCUS 1.0 sample
Result rows: 500
Status: Runs on sample
Execution: PrecomputedRead-only
Result snapshot (UTC): 2026-10-11

Which regions each subaccount has charges in, with the number of charge rows. The source's missing comma (RegionId RegionName) is fixed so both columns are returned. Rows with a null region are global charges.

Charge rows by region

Chart controls and notes

Showing the first 20 categories. Open full screen to explore all 37 categories.

Query results
Provider name	Sub account id	Region id	Region name	Charge count
AWS	11353890204	us-east-1	US East (N. Virginia)	15,843
AWS	18938484842	us-west-2	US West (Oregon)	10,235
AWS	11353890204	us-east-1	External	5,659
AWS	69918885631	us-west-2	US West (Oregon)	3,052
AWS	85742851457	us-west-2	US West (Oregon)	3,015
Microsoft	/subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42	eastus	East US	1,993
AWS	18938484842	eu-central-1	EU (Frankfurt)	1,623
AWS	90054491575	us-east-1	US East (N. Virginia)	1,535
AWS	69460568468	us-west-2	US West (Oregon)	1,532
AWS	18938484842	ap-northeast-1	Asia Pacific (Tokyo)	1,516
AWS	18938484842	ap-south-1	Asia Pacific (Mumbai)	1,504
AWS	84445137922	us-west-2	US West (Oregon)	1,450
AWS	18938484842	us-east-1	US East (N. Virginia)	1,410
AWS	18938484842	us-west-2	External	1,320
AWS	51738928782	us-west-2	US West (Oregon)	1,145
AWS	69918885631	us-west-2	External	1,046
Microsoft	/subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42	eastus2	East US 2	1,023
AWS	21473187560	us-west-2	US West (Oregon)	968
AWS	18938484842	ap-southeast-1	Asia Pacific (Singapore)	837
AWS	77596568903	us-west-2	US West (Oregon)	771
AWS	65226353821	eu-central-1	EU (Frankfurt)	753
AWS	85742851457	us-west-2	External	713
AWS	69460568468	us-west-2	External	701
AWS	70077301883	us-west-2	US West (Oregon)	681
AWS	83450778704	us-west-2	US West (Oregon)	673
AWS	18938484842	eu-west-2	EU (London)	609
AWS	86366525267	us-west-2	US West (Oregon)	587
AWS	55441562023	eu-north-1	EU (Stockholm)	576
AWS	84445137922	ap-southeast-2	Asia Pacific (Sydney)	566
AWS	68988428841	us-east-2	US East (Ohio)	562
AWS	79982682937	us-east-2	US East (Ohio)	561
AWS	85742851457	us-east-2	US East (Ohio)	561
AWS	60626892153	us-east-2	US East (Ohio)	558
AWS	15196455530	us-west-2	US West (Oregon)	544
AWS	31708171669	us-east-1	US East (N. Virginia)	527
AWS	45038667490	us-west-2	US West (Oregon)	496
AWS	28975285017	us-east-2	US East (Ohio)	483
AWS	58417724665	us-west-2	US West (Oregon)	482
AWS	21473187560	us-west-2	External	456
AWS	66362635077	us-west-2	US West (Oregon)	449
AWS	17370686428	us-east-1	US East (N. Virginia)	420
AWS	18938484842	ap-south-1	External	404
AWS	18938484842	ap-northeast-1	External	400
Oracle	ocid6.tenancy.oc6..aaaaaaaalnpeq6xok1okj8vknc9pzancima2g8bwvk2kk9jgwhgycacrie2q	–	us-sanjose-1	380
AWS	90054491575	us-east-1	External	379
AWS	97875037618	us-west-2	US West (Oregon)	376
AWS	85742851457	us-east-2	External	371
AWS	18938484842	eu-central-1	External	370
AWS	46124420288	us-west-2	US West (Oregon)	370
AWS	18938484842	us-east-1	External	362
AWS	83450778704	us-west-2	External	352
AWS	18938484842	sa-east-1	South America (Sao Paulo)	351
AWS	57437203586	us-west-2	US West (Oregon)	351
AWS	35661173597	us-west-2	US West (Oregon)	327
Microsoft	/subscriptions/9ec51cfd-5ca7-4d76-8101-dd0a4abc5674	eastus	East US	327
AWS	53610183123	us-west-2	US West (Oregon)	325
AWS	48430270467	us-west-2	US West (Oregon)	321
AWS	85742851457	us-east-1	US East (N. Virginia)	317
AWS	58417724665	us-west-2	External	314
AWS	41427911773	us-west-2	US West (Oregon)	306
AWS	43687688386	eu-west-1	EU (Ireland)	304
AWS	79651190712	us-west-2	US West (Oregon)	299
AWS	19407139323	eu-central-1	EU (Frankfurt)	298
AWS	18938484842	us-east-2	US East (Ohio)	287
AWS	38762433100	us-west-2	US West (Oregon)	282
AWS	59456266262	us-west-2	US West (Oregon)	281
AWS	60626892153	us-east-2	External	271
AWS	86366525267	ap-south-1	Asia Pacific (Mumbai)	269
AWS	79651190712	eu-central-1	EU (Frankfurt)	266
AWS	84445137922	us-west-1	US West (N. California)	255
AWS	67782387614	ap-northeast-1	Asia Pacific (Tokyo)	253
AWS	68988428841	us-east-2	External	247
AWS	82351714785	us-west-2	US West (Oregon)	239
AWS	15196455530	us-west-2	External	236
AWS	68974153460	us-west-2	US West (Oregon)	234
Microsoft	/subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42	centralus	Central US	234
AWS	59456266262	us-west-2	External	233
AWS	77596568903	us-west-2	External	231
AWS	46124420288	eu-west-3	EU (Paris)	223
AWS	46124420288	us-west-2	External	210
AWS	45038667490	us-west-2	External	208
AWS	18938484842	ap-southeast-1	External	207
AWS	38762433100	us-west-2	External	204
AWS	79982682937	us-east-2	External	204
AWS	18938484842	eu-west-2	External	193
AWS	34203734572	eu-west-1	EU (Ireland)	193
AWS	86366525267	us-west-2	External	192
AWS	53610183123	us-west-2	External	188
AWS	43883916739	us-west-2	US West (Oregon)	186
AWS	93042372971	us-east-1	US East (N. Virginia)	185
Oracle	ocid6.tenancy.oc6..aaaaaaaa2fs7w19bi9iupcjqv8zayogd78eziinl2hu7rkdvmuhsavhbmkma	–	us-sanjose-1	184
AWS	66362635077	us-west-2	External	183
AWS	12109731075	us-west-2	US West (Oregon)	179
AWS	28975285017	us-east-2	External	179
AWS	17370686428	us-east-1	External	177
AWS	23778638357	us-east-1	US East (N. Virginia)	177
Microsoft	/subscriptions/ed570627-0265-4620-bb42-bae06bcfa914	eastus	East US	177
AWS	41427911773	us-west-2	External	175
AWS	97875037618	us-west-2	External	175
Microsoft	/subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42	westus	West US	174

Showing 100 of 500 rows. Scroll inside the table to see more.

Precomputed result

Inspect Postgres SQL and original FOCUS SQL

Postgres SQL, as run

select provider_name,
       sub_account_id,
       region_id,
       region_name,
       count(*) as charge_count
from focus.cost_and_usage
where charge_period_start >= $1::timestamptz
  and charge_period_end < $2::timestamptz
group by 1, 2, 3, 4
order by charge_count desc, provider_name, sub_account_id, region_id
limit 500

Parameters: $1 = period_start, $2 = period_end

Original FOCUS SQL

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

Columns used

Column names from the source use case.

Read the source on focus.finops.org ↗