🧠 Azure Subscription Microsoft Defender For (Managed Instance) Azure SQL Databases is not set to On - prod.logic.yaml 🟢

• Contextual name: 🧠 prod.logic.yaml 🟢
• ID: /ce/ca/azure/subscription/microsoft-defender-for-sql-databases/prod.logic.yaml
• Located in: 📝 Azure Subscription Microsoft Defender For (Managed Instance) Azure SQL Databases is not set to On 🟢

Flags

• 🟢 Logic test success
• 🟢 Logic with extracts
• 🟢 Logic with test data

Input Type

	Type	API Name	Extracts	Extract Files	Logic Files
🔒	📕 Azure Subscription	CA10__CaAzureAccount__c	13	1	31

Uses

• 🔌 Azure Defender Plan - object.extracts.yaml
• 🧪 test-data.json

Test Results 🟢

Generated at: 2025-04-24T23:46:23.663663216Z Open

Result	Id	Condition Index	Condition Text	Runtime Error
🟢	test1	✔️ 199	✔️ CA10Z1__Azure_SQL_Server_Vulnerability_Assessmnt__r.has(INCOMPLIANT)	✔️ null
🟢	test2	✔️ 299	✔️ CA10Z1__Azure_SQL_Server_Vulnerability_Assessmnt__r.has(COMPLIANT)	✔️ null
🟢	test3	✔️ 300	✔️ otherwise	✔️ null
🟢	test4	✔️ 300	✔️ otherwise	✔️ null

Generation

	File	MD5
Open	/ce/ca/azure/subscription/microsoft-defender-for-sql-databases/policy.yaml	80D7A4DC7739054BDCB4E01F5C92D678
Open	/ce/ca/azure/subscription/microsoft-defender-for-sql-databases/prod.logic.yaml	7DB898FEEEE4E6DF45FAAC5DF587D55C
Open	/ce/ca/azure/subscription/microsoft-defender-for-sql-databases/test-data.json	9B107393EFF2EF29DBB628C9B00778EF
Open	/types/CA10Z1__CaAzureDefenderPlan__c/object.extracts.yaml	5DCAFDE8B3F3B4436C9A1165F58784CB

Generate FULL script

java -jar repo-manager.jar policies generate FULL /ce/ca/azure/subscription/microsoft-defender-for-sql-databases/prod.logic.yaml

Generate DEBUG script

java -jar repo-manager.jar policies generate DEBUG /ce/ca/azure/subscription/microsoft-defender-for-sql-databases/prod.logic.yaml

Generate CAPTURE_TEST_DATA script

java -jar repo-manager.jar policies generate CAPTURE_TEST_DATA /ce/ca/azure/subscription/microsoft-defender-for-sql-databases/prod.logic.yaml

Generate TESTS script

java -jar repo-manager.jar policies generate TESTS /ce/ca/azure/subscription/microsoft-defender-for-sql-databases/prod.logic.yaml

Execute tests

java -jar repo-manager.jar policies test /ce/ca/azure/subscription/microsoft-defender-for-sql-databases/prod.logic.yaml

Content

Open File

---
inputType: "CA10__CaAzureAccount__c"
testData:
  - file: "test-data.json"
conditions:
  - status: "INCOMPLIANT"
    currentStateMessage: "Microsoft Defender for SQL Databases is in Free tier."
    remediationMessage: "Consider enabling Defender for SQL Databases Standard plan."
    check:
      RELATED_LIST_HAS:
        relationshipName: "CA10Z1__Azure_SQL_Server_Vulnerability_Assessmnt__r"
        status: "INCOMPLIANT"
  - status: "COMPLIANT"
    currentStateMessage: "Microsoft Defender for SQL Databases Standard tier is enabled."
    check:
      RELATED_LIST_HAS:
        relationshipName: "CA10Z1__Azure_SQL_Server_Vulnerability_Assessmnt__r"
        status: "COMPLIANT"
otherwise:
  status: "INCOMPLIANT"
  currentStateMessage: "Microsoft Defender for SQL Databases is not enabled."
  remediationMessage: "Consider enabling Microsoft Defender for SQL Databases Standard plan."
relatedLists:
  - relationshipName: "CA10Z1__Azure_SQL_Server_Vulnerability_Assessmnt__r"
    importExtracts:
      - file: "/types/CA10Z1__CaAzureDefenderPlan__c/object.extracts.yaml"
    conditions:
      - status: "INAPPLICABLE"
        currentStateMessage: "Other pricing configurations."
        check:
          NOT_EQUAL:
            left: 
              EXTRACT: "CA10Z1__name__c"
            right: 
              TEXT: "SqlServers"
      - status: "COMPLIANT"
        currentStateMessage: "This is a Standard tier."
        check:
          IS_EQUAL:
            left: 
              EXTRACT: "CA10Z1__pricingTier__c"
            right: 
              TEXT: "Standard"
      - status: "INCOMPLIANT"
        currentStateMessage: "This is a Free tier."
        remediationMessage: "Enable Defender for SQL Databases Standard plan."
        check:
          IS_EQUAL:
            left: 
              EXTRACT: "CA10Z1__pricingTier__c"
            right: 
              TEXT: "Free"
    otherwise: 
      status: "UNDETERMINED"
      currentStateMessage: "Unexpected values in the fields."