🧠 Azure SQL Managed Instance is located in a less cost-effective region - prod.logic.yaml🟢

• Contextual name: 🧠 prod.logic.yaml🟢
• ID: /ce/ca/azure/sql-managed-instance/instance-cost-effective-region/prod.logic.yaml
• Tags:
  • 🟢 Logic test success
  • 🟢 Logic with extracts
  • 🟢 Logic with test data

Uses

• 📗 Azure SQL Managed Instance
• 🔌 Azure SQL Managed Instance - object.extracts.yaml
• 🧪 test-data.json

Test Results 🟢

Generated at: 2026-02-10T22:33:36.915871783Z Open

Result	Id	Condition Index	Condition Text	Runtime Error
🟢	001	✔️ 99	✔️ isDisappeared(CA10Z1__disappearanceTime__c)	✔️ null
🟢	002	✔️ 1199	✔️ extract('CA10Z1__locationName__c') == 'westeurope'	✔️ null
🟢	003	✔️ 2400	✔️ otherwise	✔️ null

Generation Bundle

	File	MD5
Open	/ce/ca/azure/sql-managed-instance/instance-cost-effective-region/policy.yaml	94FCB4748600D10BB06DC936ADE11332
Open	/ce/ca/azure/sql-managed-instance/instance-cost-effective-region/prod.logic.yaml	BB59DCC7C3FC75DAFF19A8B1ED480808
Open	/ce/ca/azure/sql-managed-instance/instance-cost-effective-region/test-data.json	AF94211BE7958485C7C5C69362FE3676
Open	/types/CA10Z1__CaAzureSqlManagedInstance__c/object.extracts.yaml	CEB619A9B852A33627260BC10279728E

Available Commands

repo-manager policies generate FULL /ce/ca/azure/sql-managed-instance/instance-cost-effective-region/prod.logic.yaml
repo-manager policies generate DEBUG /ce/ca/azure/sql-managed-instance/instance-cost-effective-region/prod.logic.yaml
repo-manager policies generate CAPTURE_TEST_DATA /ce/ca/azure/sql-managed-instance/instance-cost-effective-region/prod.logic.yaml
repo-manager policies generate TESTS /ce/ca/azure/sql-managed-instance/instance-cost-effective-region/prod.logic.yaml
# Execute tests
repo-manager policies test /ce/ca/azure/sql-managed-instance/instance-cost-effective-region/prod.logic.yaml

Content

Open File

---
inputType: "CA10Z1__CaAzureSqlManagedInstance__c"
importExtracts:
  - file: "/types/CA10Z1__CaAzureSqlManagedInstance__c/object.extracts.yaml"
testData:
  - file: 'test-data.json'
conditions:
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in westus which is more expensive than westus3 or westus2."
    remediationMessage: "Migrate the instance to westus3 or westus2."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "westus"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in westcentralus which is more expensive than westus3 or westus2."
    remediationMessage: "Migrate the instance to westus3 or westus2."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "westcentralus"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in southcentralus which is more expensive than northcentralus, westus3 or westus2."
    remediationMessage: "Migrate the instance to northcentralus, westus3 or westus2."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "southcentralus"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in centralus which is more expensive than northcentralus, westus3 or westus2."
    remediationMessage: "Migrate the instance to northcentralus, westus3 or westus2."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "centralus"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in canadaeast which is more expensive than eastus or eastus2."
    remediationMessage: "Migrate the instance to eastus or eastus2."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "canadaeast"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in canadacentral which is more expensive than eastus or eastus2."
    remediationMessage: "Migrate the instance to eastus or eastus2."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "canadacentral"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in ukwest which is more expensive than eu-west-1, eu-north-1, or eu-south-2."
    remediationMessage: "Migrate the instance to eu-west-1, eu-north-1, or eu-south-2."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "ukwest"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in uksouth which is more expensive than eu-west-1, eu-north-1, or eu-south-2."
    remediationMessage: "Migrate the instance to eu-west-1, eu-north-1, or eu-south-2."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "uksouth"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in francecentral which is more expensive than eu-west-1, eu-north-1, or eu-south-2."
    remediationMessage: "Migrate the instance to eu-west-1, eu-north-1, or eu-south-2."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "francecentral"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in francesouth which is more expensive than eu-west-1, eu-north-1, or eu-south-2."
    remediationMessage: "Migrate the instance to eu-west-1, eu-north-1, or eu-south-2."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "francesouth"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in westeurope which is more expensive than northeurope."
    remediationMessage: "Migrate the instance to northeurope."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "westeurope"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in germanywestcentral which is more expensive than northeurope."
    remediationMessage: "Migrate the instance to northeurope."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "germanywestcentral"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in germanynorth which is more expensive than northeurope."
    remediationMessage: "Migrate the instance to northeurope."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "germanynorth"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in switzerlandnorth which is more expensive than northeurope."
    remediationMessage: "Migrate the instance to northeurope."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "switzerlandnorth"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in switzerlandwest which is more expensive than northeurope."
    remediationMessage: "Migrate the instance to northeurope."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "switzerlandwest"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in italynorth which is more expensive than northeurope."
    remediationMessage: "Migrate the instance to northeurope."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "italynorth"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in polandcentral which is more expensive than northeurope."
    remediationMessage: "Migrate the instance to northeurope."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "polandcentral"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in norwayeast which is more expensive than northeurope."
    remediationMessage: "Migrate the instance to northeurope."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "norwayeast"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in norwaywest which is more expensive than northeurope."
    remediationMessage: "Migrate the instance to northeurope."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "norwaywest"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in swedensouth which is more expensive than northeurope."
    remediationMessage: "Migrate the instance to northeurope."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "swedensouth"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in spaincentral which is more expensive than northeurope."
    remediationMessage: "Migrate the instance to northeurope."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "spaincentral"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in southindia which is more expensive than centralindia or westindia."
    remediationMessage: "Migrate the instance to centralindia or westindia."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "southindia"
  - status: "INCOMPLIANT"
    currentStateMessage: "The instance is running in japanwest which is more expensive than koreasouth, japaneast or koreacentral."
    remediationMessage: "Migrate the instance to koreasouth, japaneast or koreacentral."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10Z1__locationName__c
        right:
          TEXT: "japanwest"
otherwise:
  status: "COMPLIANT"
  currentStateMessage: "The instance is located in a cost-effective region."