--- policy: /ce/ca/azure/front-door/subscription-has-multiple-sparse-profiles logic: /ce/ca/azure/front-door/subscription-has-multiple-sparse-profiles/prod.logic.yaml executionTime: 2026-09-22T15:06:36.048951256Z generationMs: 119 executionMs: 1603 rows: - id: '001' match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: (CA10Z1__Azure_Front_Door_Profiles__r.hasNo(COMPLIANT) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(INCOMPLIANT)) || (CA10Z1__Azure_Front_Door_Profiles__r.count(COMPLIANT) == number(1.0) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(INCOMPLIANT)) || (CA10Z1__Azure_Front_Door_Profiles__r.count(INCOMPLIANT) == number(1.0) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(COMPLIANT)) actual: (CA10Z1__Azure_Front_Door_Profiles__r.hasNo(COMPLIANT) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(INCOMPLIANT)) || (CA10Z1__Azure_Front_Door_Profiles__r.count(COMPLIANT) == number(1.0) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(INCOMPLIANT)) || (CA10Z1__Azure_Front_Door_Profiles__r.count(INCOMPLIANT) == number(1.0) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(COMPLIANT)) runtimeError: {} - id: unknown match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 299 actual: 299 conditionText: expected: CA10Z1__Azure_Front_Door_Profiles__r.has(UNDETERMINED) actual: CA10Z1__Azure_Front_Door_Profiles__r.has(UNDETERMINED) runtimeError: {} - id: one match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: (CA10Z1__Azure_Front_Door_Profiles__r.hasNo(COMPLIANT) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(INCOMPLIANT)) || (CA10Z1__Azure_Front_Door_Profiles__r.count(COMPLIANT) == number(1.0) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(INCOMPLIANT)) || (CA10Z1__Azure_Front_Door_Profiles__r.count(INCOMPLIANT) == number(1.0) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(COMPLIANT)) actual: (CA10Z1__Azure_Front_Door_Profiles__r.hasNo(COMPLIANT) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(INCOMPLIANT)) || (CA10Z1__Azure_Front_Door_Profiles__r.count(COMPLIANT) == number(1.0) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(INCOMPLIANT)) || (CA10Z1__Azure_Front_Door_Profiles__r.count(INCOMPLIANT) == number(1.0) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(COMPLIANT)) runtimeError: {} - id: two-singletons match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 199 actual: 199 conditionText: expected: CA10Z1__Azure_Front_Door_Profiles__r.count(COMPLIANT) >= number(2.0) actual: CA10Z1__Azure_Front_Door_Profiles__r.count(COMPLIANT) >= number(2.0) runtimeError: {} - id: mixed match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 400 actual: 400 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: two-singletons-with-unknown match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 199 actual: 199 conditionText: expected: CA10Z1__Azure_Front_Door_Profiles__r.count(COMPLIANT) >= number(2.0) actual: CA10Z1__Azure_Front_Door_Profiles__r.count(COMPLIANT) >= number(2.0) runtimeError: {} usedFiles: - path: /ce/ca/azure/front-door/subscription-has-multiple-sparse-profiles/policy.yaml md5Hash: E2404F5D6E702A8903E16ED6E58E6366 content: | --- names: full: "Azure subscription has multiple sparse Front Door profiles" contextual: "Subscription has multiple sparse Front Door profiles" description: "Identify subscriptions with two or more provisioned Standard or Premium Front Door profiles that each contain one provisioned endpoint." categories: - "COST" type: "BEST_PRACTICE" frameworkMappings: - "/frameworks/cloudaware/cost-efficiency-and-optimization/resource-optimization" - path: /ce/ca/azure/front-door/subscription-has-multiple-sparse-profiles/prod.logic.yaml md5Hash: 9E5083CC6706B9A7D0688E24FF863903 content: | --- inputType: "CA10__CaAzureAccount__c" testData: - file: "test-data.json" conditions: - status: "INCOMPLIANT" currentStateMessage: "At least two eligible Front Door profiles each have exactly one successfully provisioned endpoint." remediationMessage: "Review the profiles to determine whether compatible workloads can be consolidated safely." check: GREATER_THAN_EQUAL: left: RELATED_LIST_COUNT: status: "COMPLIANT" relationshipName: "CA10Z1__Azure_Front_Door_Profiles__r" right: NUMBER: 2 - status: "UNDETERMINED" currentStateMessage: "Profile or endpoint data is incomplete, so the subscription cannot be evaluated." check: RELATED_LIST_HAS: status: "UNDETERMINED" relationshipName: "CA10Z1__Azure_Front_Door_Profiles__r" - status: "INAPPLICABLE" currentStateMessage: "The subscription has fewer than two eligible Standard or Premium Front Door profiles." check: OR: args: - AND: args: - RELATED_LIST_HAS_NO: status: "COMPLIANT" relationshipName: "CA10Z1__Azure_Front_Door_Profiles__r" - RELATED_LIST_HAS_NO: status: "INCOMPLIANT" relationshipName: "CA10Z1__Azure_Front_Door_Profiles__r" - AND: args: - IS_EQUAL: left: RELATED_LIST_COUNT: status: "COMPLIANT" relationshipName: "CA10Z1__Azure_Front_Door_Profiles__r" right: NUMBER: 1 - RELATED_LIST_HAS_NO: status: "INCOMPLIANT" relationshipName: "CA10Z1__Azure_Front_Door_Profiles__r" - AND: args: - IS_EQUAL: left: RELATED_LIST_COUNT: status: "INCOMPLIANT" relationshipName: "CA10Z1__Azure_Front_Door_Profiles__r" right: NUMBER: 1 - RELATED_LIST_HAS_NO: status: "COMPLIANT" relationshipName: "CA10Z1__Azure_Front_Door_Profiles__r" otherwise: status: "COMPLIANT" currentStateMessage: "Fewer than two eligible Front Door profiles have exactly one successfully provisioned endpoint." relatedLists: - relationshipName: "CA10Z1__Azure_Front_Door_Profiles__r" importExtracts: - file: "/types/CA10Z1__CaAzureFrontDoorProfile__c/object.extracts.yaml" conditions: - status: "INAPPLICABLE" currentStateMessage: "The profile is not a successfully provisioned Standard or Premium Front Door profile." check: OR: args: - NOT_EQUAL: left: EXTRACT: "CA10Z1__provisioningState__c" right: TEXT: "Succeeded" - NOT: arg: OR: args: - IS_EQUAL: left: EXTRACT: "CA10Z1__skuName__c" right: TEXT: "Standard_AzureFrontDoor" - IS_EQUAL: left: EXTRACT: "CA10Z1__skuName__c" right: TEXT: "Premium_AzureFrontDoor" - status: "UNDETERMINED" currentStateMessage: "Endpoint data is incomplete, so the profile cannot be evaluated." check: RELATED_LIST_HAS: status: "UNDETERMINED" relationshipName: "CA10Z1__Azure_Front_Door_Endpoints__r" - status: "COMPLIANT" currentStateMessage: "The profile has exactly one successfully provisioned endpoint." check: IS_EQUAL: left: RELATED_LIST_COUNT: status: "COMPLIANT" relationshipName: "CA10Z1__Azure_Front_Door_Endpoints__r" right: NUMBER: 1 otherwise: status: "INCOMPLIANT" currentStateMessage: "The profile does not have exactly one successfully provisioned endpoint." relatedLists: - relationshipName: "CA10Z1__Azure_Front_Door_Endpoints__r" importExtracts: - file: "/types/CA10Z1__CaAzureFrontDoorEndpoint__c/object.extracts.yaml" conditions: - status: "INAPPLICABLE" currentStateMessage: "The endpoint is not successfully provisioned." check: NOT_EQUAL: left: EXTRACT: "CA10Z1__provisioningState__c" right: TEXT: "Succeeded" otherwise: status: "COMPLIANT" currentStateMessage: "The endpoint is successfully provisioned." - path: /ce/ca/azure/front-door/subscription-has-multiple-sparse-profiles/test-data.json md5Hash: 98012F730F7FDA6D560B68D4D1035DF9 content: |- [ { "expectedResult": { "runtimeError": null, "conditionText": "(CA10Z1__Azure_Front_Door_Profiles__r.hasNo(COMPLIANT) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(INCOMPLIANT)) || (CA10Z1__Azure_Front_Door_Profiles__r.count(COMPLIANT) == number(1.0) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(INCOMPLIANT)) || (CA10Z1__Azure_Front_Door_Profiles__r.count(INCOMPLIANT) == number(1.0) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(COMPLIANT))", "conditionIndex": 399, "status": "INAPPLICABLE" }, "context": { "snapshotTime": "2026-09-10T13:03:37Z" }, "Id": "001", "CA10Z1__Azure_Front_Door_Profiles__r": [] }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "299", "conditionText": "CA10Z1__Azure_Front_Door_Profiles__r.has(UNDETERMINED)", "runtimeError": null }, "context": { "snapshotTime": "2026-09-10T13:03:37Z" }, "Id": "unknown", "CA10Z1__Azure_Front_Door_Profiles__r": [ { "Id": "profile-unknown", "RecordType": { "Id": "profile" }, "RecordTypeId": "profile", "CA10Z1__subscription__c": "unknown", "CA10Z1__disappearanceTime__c": null, "CA10Z1__provisioningState__c": "Succeeded", "CA10Z1__skuName__c": "", "CA10Z1__Azure_Front_Door_Endpoints__r": [] } ] }, { "expectedResult": { "status": "INAPPLICABLE", "conditionIndex": "399", "conditionText": "(CA10Z1__Azure_Front_Door_Profiles__r.hasNo(COMPLIANT) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(INCOMPLIANT)) || (CA10Z1__Azure_Front_Door_Profiles__r.count(COMPLIANT) == number(1.0) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(INCOMPLIANT)) || (CA10Z1__Azure_Front_Door_Profiles__r.count(INCOMPLIANT) == number(1.0) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(COMPLIANT))", "runtimeError": null }, "context": { "snapshotTime": "2026-09-10T13:03:37Z" }, "Id": "one", "CA10Z1__Azure_Front_Door_Profiles__r": [ { "Id": "profile-one", "RecordType": { "Id": "profile" }, "RecordTypeId": "profile", "CA10Z1__subscription__c": "one", "CA10Z1__disappearanceTime__c": null, "CA10Z1__provisioningState__c": "Succeeded", "CA10Z1__skuName__c": "Standard_AzureFrontDoor", "CA10Z1__Azure_Front_Door_Endpoints__r": [ { "Id": "endpoint-one", "RecordType": { "Id": "endpoint" }, "RecordTypeId": "endpoint", "CA10Z1__profile__c": "profile-one", "CA10Z1__disappearanceTime__c": null, "CA10Z1__provisioningState__c": "Succeeded" } ] } ] }, { "expectedResult": { "status": "INCOMPLIANT", "conditionIndex": "199", "conditionText": "CA10Z1__Azure_Front_Door_Profiles__r.count(COMPLIANT) >= number(2.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-09-10T13:03:37Z" }, "Id": "two-singletons", "CA10Z1__Azure_Front_Door_Profiles__r": [ { "Id": "profile-a", "RecordType": { "Id": "profile" }, "RecordTypeId": "profile", "CA10Z1__subscription__c": "two-singletons", "CA10Z1__disappearanceTime__c": null, "CA10Z1__provisioningState__c": "Succeeded", "CA10Z1__skuName__c": "Standard_AzureFrontDoor", "CA10Z1__Azure_Front_Door_Endpoints__r": [ { "Id": "endpoint-a", "RecordType": { "Id": "endpoint" }, "RecordTypeId": "endpoint", "CA10Z1__profile__c": "profile-a", "CA10Z1__disappearanceTime__c": null, "CA10Z1__provisioningState__c": "Succeeded" } ] }, { "Id": "profile-b", "RecordType": { "Id": "profile" }, "RecordTypeId": "profile", "CA10Z1__subscription__c": "two-singletons", "CA10Z1__disappearanceTime__c": null, "CA10Z1__provisioningState__c": "Succeeded", "CA10Z1__skuName__c": "Premium_AzureFrontDoor", "CA10Z1__Azure_Front_Door_Endpoints__r": [ { "Id": "endpoint-b", "RecordType": { "Id": "endpoint" }, "RecordTypeId": "endpoint", "CA10Z1__profile__c": "profile-b", "CA10Z1__disappearanceTime__c": null, "CA10Z1__provisioningState__c": "Succeeded" } ] } ] }, { "expectedResult": { "status": "COMPLIANT", "conditionIndex": "400", "conditionText": "otherwise", "runtimeError": null }, "context": { "snapshotTime": "2026-09-10T13:03:37Z" }, "Id": "mixed", "CA10Z1__Azure_Front_Door_Profiles__r": [ { "Id": "profile-c", "RecordType": { "Id": "profile" }, "RecordTypeId": "profile", "CA10Z1__subscription__c": "mixed", "CA10Z1__disappearanceTime__c": null, "CA10Z1__provisioningState__c": "Succeeded", "CA10Z1__skuName__c": "Standard_AzureFrontDoor", "CA10Z1__Azure_Front_Door_Endpoints__r": [ { "Id": "endpoint-c", "RecordType": { "Id": "endpoint" }, "RecordTypeId": "endpoint", "CA10Z1__profile__c": "profile-c", "CA10Z1__disappearanceTime__c": null, "CA10Z1__provisioningState__c": "Succeeded" } ] }, { "Id": "profile-d", "RecordType": { "Id": "profile" }, "RecordTypeId": "profile", "CA10Z1__subscription__c": "mixed", "CA10Z1__disappearanceTime__c": null, "CA10Z1__provisioningState__c": "Succeeded", "CA10Z1__skuName__c": "Premium_AzureFrontDoor", "CA10Z1__Azure_Front_Door_Endpoints__r": [ { "Id": "endpoint-d1", "RecordType": { "Id": "endpoint" }, "RecordTypeId": "endpoint", "CA10Z1__profile__c": "profile-d", "CA10Z1__disappearanceTime__c": null, "CA10Z1__provisioningState__c": "Succeeded" }, { "Id": "endpoint-d2", "RecordType": { "Id": "endpoint" }, "RecordTypeId": "endpoint", "CA10Z1__profile__c": "profile-d", "CA10Z1__disappearanceTime__c": null, "CA10Z1__provisioningState__c": "Succeeded" } ] } ] }, { "expectedResult": { "status": "INCOMPLIANT", "conditionIndex": "199", "conditionText": "CA10Z1__Azure_Front_Door_Profiles__r.count(COMPLIANT) >= number(2.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-09-10T13:03:37Z" }, "Id": "two-singletons-with-unknown", "CA10Z1__Azure_Front_Door_Profiles__r": [ { "Id": "profile-e", "RecordType": { "Id": "profile" }, "RecordTypeId": "profile", "CA10Z1__subscription__c": "two-singletons-with-unknown", "CA10Z1__disappearanceTime__c": null, "CA10Z1__provisioningState__c": "Succeeded", "CA10Z1__skuName__c": "Standard_AzureFrontDoor", "CA10Z1__Azure_Front_Door_Endpoints__r": [ { "Id": "endpoint-e", "RecordType": { "Id": "endpoint" }, "RecordTypeId": "endpoint", "CA10Z1__profile__c": "profile-e", "CA10Z1__disappearanceTime__c": null, "CA10Z1__provisioningState__c": "Succeeded" } ] }, { "Id": "profile-f", "RecordType": { "Id": "profile" }, "RecordTypeId": "profile", "CA10Z1__subscription__c": "two-singletons-with-unknown", "CA10Z1__disappearanceTime__c": null, "CA10Z1__provisioningState__c": "Succeeded", "CA10Z1__skuName__c": "Premium_AzureFrontDoor", "CA10Z1__Azure_Front_Door_Endpoints__r": [ { "Id": "endpoint-f", "RecordType": { "Id": "endpoint" }, "RecordTypeId": "endpoint", "CA10Z1__profile__c": "profile-f", "CA10Z1__disappearanceTime__c": null, "CA10Z1__provisioningState__c": "Succeeded" } ] }, { "Id": "profile-g", "RecordType": { "Id": "profile" }, "RecordTypeId": "profile", "CA10Z1__subscription__c": "two-singletons-with-unknown", "CA10Z1__disappearanceTime__c": null, "CA10Z1__provisioningState__c": "Succeeded", "CA10Z1__skuName__c": "", "CA10Z1__Azure_Front_Door_Endpoints__r": [] } ] } ] - path: /types/CA10Z1__CaAzureFrontDoorProfile__c/object.extracts.yaml md5Hash: FC434AB22B268CA6B9356BB96D235ED7 content: | --- extracts: - name: "CA10Z1__provisioningState__c" value: FIELD: path: "CA10Z1__provisioningState__c" undeterminedIf: {isEmpty: "The Front Door profile provisioning state is unavailable."} - name: "CA10Z1__skuName__c" value: FIELD: path: "CA10Z1__skuName__c" undeterminedIf: {isEmpty: "The Front Door profile SKU is unavailable."} script: |- CREATE TEMP FUNCTION mock_ExpectedResult() RETURNS ARRAY >> DETERMINISTIC LANGUAGE js AS r""" return [ { "Id" : "001", "expectedResult" : { "runtimeError" : null, "conditionText" : "(CA10Z1__Azure_Front_Door_Profiles__r.hasNo(COMPLIANT) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(INCOMPLIANT)) || (CA10Z1__Azure_Front_Door_Profiles__r.count(COMPLIANT) == number(1.0) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(INCOMPLIANT)) || (CA10Z1__Azure_Front_Door_Profiles__r.count(INCOMPLIANT) == number(1.0) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(COMPLIANT))", "conditionIndex" : 399, "status" : "INAPPLICABLE" } }, { "Id" : "unknown", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "299", "conditionText" : "CA10Z1__Azure_Front_Door_Profiles__r.has(UNDETERMINED)", "runtimeError" : null } }, { "Id" : "one", "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : "399", "conditionText" : "(CA10Z1__Azure_Front_Door_Profiles__r.hasNo(COMPLIANT) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(INCOMPLIANT)) || (CA10Z1__Azure_Front_Door_Profiles__r.count(COMPLIANT) == number(1.0) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(INCOMPLIANT)) || (CA10Z1__Azure_Front_Door_Profiles__r.count(INCOMPLIANT) == number(1.0) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(COMPLIANT))", "runtimeError" : null } }, { "Id" : "two-singletons", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : "199", "conditionText" : "CA10Z1__Azure_Front_Door_Profiles__r.count(COMPLIANT) >= number(2.0)", "runtimeError" : null } }, { "Id" : "mixed", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : "400", "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "two-singletons-with-unknown", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : "199", "conditionText" : "CA10Z1__Azure_Front_Door_Profiles__r.count(COMPLIANT) >= number(2.0)", "runtimeError" : null } } ]; """; CREATE TEMP FUNCTION mock_CA10Z1__CaAzureFrontDoorProfile__c() RETURNS ARRAY >> DETERMINISTIC LANGUAGE js AS r""" return [ { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "CA10Z1__provisioningState__c" : "Succeeded", "CA10Z1__skuName__c" : "", "CA10Z1__subscription__c" : "unknown", "Id" : "profile-unknown" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "CA10Z1__provisioningState__c" : "Succeeded", "CA10Z1__skuName__c" : "Standard_AzureFrontDoor", "CA10Z1__subscription__c" : "one", "Id" : "profile-one" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "CA10Z1__provisioningState__c" : "Succeeded", "CA10Z1__skuName__c" : "Standard_AzureFrontDoor", "CA10Z1__subscription__c" : "two-singletons", "Id" : "profile-a" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "CA10Z1__provisioningState__c" : "Succeeded", "CA10Z1__skuName__c" : "Premium_AzureFrontDoor", "CA10Z1__subscription__c" : "two-singletons", "Id" : "profile-b" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "CA10Z1__provisioningState__c" : "Succeeded", "CA10Z1__skuName__c" : "Standard_AzureFrontDoor", "CA10Z1__subscription__c" : "mixed", "Id" : "profile-c" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "CA10Z1__provisioningState__c" : "Succeeded", "CA10Z1__skuName__c" : "Premium_AzureFrontDoor", "CA10Z1__subscription__c" : "mixed", "Id" : "profile-d" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "CA10Z1__provisioningState__c" : "Succeeded", "CA10Z1__skuName__c" : "Standard_AzureFrontDoor", "CA10Z1__subscription__c" : "two-singletons-with-unknown", "Id" : "profile-e" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "CA10Z1__provisioningState__c" : "Succeeded", "CA10Z1__skuName__c" : "Premium_AzureFrontDoor", "CA10Z1__subscription__c" : "two-singletons-with-unknown", "Id" : "profile-f" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "CA10Z1__provisioningState__c" : "Succeeded", "CA10Z1__skuName__c" : "", "CA10Z1__subscription__c" : "two-singletons-with-unknown", "Id" : "profile-g" } ]; """; CREATE TEMP FUNCTION mock_CA10Z1__CaAzureFrontDoorEndpoint__c() RETURNS ARRAY >> DETERMINISTIC LANGUAGE js AS r""" return [ { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "CA10Z1__provisioningState__c" : "Succeeded", "CA10Z1__profile__c" : "profile-one", "Id" : "endpoint-one" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "CA10Z1__provisioningState__c" : "Succeeded", "CA10Z1__profile__c" : "profile-a", "Id" : "endpoint-a" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "CA10Z1__provisioningState__c" : "Succeeded", "CA10Z1__profile__c" : "profile-b", "Id" : "endpoint-b" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "CA10Z1__provisioningState__c" : "Succeeded", "CA10Z1__profile__c" : "profile-c", "Id" : "endpoint-c" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "CA10Z1__provisioningState__c" : "Succeeded", "CA10Z1__profile__c" : "profile-d", "Id" : "endpoint-d1" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "CA10Z1__provisioningState__c" : "Succeeded", "CA10Z1__profile__c" : "profile-d", "Id" : "endpoint-d2" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "CA10Z1__provisioningState__c" : "Succeeded", "CA10Z1__profile__c" : "profile-e", "Id" : "endpoint-e" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "CA10Z1__provisioningState__c" : "Succeeded", "CA10Z1__profile__c" : "profile-f", "Id" : "endpoint-f" } ]; """; CREATE TEMP FUNCTION mock_CA10__CaAzureAccount__c() RETURNS ARRAY >> DETERMINISTIC LANGUAGE js AS r""" return [ { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "Id" : "001" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "Id" : "unknown" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "Id" : "one" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "Id" : "two-singletons" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "Id" : "mixed" }, { "context" : { "snapshotTime" : new Date("2026-09-10T13:03:37Z") }, "Id" : "two-singletons-with-unknown" } ]; """; CREATE TEMP FUNCTION process_CA10__CaAzureAccount__c( obj STRUCT< CA10Z1__Azure_Front_Door_Profiles__r ARRAY >>, CA10Z1__subscription__c STRING, Id STRING, result STRUCT >>, Id STRING >, snapshotTime TIMESTAMP ) RETURNS STRUCT DETERMINISTIC LANGUAGE js AS r""" var references1 = []; // condition[0], conditionIndex:[0..99] if (false) { return {status: 'DISAPPEARED', conditionIndex: 99, conditionText: "isDisappeared()", currentStateMessage: "Object is deleted in the source", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } var count_CA10Z1__Azure_Front_Door_Profiles__r_COMPLIANT3 = 0; if (obj.CA10Z1__Azure_Front_Door_Profiles__r != null) { for (var i4 = 0; i4 < obj.CA10Z1__Azure_Front_Door_Profiles__r.length; i4++) { if (typeof(obj.CA10Z1__Azure_Front_Door_Profiles__r[i4].status) !== 'undefined') { if (obj.CA10Z1__Azure_Front_Door_Profiles__r[i4].status == 'COMPLIANT') { count_CA10Z1__Azure_Front_Door_Profiles__r_COMPLIANT3 += obj.CA10Z1__Azure_Front_Door_Profiles__r[i4].count; } } else { if (obj.CA10Z1__Azure_Front_Door_Profiles__r[i4].result.status == 'COMPLIANT') { count_CA10Z1__Azure_Front_Door_Profiles__r_COMPLIANT3 += 1; } } } } // condition[1], conditionIndex:[100..199] references1.push('Related list [CA10Z1__Azure_Front_Door_Profiles__r] has ' + count_CA10Z1__Azure_Front_Door_Profiles__r_COMPLIANT3 + ' objects in COMPLIANT status'); if (count_CA10Z1__Azure_Front_Door_Profiles__r_COMPLIANT3 != null && 2.0 != null && count_CA10Z1__Azure_Front_Door_Profiles__r_COMPLIANT3 >= 2.0) { return {status: 'INCOMPLIANT', conditionIndex: 199, conditionText: "CA10Z1__Azure_Front_Door_Profiles__r.count(COMPLIANT) >= number(2.0)", currentStateMessage: "At least two eligible Front Door profiles each have exactly one successfully provisioned endpoint.", currentStateReferences: references1.join('\n'), remediation: "Review the profiles to determine whether compatible workloads can be consolidated safely.", runtimeError: null}; } var count_CA10Z1__Azure_Front_Door_Profiles__r_UNDETERMINED5 = 0; if (obj.CA10Z1__Azure_Front_Door_Profiles__r != null) { for (var i6 = 0; i6 < obj.CA10Z1__Azure_Front_Door_Profiles__r.length; i6++) { if (typeof(obj.CA10Z1__Azure_Front_Door_Profiles__r[i6].status) !== 'undefined') { if (obj.CA10Z1__Azure_Front_Door_Profiles__r[i6].status == 'UNDETERMINED') { count_CA10Z1__Azure_Front_Door_Profiles__r_UNDETERMINED5 += obj.CA10Z1__Azure_Front_Door_Profiles__r[i6].count; } } else { if (obj.CA10Z1__Azure_Front_Door_Profiles__r[i6].result.status == 'UNDETERMINED') { count_CA10Z1__Azure_Front_Door_Profiles__r_UNDETERMINED5 += 1; } } } } // condition[2], conditionIndex:[200..299] if (count_CA10Z1__Azure_Front_Door_Profiles__r_UNDETERMINED5 > 0) { return {status: 'UNDETERMINED', conditionIndex: 299, conditionText: "CA10Z1__Azure_Front_Door_Profiles__r.has(UNDETERMINED)", currentStateMessage: "Profile or endpoint data is incomplete, so the subscription cannot be evaluated.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } var count_CA10Z1__Azure_Front_Door_Profiles__r_COMPLIANT3 = 0; var count_CA10Z1__Azure_Front_Door_Profiles__r_INCOMPLIANT7 = 0; if (obj.CA10Z1__Azure_Front_Door_Profiles__r != null) { for (var i8 = 0; i8 < obj.CA10Z1__Azure_Front_Door_Profiles__r.length; i8++) { if (typeof(obj.CA10Z1__Azure_Front_Door_Profiles__r[i8].status) !== 'undefined') { if (obj.CA10Z1__Azure_Front_Door_Profiles__r[i8].status == 'COMPLIANT') { count_CA10Z1__Azure_Front_Door_Profiles__r_COMPLIANT3 += obj.CA10Z1__Azure_Front_Door_Profiles__r[i8].count; } } else { if (obj.CA10Z1__Azure_Front_Door_Profiles__r[i8].result.status == 'COMPLIANT') { count_CA10Z1__Azure_Front_Door_Profiles__r_COMPLIANT3 += 1; } } if (typeof(obj.CA10Z1__Azure_Front_Door_Profiles__r[i8].status) !== 'undefined') { if (obj.CA10Z1__Azure_Front_Door_Profiles__r[i8].status == 'INCOMPLIANT') { count_CA10Z1__Azure_Front_Door_Profiles__r_INCOMPLIANT7 += obj.CA10Z1__Azure_Front_Door_Profiles__r[i8].count; } } else { if (obj.CA10Z1__Azure_Front_Door_Profiles__r[i8].result.status == 'INCOMPLIANT') { count_CA10Z1__Azure_Front_Door_Profiles__r_INCOMPLIANT7 += 1; } } } } // condition[3], conditionIndex:[300..399] if ((count_CA10Z1__Azure_Front_Door_Profiles__r_COMPLIANT3 == 0 && count_CA10Z1__Azure_Front_Door_Profiles__r_INCOMPLIANT7 == 0) || (count_CA10Z1__Azure_Front_Door_Profiles__r_COMPLIANT3 == 1.0 && count_CA10Z1__Azure_Front_Door_Profiles__r_INCOMPLIANT7 == 0) || (count_CA10Z1__Azure_Front_Door_Profiles__r_INCOMPLIANT7 == 1.0 && count_CA10Z1__Azure_Front_Door_Profiles__r_COMPLIANT3 == 0)) { return {status: 'INAPPLICABLE', conditionIndex: 399, conditionText: "(CA10Z1__Azure_Front_Door_Profiles__r.hasNo(COMPLIANT) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(INCOMPLIANT)) || (CA10Z1__Azure_Front_Door_Profiles__r.count(COMPLIANT) == number(1.0) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(INCOMPLIANT)) || (CA10Z1__Azure_Front_Door_Profiles__r.count(INCOMPLIANT) == number(1.0) && CA10Z1__Azure_Front_Door_Profiles__r.hasNo(COMPLIANT))", currentStateMessage: "The subscription has fewer than two eligible Standard or Premium Front Door profiles.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } return {status: 'COMPLIANT', conditionIndex: 400, conditionText: "otherwise", currentStateMessage: "Fewer than two eligible Front Door profiles have exactly one successfully provisioned endpoint.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; """; CREATE TEMP FUNCTION process_CA10Z1__Azure_Front_Door_Profiles__r_CA10Z1__Azure_Front_Door_Endpoints__r( obj STRUCT< CA10Z1__disappearanceTime__c TIMESTAMP, CA10Z1__provisioningState__c STRING, CA10Z1__profile__c STRING, Id STRING >, snapshotTime TIMESTAMP ) RETURNS STRUCT DETERMINISTIC LANGUAGE js AS r""" var TextLib = new function () { this.normalize = function(arg) { return arg == null ? '' : arg.replace(/\s+/g, ' ').trim().toLowerCase(); }; this.isEmpty = function(arg) { return this.normalize(arg) == ''; }; this.isNotEmpty = function(arg) { return this.normalize(arg) != ''; }; this.equal = function(left, right) { return this.normalize(left) == this.normalize(right); }; this.notEqual = function(left, right) { return this.normalize(left) != this.normalize(right); }; this.startsWith = function(arg, substring) { return this.normalize(arg).startsWith(this.normalize(substring)); }; this.endsWith = function(arg, substring) { return this.normalize(arg).endsWith(this.normalize(substring)); }; this.contains = function(arg, substring) { return this.normalize(arg).includes(this.normalize(substring)); }; this.containsAll = function(arg, substrings) { if (substrings == null || substrings.length === 0) return false; let normalizedArg = this.normalize(arg); return substrings.every(sub => normalizedArg.includes(this.normalize(sub))); }; this.containsAny = function(arg, substrings) { if (substrings == null || substrings.length === 0) return false; let normalizedArg = this.normalize(arg); return substrings.some(sub => normalizedArg.includes(this.normalize(sub))); }; }(); var references1 = []; // condition[0], conditionIndex:[0..99] references1.push('Deleted From Azure [CA10Z1__disappearanceTime__c]: ' + obj.CA10Z1__disappearanceTime__c); if (obj.CA10Z1__disappearanceTime__c != null) { return {status: 'DISAPPEARED', conditionIndex: 99, conditionText: "isDisappeared(CA10Z1__disappearanceTime__c)", currentStateMessage: "Object is deleted in the source", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } // condition[1], conditionIndex:[100..199] function fieldChecked4() { if (TextLib.isEmpty(obj.CA10Z1__provisioningState__c)) { throw new Error("UNDETERMINED condition:101", {cause: {status: 'UNDETERMINED', conditionIndex: 101, conditionText: "CA10Z1__provisioningState__c.isEmpty()", currentStateMessage: "The Front Door profile provisioning state is unavailable.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10Z1__provisioningState__c; } function extract3() { if (!this.out) { this.out = fieldChecked4(); } return this.out; }; references1.push('Provisioning State [obj.CA10Z1__provisioningState__c]: ' + obj.CA10Z1__provisioningState__c); try { if (TextLib.notEqual(extract3.call(extract3), 'Succeeded')) { return {status: 'INAPPLICABLE', conditionIndex: 199, conditionText: "extract('CA10Z1__provisioningState__c') != 'Succeeded'", currentStateMessage: "The endpoint is not successfully provisioned.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } return {status: 'COMPLIANT', conditionIndex: 200, conditionText: "otherwise", currentStateMessage: "The endpoint is successfully provisioned.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; """; CREATE TEMP FUNCTION process_CA10Z1__Azure_Front_Door_Profiles__r( obj STRUCT< CA10Z1__disappearanceTime__c TIMESTAMP, CA10Z1__provisioningState__c STRING, CA10Z1__skuName__c STRING, CA10Z1__Azure_Front_Door_Endpoints__r ARRAY >>, CA10Z1__subscription__c STRING, Id STRING >, snapshotTime TIMESTAMP ) RETURNS STRUCT DETERMINISTIC LANGUAGE js AS r""" var TextLib = new function () { this.normalize = function(arg) { return arg == null ? '' : arg.replace(/\s+/g, ' ').trim().toLowerCase(); }; this.isEmpty = function(arg) { return this.normalize(arg) == ''; }; this.isNotEmpty = function(arg) { return this.normalize(arg) != ''; }; this.equal = function(left, right) { return this.normalize(left) == this.normalize(right); }; this.notEqual = function(left, right) { return this.normalize(left) != this.normalize(right); }; this.startsWith = function(arg, substring) { return this.normalize(arg).startsWith(this.normalize(substring)); }; this.endsWith = function(arg, substring) { return this.normalize(arg).endsWith(this.normalize(substring)); }; this.contains = function(arg, substring) { return this.normalize(arg).includes(this.normalize(substring)); }; this.containsAll = function(arg, substrings) { if (substrings == null || substrings.length === 0) return false; let normalizedArg = this.normalize(arg); return substrings.every(sub => normalizedArg.includes(this.normalize(sub))); }; this.containsAny = function(arg, substrings) { if (substrings == null || substrings.length === 0) return false; let normalizedArg = this.normalize(arg); return substrings.some(sub => normalizedArg.includes(this.normalize(sub))); }; }(); var references1 = []; // condition[0], conditionIndex:[0..99] references1.push('Deleted From Azure [CA10Z1__disappearanceTime__c]: ' + obj.CA10Z1__disappearanceTime__c); if (obj.CA10Z1__disappearanceTime__c != null) { return {status: 'DISAPPEARED', conditionIndex: 99, conditionText: "isDisappeared(CA10Z1__disappearanceTime__c)", currentStateMessage: "Object is deleted in the source", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } // condition[1], conditionIndex:[100..199] function fieldChecked4() { if (TextLib.isEmpty(obj.CA10Z1__provisioningState__c)) { throw new Error("UNDETERMINED condition:101", {cause: {status: 'UNDETERMINED', conditionIndex: 101, conditionText: "CA10Z1__provisioningState__c.isEmpty()", currentStateMessage: "The Front Door profile provisioning state is unavailable.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10Z1__provisioningState__c; } function extract3() { if (!this.out) { this.out = fieldChecked4(); } return this.out; }; function fieldChecked7() { if (TextLib.isEmpty(obj.CA10Z1__skuName__c)) { throw new Error("UNDETERMINED condition:102", {cause: {status: 'UNDETERMINED', conditionIndex: 102, conditionText: "CA10Z1__skuName__c.isEmpty()", currentStateMessage: "The Front Door profile SKU is unavailable.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10Z1__skuName__c; } function extract6() { if (!this.out) { this.out = fieldChecked7(); } return this.out; }; references1.push('Provisioning State [obj.CA10Z1__provisioningState__c]: ' + obj.CA10Z1__provisioningState__c); references1.push('SKU: Name [obj.CA10Z1__skuName__c]: ' + obj.CA10Z1__skuName__c); try { if (TextLib.notEqual(extract3.call(extract3), 'Succeeded') || !(TextLib.equal(extract6.call(extract6), 'Standard_AzureFrontDoor') || TextLib.equal(extract6.call(extract6), 'Premium_AzureFrontDoor'))) { return {status: 'INAPPLICABLE', conditionIndex: 199, conditionText: "extract('CA10Z1__provisioningState__c') != 'Succeeded' || not(extract('CA10Z1__skuName__c') == 'Standard_AzureFrontDoor' || extract('CA10Z1__skuName__c') == 'Premium_AzureFrontDoor')", currentStateMessage: "The profile is not a successfully provisioned Standard or Premium Front Door profile.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } var count_CA10Z1__Azure_Front_Door_Endpoints__r_UNDETERMINED9 = 0; if (obj.CA10Z1__Azure_Front_Door_Endpoints__r != null) { for (var i10 = 0; i10 < obj.CA10Z1__Azure_Front_Door_Endpoints__r.length; i10++) { if (typeof(obj.CA10Z1__Azure_Front_Door_Endpoints__r[i10].status) !== 'undefined') { if (obj.CA10Z1__Azure_Front_Door_Endpoints__r[i10].status == 'UNDETERMINED') { count_CA10Z1__Azure_Front_Door_Endpoints__r_UNDETERMINED9 += obj.CA10Z1__Azure_Front_Door_Endpoints__r[i10].count; } } else { if (obj.CA10Z1__Azure_Front_Door_Endpoints__r[i10].result.status == 'UNDETERMINED') { count_CA10Z1__Azure_Front_Door_Endpoints__r_UNDETERMINED9 += 1; } } } } // condition[2], conditionIndex:[200..299] references1.push('Related list [CA10Z1__Azure_Front_Door_Endpoints__r] ' + (count_CA10Z1__Azure_Front_Door_Endpoints__r_UNDETERMINED9 > 0 ? 'has' : 'does not have') + ' objects in UNDETERMINED status'); if (count_CA10Z1__Azure_Front_Door_Endpoints__r_UNDETERMINED9 > 0) { return {status: 'UNDETERMINED', conditionIndex: 299, conditionText: "CA10Z1__Azure_Front_Door_Endpoints__r.has(UNDETERMINED)", currentStateMessage: "Endpoint data is incomplete, so the profile cannot be evaluated.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } var count_CA10Z1__Azure_Front_Door_Endpoints__r_COMPLIANT11 = 0; if (obj.CA10Z1__Azure_Front_Door_Endpoints__r != null) { for (var i12 = 0; i12 < obj.CA10Z1__Azure_Front_Door_Endpoints__r.length; i12++) { if (typeof(obj.CA10Z1__Azure_Front_Door_Endpoints__r[i12].status) !== 'undefined') { if (obj.CA10Z1__Azure_Front_Door_Endpoints__r[i12].status == 'COMPLIANT') { count_CA10Z1__Azure_Front_Door_Endpoints__r_COMPLIANT11 += obj.CA10Z1__Azure_Front_Door_Endpoints__r[i12].count; } } else { if (obj.CA10Z1__Azure_Front_Door_Endpoints__r[i12].result.status == 'COMPLIANT') { count_CA10Z1__Azure_Front_Door_Endpoints__r_COMPLIANT11 += 1; } } } } // condition[3], conditionIndex:[300..399] if (count_CA10Z1__Azure_Front_Door_Endpoints__r_COMPLIANT11 == 1.0) { return {status: 'COMPLIANT', conditionIndex: 399, conditionText: "CA10Z1__Azure_Front_Door_Endpoints__r.count(COMPLIANT) == number(1.0)", currentStateMessage: "The profile has exactly one successfully provisioned endpoint.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } return {status: 'INCOMPLIANT', conditionIndex: 400, conditionText: "otherwise", currentStateMessage: "The profile does not have exactly one successfully provisioned endpoint.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; """; SELECT expectedResult.Id as Id, IF ( IFNULL(expectedResult.expectedResult.status, '') = IFNULL(sObject.result.status, '') AND IFNULL(expectedResult.expectedResult.conditionIndex, -1) = IFNULL(sObject.result.conditionIndex, -1) AND IFNULL(expectedResult.expectedResult.conditionText, '') = IFNULL(sObject.result.conditionText, '') AND IFNULL(expectedResult.expectedResult.runtimeError, '') = IFNULL(sObject.result.runtimeError, ''), "MATCH", "FAIL" ) as match, expectedResult.expectedResult.status as expectedStatus, sObject.result.status as actualStatus, expectedResult.expectedResult.conditionIndex as expectedConditionIndex, sObject.result.conditionIndex as actualConditionIndex, expectedResult.expectedResult.conditionText as expectedConditionText, sObject.result.conditionText as actualConditionText, expectedResult.expectedResult.runtimeError as expectedRuntimeError, sObject.result.runtimeError as actualRuntimeError FROM UNNEST(mock_ExpectedResult()) expectedResult LEFT JOIN ( SELECT `CA10Z1__Azure_Front_Door_Profiles__r`.arr AS CA10Z1__Azure_Front_Door_Profiles__r, sObject.Id AS Id, process_CA10__CaAzureAccount__c( STRUCT( `CA10Z1__Azure_Front_Door_Profiles__r`.arr AS CA10Z1__Azure_Front_Door_Profiles__r, sObject.Id AS Id ), sObject.context.snapshotTime ) as result FROM UNNEST(mock_CA10__CaAzureAccount__c()) AS sObject LEFT JOIN ( SELECT sObject.CA10Z1__subscription__c, ARRAY_AGG( STRUCT( sObject.CA10Z1__disappearanceTime__c AS CA10Z1__disappearanceTime__c, sObject.CA10Z1__provisioningState__c AS CA10Z1__provisioningState__c, sObject.CA10Z1__skuName__c AS CA10Z1__skuName__c, `CA10Z1__Azure_Front_Door_Endpoints__r`.arr AS CA10Z1__Azure_Front_Door_Endpoints__r, sObject.CA10Z1__subscription__c AS CA10Z1__subscription__c, sObject.Id AS Id, process_CA10Z1__Azure_Front_Door_Profiles__r( STRUCT( sObject.CA10Z1__disappearanceTime__c AS CA10Z1__disappearanceTime__c, sObject.CA10Z1__provisioningState__c AS CA10Z1__provisioningState__c, sObject.CA10Z1__skuName__c AS CA10Z1__skuName__c, `CA10Z1__Azure_Front_Door_Endpoints__r`.arr AS CA10Z1__Azure_Front_Door_Endpoints__r, sObject.CA10Z1__subscription__c AS CA10Z1__subscription__c, sObject.Id AS Id ), sObject.context.snapshotTime ) as result ) ) AS arr FROM UNNEST(mock_CA10Z1__CaAzureFrontDoorProfile__c()) AS sObject LEFT JOIN ( SELECT sObject.CA10Z1__profile__c, ARRAY_AGG( STRUCT( sObject.CA10Z1__disappearanceTime__c AS CA10Z1__disappearanceTime__c, sObject.CA10Z1__provisioningState__c AS CA10Z1__provisioningState__c, sObject.CA10Z1__profile__c AS CA10Z1__profile__c, sObject.Id AS Id, process_CA10Z1__Azure_Front_Door_Profiles__r_CA10Z1__Azure_Front_Door_Endpoints__r( STRUCT( sObject.CA10Z1__disappearanceTime__c AS CA10Z1__disappearanceTime__c, sObject.CA10Z1__provisioningState__c AS CA10Z1__provisioningState__c, sObject.CA10Z1__profile__c AS CA10Z1__profile__c, sObject.Id AS Id ), sObject.context.snapshotTime ) as result ) ) AS arr FROM UNNEST(mock_CA10Z1__CaAzureFrontDoorEndpoint__c()) AS sObject GROUP BY sObject.CA10Z1__profile__c ) AS `CA10Z1__Azure_Front_Door_Endpoints__r` ON sObject.Id = `CA10Z1__Azure_Front_Door_Endpoints__r`.CA10Z1__profile__c GROUP BY sObject.CA10Z1__subscription__c ) AS `CA10Z1__Azure_Front_Door_Profiles__r` ON sObject.Id = `CA10Z1__Azure_Front_Door_Profiles__r`.CA10Z1__subscription__c ) sObject ON sObject.Id = expectedResult.Id;