🧠 Azure Subscription Activity Log Alert for Delete SQL Server Firewall Rule does not exist - prod.logic.yaml 🟢

• Contextual name: 🧠 prod.logic.yaml 🟢
• ID: /ce/ca/azure/subscription/activity-log-alert-for-delete-sql-server-firewall-rule/prod.logic.yaml
• Located in: 📝 Azure Subscription Activity Log Alert for Delete SQL Server Firewall Rule does not exist 🟢

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 Activity Log Alert - object.extracts.yaml
• 🧪 test-data.json

Test Results 🟢

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

Result	Id	Condition Index	Condition Text	Runtime Error
🟢	test1	✔️ 200	✔️ otherwise	✔️ null
🟢	test2	✔️ 199	✔️ CA10__Azure_Activity_Log_Alerts__r.has(COMPLIANT)	✔️ null
🟢	test3	✔️ 200	✔️ otherwise	✔️ null
🟢	test4	✔️ 200	✔️ otherwise	✔️ null
🟢	test5	✔️ 200	✔️ otherwise	✔️ null
🟢	test6	✔️ 200	✔️ otherwise	✔️ null
🟢	test7	✔️ 200	✔️ otherwise	✔️ null
🟢	test8	✔️ 200	✔️ otherwise	✔️ null
🟢	test9	✔️ 200	✔️ otherwise	✔️ null
🟢	test10	✔️ 200	✔️ otherwise	✔️ null
🟢	test11	✔️ 200	✔️ otherwise	✔️ null
🟢	test12	✔️ 200	✔️ otherwise	✔️ null

Generation

	File	MD5
Open	/ce/ca/azure/subscription/activity-log-alert-for-delete-sql-server-firewall-rule/policy.yaml	959A540CCDA5D5AE1B994BDADBEA5A76
Open	/ce/ca/azure/subscription/activity-log-alert-for-delete-sql-server-firewall-rule/prod.logic.yaml	822AD69D943C12E953CF80D5FCC334AC
Open	/types/CA10__CaAzureActivityLogAlert__c/object.extracts.yaml	79B153D6511F943B6AB929697CE0452E
Open	/ce/ca/azure/subscription/activity-log-alert-for-delete-sql-server-firewall-rule/test-data.json	E207C9DF60A2C0E301CA4614810AB657

Generate FULL script

java -jar repo-manager.jar policies generate FULL /ce/ca/azure/subscription/activity-log-alert-for-delete-sql-server-firewall-rule/prod.logic.yaml

Generate DEBUG script

java -jar repo-manager.jar policies generate DEBUG /ce/ca/azure/subscription/activity-log-alert-for-delete-sql-server-firewall-rule/prod.logic.yaml

Generate CAPTURE_TEST_DATA script

java -jar repo-manager.jar policies generate CAPTURE_TEST_DATA /ce/ca/azure/subscription/activity-log-alert-for-delete-sql-server-firewall-rule/prod.logic.yaml

Generate TESTS script

java -jar repo-manager.jar policies generate TESTS /ce/ca/azure/subscription/activity-log-alert-for-delete-sql-server-firewall-rule/prod.logic.yaml

Execute tests

java -jar repo-manager.jar policies test /ce/ca/azure/subscription/activity-log-alert-for-delete-sql-server-firewall-rule/prod.logic.yaml

Content

Open File

---
inputType: "CA10__CaAzureAccount__c"
testData:
  - file: "test-data.json"
conditions:
  - status: "COMPLIANT"
    currentStateMessage: "This subscription has an Activity Log Alert for Delete SQL Server Firewall Rule."
    check:
      RELATED_LIST_HAS:
        status: "COMPLIANT"
        relationshipName: "CA10__Azure_Activity_Log_Alerts__r"
otherwise:
  status: "INCOMPLIANT"
  currentStateMessage: "This subscription doesn't have an Activity Log Alert for Delete SQL Server Firewall Rule."
  remediationMessage: "Consider creating an Activity Log Alert for Delete SQL Server Firewall Rule."
relatedLists:
  - relationshipName: "CA10__Azure_Activity_Log_Alerts__r"
    importExtracts:
      - file: "/types/CA10__CaAzureActivityLogAlert__c/object.extracts.yaml"
    conditions:
      - status: "INAPPLICABLE"
        currentStateMessage: "This is a disabled Activity Log Alert."
        check:
          NOT_EQUAL:
            left:
              EXTRACT: "CA10__enabledStatus__c"
            right:
              TEXT: "Enabled"
      - status: "COMPLIANT"
        currentStateMessage: "This is an Activity Log Alert for Delete SQL Server Firewall Rule."
        check:
          IS_EQUAL:
            left:
              JSON_QUERY_BOOLEAN:
                  arg: 
                    EXTRACT: "caJsonFrom__conditionJson__c"
                  expression: "contains(allOf[*].equals, 'Microsoft.Sql/servers/firewallRules/delete')"
                  undeterminedIf: 
                    evaluationError: "The JSON query has failed."
                    resultTypeMismatch: "The JSON query did not return boolean type."
            right:
              BOOLEAN: true
    otherwise:
      status: "INAPPLICABLE"
      currentStateMessage: "This is an unrelated Activity Log Alert."