Premium App Configuration store on a non-production store

Paste this into Resource Graph Explorer in the Azure portal.

resources
| where type =~ 'microsoft.appconfiguration/configurationstores'
// Scope below matches CloudFinOpsPro policy DEFAULTS: exclusions.protectTag, environment.tagKeys,
// environment.allowedTagValues, and allowUntagged false so an untagged resource counts as production.
// If your policy.yaml differs, edit the three lines below or this will disagree with your own agent.
| where tolower(tostring(coalesce(tags['cfop:protect'], ''))) !in ('true', 'yes', '1')
| extend cfopEnv = tolower(trim(' ', tostring(coalesce(tags['Environment'], tags['environment'], tags['env'], ''))))
| where cfopEnv in ('dev', 'development', 'test', 'qa', 'sandbox', 'nonprod', 'non-prod', 'staging')
| extend tier = tostring(coalesce(sku.name, properties.sku.name))
| where tier =~ 'Premium'
| project name, resourceGroup, location, tier, targetTier = 'Standard', environment = cfopEnv

Reads sku.name, which is where Microsoft's own ARM template reference puts the tier (sku: { name: 'standard' }). properties.sku.name is coalesced in as well because a store returned by an older API version can carry it there, and a store that looked untiered would be skipped silently, which is a miss that looks exactly like a clean estate. The target is Standard and deliberately NOT Free or Developer, even though both are cheaper: Microsoft supports downgrading only between Premium and Standard, both production tiers, and states that downgrading to a non-production tier such as Free is not supported. Reaching Free or Developer means creating a new store and importing the data, so quoting either as a saving would quote a number nobody can act on. One precondition this query cannot check, and neither can the agent: Microsoft requires regular storage and snapshot storage to be below the Standard limits before the downgrade, verifiable through the Daily Storage Usage and Snapshot Storage Size metrics on the store. Confirm those before changing the tier.