--- policy: /ce/ca/aws/ec2/instance-deprecated-image logic: /ce/ca/aws/ec2/instance-deprecated-image/prod.logic.yaml executionTime: 2026-10-30T18:09:21.448829029Z generationMs: 82 executionMs: 982 rows: - id: past-running match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() actual: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() runtimeError: {} - id: past-stopped match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() actual: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() runtimeError: {} - id: past-stopping match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() actual: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() runtimeError: {} - id: past-pending match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() actual: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() runtimeError: {} - id: future match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 699 actual: 699 conditionText: expected: extract('CA10__image__r.CA10__deprecationTime__c').afterToday() actual: extract('CA10__image__r.CA10__deprecationTime__c').afterToday() runtimeError: {} - id: no-deprecation-date match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 599 actual: 599 conditionText: expected: extract('CA10__image__r.CA10__deprecationTime__c').isEmpty() actual: extract('CA10__image__r.CA10__deprecationTime__c').isEmpty() runtimeError: {} - id: today-midnight match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 700 actual: 700 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: today-before-snapshot match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 700 actual: 700 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: today-after-snapshot match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 700 actual: 700 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: next-utc-day-expired match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() actual: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() runtimeError: {} - id: prior-utc-day-future match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 699 actual: 699 conditionText: expected: extract('CA10__image__r.CA10__deprecationTime__c').afterToday() actual: extract('CA10__image__r.CA10__deprecationTime__c').afterToday() runtimeError: {} - id: terminated match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 199 actual: 199 conditionText: expected: "setOfText(['terminated', 'shutting-down']).contains(extract('CA10__stateName__c'))" actual: "setOfText(['terminated', 'shutting-down']).contains(extract('CA10__stateName__c'))" runtimeError: {} - id: shutting-down match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 199 actual: 199 conditionText: expected: "setOfText(['terminated', 'shutting-down']).contains(extract('CA10__stateName__c'))" actual: "setOfText(['terminated', 'shutting-down']).contains(extract('CA10__stateName__c'))" runtimeError: {} - id: unknown-state match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() actual: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() runtimeError: {} - id: missing-state match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 101 actual: 101 conditionText: expected: CA10__stateName__c.isEmpty() actual: CA10__stateName__c.isEmpty() runtimeError: {} - id: blank-state match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 101 actual: 101 conditionText: expected: CA10__stateName__c.isEmpty() actual: CA10__stateName__c.isEmpty() runtimeError: {} - id: missing-image-lookup match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 299 actual: 299 conditionText: expected: isEmptyLookup('CA10__image__r') actual: isEmptyLookup('CA10__image__r') runtimeError: {} - id: unresolved-image-lookup match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 304 actual: 304 conditionText: expected: CA10__state__c.isEmpty() actual: CA10__state__c.isEmpty() runtimeError: {} - id: disappeared-image-no-date match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 299 actual: 299 conditionText: expected: isEmptyLookup('CA10__image__r') actual: isEmptyLookup('CA10__image__r') runtimeError: {} - id: disappeared-image-past-date match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 299 actual: 299 conditionText: expected: isEmptyLookup('CA10__image__r') actual: isEmptyLookup('CA10__image__r') runtimeError: {} - id: missing-image-state match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 304 actual: 304 conditionText: expected: CA10__state__c.isEmpty() actual: CA10__state__c.isEmpty() runtimeError: {} - id: deregistered-image match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__image__r.CA10__state__c') != 'available' actual: extract('CA10__image__r.CA10__state__c') != 'available' runtimeError: {} - id: disappeared-instance match: true status: expected: DISAPPEARED actual: DISAPPEARED conditionIndex: expected: 99 actual: 99 conditionText: expected: isDisappeared(CA10__disappearanceTime__c) actual: isDisappeared(CA10__disappearanceTime__c) runtimeError: {} - id: missing-native-image-id match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 299 actual: 299 conditionText: expected: isEmptyLookup('CA10__image__r') actual: isEmptyLookup('CA10__image__r') runtimeError: {} - id: unknown-image-state match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__image__r.CA10__state__c') != 'available' actual: extract('CA10__image__r.CA10__state__c') != 'available' runtimeError: {} - id: pending-image-past-deprecation match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__image__r.CA10__state__c') != 'available' actual: extract('CA10__image__r.CA10__state__c') != 'available' runtimeError: {} - id: pending-image-no-deprecation match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__image__r.CA10__state__c') != 'available' actual: extract('CA10__image__r.CA10__state__c') != 'available' runtimeError: {} - id: invalid-image-past-deprecation match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__image__r.CA10__state__c') != 'available' actual: extract('CA10__image__r.CA10__state__c') != 'available' runtimeError: {} - id: invalid-image-no-deprecation match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__image__r.CA10__state__c') != 'available' actual: extract('CA10__image__r.CA10__state__c') != 'available' runtimeError: {} - id: deregistered-image-past-deprecation match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__image__r.CA10__state__c') != 'available' actual: extract('CA10__image__r.CA10__state__c') != 'available' runtimeError: {} - id: transient-image-past-deprecation match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__image__r.CA10__state__c') != 'available' actual: extract('CA10__image__r.CA10__state__c') != 'available' runtimeError: {} - id: transient-image-no-deprecation match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__image__r.CA10__state__c') != 'available' actual: extract('CA10__image__r.CA10__state__c') != 'available' runtimeError: {} - id: failed-image-past-deprecation match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__image__r.CA10__state__c') != 'available' actual: extract('CA10__image__r.CA10__state__c') != 'available' runtimeError: {} - id: failed-image-no-deprecation match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__image__r.CA10__state__c') != 'available' actual: extract('CA10__image__r.CA10__state__c') != 'available' runtimeError: {} - id: error-image-past-deprecation match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__image__r.CA10__state__c') != 'available' actual: extract('CA10__image__r.CA10__state__c') != 'available' runtimeError: {} - id: error-image-no-deprecation match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__image__r.CA10__state__c') != 'available' actual: extract('CA10__image__r.CA10__state__c') != 'available' runtimeError: {} - id: disabled-image-past-deprecation match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__image__r.CA10__state__c') != 'available' actual: extract('CA10__image__r.CA10__state__c') != 'available' runtimeError: {} - id: disabled-image-no-deprecation match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__image__r.CA10__state__c') != 'available' actual: extract('CA10__image__r.CA10__state__c') != 'available' runtimeError: {} - id: disabled-image-future-deprecation match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__image__r.CA10__state__c') != 'available' actual: extract('CA10__image__r.CA10__state__c') != 'available' runtimeError: {} - id: public-image-deprecated match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() actual: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() runtimeError: {} - id: private-owned-image-deprecated match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() actual: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() runtimeError: {} - id: private-shared-image-deprecated match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() actual: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() runtimeError: {} - id: old-image-no-deprecation match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 599 actual: 599 conditionText: expected: extract('CA10__image__r.CA10__deprecationTime__c').isEmpty() actual: extract('CA10__image__r.CA10__deprecationTime__c').isEmpty() runtimeError: {} - id: recent-image-deprecated match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() actual: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() runtimeError: {} - id: deprecated-source-current-backup match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() actual: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() runtimeError: {} - id: current-source-deprecated-backup match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 599 actual: 599 conditionText: expected: extract('CA10__image__r.CA10__deprecationTime__c').isEmpty() actual: extract('CA10__image__r.CA10__deprecationTime__c').isEmpty() runtimeError: {} - id: terminated-missing-image match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 199 actual: 199 conditionText: expected: "setOfText(['terminated', 'shutting-down']).contains(extract('CA10__stateName__c'))" actual: "setOfText(['terminated', 'shutting-down']).contains(extract('CA10__stateName__c'))" runtimeError: {} - id: blank-image-state match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 304 actual: 304 conditionText: expected: CA10__state__c.isEmpty() actual: CA10__state__c.isEmpty() runtimeError: {} - id: missing-image-details match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 304 actual: 304 conditionText: expected: CA10__state__c.isEmpty() actual: CA10__state__c.isEmpty() runtimeError: {} - id: blank-native-image-id match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 299 actual: 299 conditionText: expected: isEmptyLookup('CA10__image__r') actual: isEmptyLookup('CA10__image__r') runtimeError: {} - id: offset-time-prior-utc-day match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() actual: extract('CA10__image__r.CA10__deprecationTime__c').beforeToday() runtimeError: {} - id: offset-time-current-utc-day match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 700 actual: 700 conditionText: expected: otherwise actual: otherwise runtimeError: {} usedFiles: - path: /ce/ca/aws/ec2/instance-deprecated-image/policy.yaml md5Hash: 3A3B4F9ADEB47AF96AB250BB9422A1AA content: | --- names: full: AWS EC2 Instance references a deprecated AMI contextual: Instance references a deprecated AMI description: > Identify existing EC2 instances whose source AMI has passed its scheduled deprecation date. Review replacement images through the normal deployment process. type: BEST_PRACTICE categories: - RELIABILITY frameworkMappings: - /frameworks/cloudaware/resource-reliability/infrastructure-modernization - path: /ce/ca/aws/ec2/instance-deprecated-image/prod.logic.yaml md5Hash: 176D16FCDB31665F0546F03526C9C8DB content: | --- inputType: CA10__CaAwsInstance__c testData: - file: test-data.json importExtracts: - file: /types/CA10__CaAwsInstance__c/object.extracts.yaml - file: /types/CA10__CaAwsImage__c/object.extracts.yaml conditions: - status: INAPPLICABLE currentStateMessage: The EC2 instance is terminated or shutting down. check: CONTAINS: arg: SET: itemType: TEXT items: - terminated - shutting-down search: EXTRACT: CA10__stateName__c # A missing or disappeared AMI is not evidence of an absent optional deprecation date. - status: UNDETERMINED currentStateMessage: The source AMI lookup is unresolved or the AMI has disappeared. check: IS_EMPTY_LOOKUP: CA10__image__r - status: INAPPLICABLE currentStateMessage: The source AMI is not available. check: NOT_EQUAL: left: EXTRACT: CA10__image__r.CA10__state__c right: TEXT: available # shortcut: native TODAY checks use UTC calendar days, use exact-time checks if the engine adds them. - status: INCOMPLIANT currentStateMessage: The source AMI deprecation time is before the current day. remediationMessage: Test a maintained replacement AMI and replace the instance through its deployment process. check: IS_BEFORE_TODAY: arg: EXTRACT: CA10__image__r.CA10__deprecationTime__c - status: COMPLIANT currentStateMessage: The resolved source AMI has no scheduled deprecation date. check: IS_EMPTY: arg: EXTRACT: CA10__image__r.CA10__deprecationTime__c - status: COMPLIANT currentStateMessage: The source AMI deprecation time is after the current day. check: IS_AFTER_TODAY: arg: EXTRACT: CA10__image__r.CA10__deprecationTime__c otherwise: status: INAPPLICABLE currentStateMessage: The source AMI deprecation falls on the current day, outside the date predicates' precision; verify its exact time in AWS. - path: /ce/ca/aws/ec2/instance-deprecated-image/test-data.json md5Hash: A2EB09C5258A8F9C737C494550F060C3 content: | [ { "Id": "past-running", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 499, "conditionText": "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-past-running", "CA10__image__r": { "Id": "image-past-running", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-22T23:59:59Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "past-stopped", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 499, "conditionText": "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "stopped", "CA10__image__c": "image-past-stopped", "CA10__image__r": { "Id": "image-past-stopped", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-22T23:59:59Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "past-stopping", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 499, "conditionText": "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "stopping", "CA10__image__c": "image-past-stopping", "CA10__image__r": { "Id": "image-past-stopping", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-22T23:59:59Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "past-pending", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 499, "conditionText": "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "pending", "CA10__image__c": "image-past-pending", "CA10__image__r": { "Id": "image-past-pending", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-22T23:59:59Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "future", "expectedResult": { "status": "COMPLIANT", "runtimeError": null, "conditionIndex": 699, "conditionText": "extract('CA10__image__r.CA10__deprecationTime__c').afterToday()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-future", "CA10__image__r": { "Id": "image-future", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-24T00:00:00Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "no-deprecation-date", "expectedResult": { "status": "COMPLIANT", "runtimeError": null, "conditionIndex": 599, "conditionText": "extract('CA10__image__r.CA10__deprecationTime__c').isEmpty()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-no-deprecation-date", "CA10__image__r": { "Id": "image-no-deprecation-date", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": null }, "CA10__imageId__c": "ami-test" }, { "Id": "today-midnight", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 700, "conditionText": "otherwise" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-today-midnight", "CA10__image__r": { "Id": "image-today-midnight", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-23T00:00:00Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "today-before-snapshot", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 700, "conditionText": "otherwise" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-today-before-snapshot", "CA10__image__r": { "Id": "image-today-before-snapshot", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-23T12:00:00Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "today-after-snapshot", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 700, "conditionText": "otherwise" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-today-after-snapshot", "CA10__image__r": { "Id": "image-today-after-snapshot", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-23T23:59:59Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "next-utc-day-expired", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 499, "conditionText": "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" }, "context": { "snapshotTime": "2026-10-24T00:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-next-utc-day-expired", "CA10__image__r": { "Id": "image-next-utc-day-expired", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-23T23:59:59Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "prior-utc-day-future", "expectedResult": { "status": "COMPLIANT", "runtimeError": null, "conditionIndex": 699, "conditionText": "extract('CA10__image__r.CA10__deprecationTime__c').afterToday()" }, "context": { "snapshotTime": "2026-10-22T23:59:59Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-prior-utc-day-future", "CA10__image__r": { "Id": "image-prior-utc-day-future", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-23T00:00:00Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "terminated", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 199, "conditionText": "setOfText(['terminated', 'shutting-down']).contains(extract('CA10__stateName__c'))" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "terminated", "CA10__image__c": "image-terminated", "CA10__image__r": { "Id": "image-terminated", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-22T23:59:59Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "shutting-down", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 199, "conditionText": "setOfText(['terminated', 'shutting-down']).contains(extract('CA10__stateName__c'))" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "shutting-down", "CA10__image__c": "image-shutting-down", "CA10__image__r": { "Id": "image-shutting-down", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-22T23:59:59Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "unknown-state", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 499, "conditionText": "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "unexpected", "CA10__image__c": "image-unknown-state", "CA10__image__r": { "Id": "image-unknown-state", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-22T23:59:59Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "missing-state", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 101, "conditionText": "CA10__stateName__c.isEmpty()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": null, "CA10__image__c": "image-missing-state", "CA10__image__r": { "Id": "image-missing-state", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-22T23:59:59Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "blank-state", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 101, "conditionText": "CA10__stateName__c.isEmpty()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "", "CA10__image__c": "image-blank-state", "CA10__image__r": { "Id": "image-blank-state", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-22T23:59:59Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "missing-image-lookup", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 299, "conditionText": "isEmptyLookup('CA10__image__r')" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": null, "CA10__image__r": { "Id": null, "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": null }, "CA10__imageId__c": "ami-test" }, { "Id": "unresolved-image-lookup", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 304, "conditionText": "CA10__state__c.isEmpty()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-unresolved-image-lookup", "CA10__image__r": { "Id": null, "CA10__disappearanceTime__c": null, "CA10__state__c": null, "CA10__deprecationTime__c": null }, "CA10__imageId__c": "ami-test" }, { "Id": "disappeared-image-no-date", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 299, "conditionText": "isEmptyLookup('CA10__image__r')" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-disappeared-image-no-date", "CA10__image__r": { "Id": "image-disappeared-image-no-date", "CA10__disappearanceTime__c": "2026-10-22T00:00:00Z", "CA10__state__c": "available", "CA10__deprecationTime__c": null }, "CA10__imageId__c": "ami-test" }, { "Id": "disappeared-image-past-date", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 299, "conditionText": "isEmptyLookup('CA10__image__r')" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-disappeared-image-past-date", "CA10__image__r": { "Id": "image-disappeared-image-past-date", "CA10__disappearanceTime__c": "2026-10-22T00:00:00Z", "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-22T00:00:00Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "missing-image-state", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 304, "conditionText": "CA10__state__c.isEmpty()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-missing-image-state", "CA10__image__r": { "Id": "image-missing-image-state", "CA10__disappearanceTime__c": null, "CA10__state__c": null, "CA10__deprecationTime__c": null }, "CA10__imageId__c": "ami-test" }, { "Id": "deregistered-image", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__image__r.CA10__state__c') != 'available'" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-deregistered-image", "CA10__image__r": { "Id": "image-deregistered-image", "CA10__disappearanceTime__c": null, "CA10__state__c": "deregistered", "CA10__deprecationTime__c": null }, "CA10__imageId__c": "ami-test" }, { "Id": "disappeared-instance", "expectedResult": { "status": "DISAPPEARED", "runtimeError": null, "conditionIndex": 99, "conditionText": "isDisappeared(CA10__disappearanceTime__c)" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": "2026-10-22T00:00:00Z", "CA10__stateName__c": "running", "CA10__image__c": "image-disappeared-instance", "CA10__image__r": { "Id": "image-disappeared-instance", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-22T00:00:00Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "missing-native-image-id", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 299, "conditionText": "isEmptyLookup('CA10__image__r')" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-missing-native-image-id", "CA10__image__r": { "Id": "image-missing-native-image-id", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-22T23:59:59Z" }, "CA10__imageId__c": null }, { "Id": "unknown-image-state", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__image__r.CA10__state__c') != 'available'" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-unknown-image-state", "CA10__image__r": { "Id": "image-unknown-image-state", "CA10__disappearanceTime__c": null, "CA10__state__c": "future-state", "CA10__deprecationTime__c": "2026-10-22T23:59:59Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "pending-image-past-deprecation", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__image__r.CA10__state__c') != 'available'" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-pending-image-past-deprecation", "CA10__image__r": { "Id": "image-pending-image-past-deprecation", "CA10__disappearanceTime__c": null, "CA10__state__c": "pending", "CA10__deprecationTime__c": "2026-10-22T23:59:00Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "pending-image-no-deprecation", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__image__r.CA10__state__c') != 'available'" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-pending-image-no-deprecation", "CA10__image__r": { "Id": "image-pending-image-no-deprecation", "CA10__disappearanceTime__c": null, "CA10__state__c": "pending", "CA10__deprecationTime__c": null }, "CA10__imageId__c": "ami-test" }, { "Id": "invalid-image-past-deprecation", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__image__r.CA10__state__c') != 'available'" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-invalid-image-past-deprecation", "CA10__image__r": { "Id": "image-invalid-image-past-deprecation", "CA10__disappearanceTime__c": null, "CA10__state__c": "invalid", "CA10__deprecationTime__c": "2026-10-22T23:59:00Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "invalid-image-no-deprecation", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__image__r.CA10__state__c') != 'available'" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-invalid-image-no-deprecation", "CA10__image__r": { "Id": "image-invalid-image-no-deprecation", "CA10__disappearanceTime__c": null, "CA10__state__c": "invalid", "CA10__deprecationTime__c": null }, "CA10__imageId__c": "ami-test" }, { "Id": "deregistered-image-past-deprecation", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__image__r.CA10__state__c') != 'available'" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-deregistered-image-past-deprecation", "CA10__image__r": { "Id": "image-deregistered-image-past-deprecation", "CA10__disappearanceTime__c": null, "CA10__state__c": "deregistered", "CA10__deprecationTime__c": "2026-10-22T23:59:00Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "transient-image-past-deprecation", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__image__r.CA10__state__c') != 'available'" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-transient-image-past-deprecation", "CA10__image__r": { "Id": "image-transient-image-past-deprecation", "CA10__disappearanceTime__c": null, "CA10__state__c": "transient", "CA10__deprecationTime__c": "2026-10-22T23:59:00Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "transient-image-no-deprecation", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__image__r.CA10__state__c') != 'available'" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-transient-image-no-deprecation", "CA10__image__r": { "Id": "image-transient-image-no-deprecation", "CA10__disappearanceTime__c": null, "CA10__state__c": "transient", "CA10__deprecationTime__c": null }, "CA10__imageId__c": "ami-test" }, { "Id": "failed-image-past-deprecation", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__image__r.CA10__state__c') != 'available'" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-failed-image-past-deprecation", "CA10__image__r": { "Id": "image-failed-image-past-deprecation", "CA10__disappearanceTime__c": null, "CA10__state__c": "failed", "CA10__deprecationTime__c": "2026-10-22T23:59:00Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "failed-image-no-deprecation", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__image__r.CA10__state__c') != 'available'" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-failed-image-no-deprecation", "CA10__image__r": { "Id": "image-failed-image-no-deprecation", "CA10__disappearanceTime__c": null, "CA10__state__c": "failed", "CA10__deprecationTime__c": null }, "CA10__imageId__c": "ami-test" }, { "Id": "error-image-past-deprecation", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__image__r.CA10__state__c') != 'available'" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-error-image-past-deprecation", "CA10__image__r": { "Id": "image-error-image-past-deprecation", "CA10__disappearanceTime__c": null, "CA10__state__c": "error", "CA10__deprecationTime__c": "2026-10-22T23:59:00Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "error-image-no-deprecation", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__image__r.CA10__state__c') != 'available'" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-error-image-no-deprecation", "CA10__image__r": { "Id": "image-error-image-no-deprecation", "CA10__disappearanceTime__c": null, "CA10__state__c": "error", "CA10__deprecationTime__c": null }, "CA10__imageId__c": "ami-test" }, { "Id": "disabled-image-past-deprecation", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__image__r.CA10__state__c') != 'available'" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-disabled-image-past-deprecation", "CA10__image__r": { "Id": "image-disabled-image-past-deprecation", "CA10__disappearanceTime__c": null, "CA10__state__c": "disabled", "CA10__deprecationTime__c": "2026-10-22T23:59:00Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "disabled-image-no-deprecation", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__image__r.CA10__state__c') != 'available'" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-disabled-image-no-deprecation", "CA10__image__r": { "Id": "image-disabled-image-no-deprecation", "CA10__disappearanceTime__c": null, "CA10__state__c": "disabled", "CA10__deprecationTime__c": null }, "CA10__imageId__c": "ami-test" }, { "Id": "disabled-image-future-deprecation", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__image__r.CA10__state__c') != 'available'" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-disabled-image-future-deprecation", "CA10__image__r": { "Id": "image-disabled-image-future-deprecation", "CA10__disappearanceTime__c": null, "CA10__state__c": "disabled", "CA10__deprecationTime__c": "2026-10-24T00:00:00Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "public-image-deprecated", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 499, "conditionText": "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-public-image-deprecated", "CA10__image__r": { "Id": "image-public-image-deprecated", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-22T23:59:00Z", "CA10__ownerId__c": "222222222222", "CA10__public__c": true }, "CA10__imageId__c": "ami-test", "CA10__ownerId__c": "111111111111" }, { "Id": "private-owned-image-deprecated", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 499, "conditionText": "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-private-owned-image-deprecated", "CA10__image__r": { "Id": "image-private-owned-image-deprecated", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-22T23:59:00Z", "CA10__ownerId__c": "111111111111", "CA10__public__c": false }, "CA10__imageId__c": "ami-test", "CA10__ownerId__c": "111111111111" }, { "Id": "private-shared-image-deprecated", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 499, "conditionText": "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-private-shared-image-deprecated", "CA10__image__r": { "Id": "image-private-shared-image-deprecated", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-22T23:59:00Z", "CA10__ownerId__c": "222222222222", "CA10__public__c": false }, "CA10__imageId__c": "ami-test", "CA10__ownerId__c": "111111111111" }, { "Id": "old-image-no-deprecation", "expectedResult": { "status": "COMPLIANT", "runtimeError": null, "conditionIndex": 599, "conditionText": "extract('CA10__image__r.CA10__deprecationTime__c').isEmpty()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-old-image-no-deprecation", "CA10__image__r": { "Id": "image-old-image-no-deprecation", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": null, "CA10__creationDate__c": "2016-01-01T00:00:00Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "recent-image-deprecated", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 499, "conditionText": "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-recent-image-deprecated", "CA10__image__r": { "Id": "image-recent-image-deprecated", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-22T23:59:00Z", "CA10__creationDate__c": "2026-10-21T00:00:00Z" }, "CA10__imageId__c": "ami-test" }, { "Id": "deprecated-source-current-backup", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 499, "conditionText": "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-deprecated-source-current-backup", "CA10__image__r": { "Id": "image-deprecated-source-current-backup", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-22T00:00:00Z" }, "CA10__imageId__c": "ami-test", "CA10__lastBackupImage__c": "backup-deprecated-source-current-backup", "CA10__lastBackupImage__r": { "Id": "backup-deprecated-source-current-backup", "CA10__state__c": "available", "CA10__disappearanceTime__c": null, "CA10__deprecationTime__c": null } }, { "Id": "current-source-deprecated-backup", "expectedResult": { "status": "COMPLIANT", "runtimeError": null, "conditionIndex": 599, "conditionText": "extract('CA10__image__r.CA10__deprecationTime__c').isEmpty()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-current-source-deprecated-backup", "CA10__image__r": { "Id": "image-current-source-deprecated-backup", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": null }, "CA10__imageId__c": "ami-test", "CA10__lastBackupImage__c": "backup-current-source-deprecated-backup", "CA10__lastBackupImage__r": { "Id": "backup-current-source-deprecated-backup", "CA10__state__c": "available", "CA10__disappearanceTime__c": null, "CA10__deprecationTime__c": "2026-10-22T00:00:00Z" } }, { "Id": "terminated-missing-image", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 199, "conditionText": "setOfText(['terminated', 'shutting-down']).contains(extract('CA10__stateName__c'))" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "terminated", "CA10__image__c": null, "CA10__imageId__c": null, "CA10__image__r": { "Id": null, "CA10__state__c": null, "CA10__disappearanceTime__c": null, "CA10__deprecationTime__c": null } }, { "Id": "blank-image-state", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 304, "conditionText": "CA10__state__c.isEmpty()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-blank-image-state", "CA10__image__r": { "Id": "image-blank-image-state", "CA10__disappearanceTime__c": null, "CA10__state__c": " ", "CA10__deprecationTime__c": null }, "CA10__imageId__c": "ami-test" }, { "Id": "missing-image-details", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 304, "conditionText": "CA10__state__c.isEmpty()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-missing-image-details", "CA10__image__r": { "Id": "image-missing-image-details", "CA10__state__c": null, "CA10__disappearanceTime__c": null, "CA10__deprecationTime__c": null }, "CA10__imageId__c": "ami-test" }, { "Id": "blank-native-image-id", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 299, "conditionText": "isEmptyLookup('CA10__image__r')" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-blank-native-image-id", "CA10__image__r": { "Id": "image-blank-native-image-id", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-22T23:59:00Z" }, "CA10__imageId__c": " " }, { "Id": "offset-time-prior-utc-day", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 499, "conditionText": "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-offset-time-prior-utc-day", "CA10__image__r": { "Id": "image-offset-time-prior-utc-day", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-23T01:00:00+05:00" }, "CA10__imageId__c": "ami-test" }, { "Id": "offset-time-current-utc-day", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 700, "conditionText": "otherwise" }, "context": { "snapshotTime": "2026-10-23T18:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__stateName__c": "running", "CA10__image__c": "image-offset-time-current-utc-day", "CA10__image__r": { "Id": "image-offset-time-current-utc-day", "CA10__disappearanceTime__c": null, "CA10__state__c": "available", "CA10__deprecationTime__c": "2026-10-24T02:30:00+05:00" }, "CA10__imageId__c": "ami-test" } ] - path: /types/CA10__CaAwsInstance__c/object.extracts.yaml md5Hash: 6BDBD161D9C7C5EF90632F9B9E0AB177 content: "---\nextracts:\n# Values pending, applied. Not nullable. Can't have\ \ no access, retrieved via ec2:DescribeInstances\n - name: \"CA10__metadataState__c\"\ \n value: \n FIELD:\n path: \"CA10__metadataState__c\"\n \ \ undeterminedIf:\n isEmpty: \"Corrupted data. EC2 Instances Metadata\ \ State cannot be empty.\"\n# Values: optional, required. Not nullable. Can't\ \ have no access, retrieved via ec2:DescribeInstances\n - name: \"CA10__metadataHttpTokens__c\"\ \n value: \n FIELD:\n path: \"CA10__metadataHttpTokens__c\"\n\ \ undeterminedIf:\n isEmpty: \"Corrupted data. EC2 Instances\ \ Metadata Http Token cannot be empty.\"\n - name: CA10__iamInstanceProfileArn__c\n\ \ value:\n FIELD: \n path: CA10__iamInstanceProfileArn__c\n#\ \ Nullable. Can't have no access, retrieved via ec2:DescribeInstances\n - name:\ \ \"CA10__publicIpAddress__c\"\n value: \n FIELD:\n path: \"\ CA10__publicIpAddress__c\"\n# Values: enabled, disabled. Not nullable. Can't\ \ have no access, retrieved via ec2:DescribeInstances\n - name: \"CA10__monitoringState__c\"\ \n value: \n FIELD:\n path: \"CA10__monitoringState__c\"\n \ \ undeterminedIf:\n isEmpty: \"Corrupted data. EC2 Instances Detailed\ \ Monitoring State cannot be empty.\"\n# Values: pending | running | shutting-down\ \ | terminated | stopping | stopped. Not nullable.\n - name: \"CA10__stateName__c\"\ \n value: \n FIELD:\n path: \"CA10__stateName__c\"\n undeterminedIf:\n\ \ isEmpty: \"Corrupted data. EC2 Instance State Name cannot be empty.\"\ \n# Number of Days. Nullable. Can't have no access, retrieved via ec2:DescribeInstances\n\ \ - name: \"CA10__currentRunningTime__c\"\n value: \n FIELD:\n \ \ path: \"CA10__currentRunningTime__c\" \n# Nullable.\n - name: \"\ CA10__averageCpuTwoWeeks__c\"\n value: \n FIELD:\n path: \"CA10__averageCpuTwoWeeks__c\"\ \ \n# Nullable.\n - name: \"CA10__maxCpuTwoWeeks__c\"\n value: \n \ \ FIELD:\n path: \"CA10__maxCpuTwoWeeks__c\" \n# Nullable.\n\ \ - name: \"CA10__sumTwoWeekNetworkOutMb__c\"\n value: \n FIELD:\n\ \ path: \"CA10__sumTwoWeekNetworkOutMb__c\" \n# Nullable.\n - name:\ \ \"CA10__sumTwoWeekNetworkInMb__c\"\n value: \n FIELD:\n path:\ \ \"CA10__sumTwoWeekNetworkInMb__c\" \n # Nullable.\n - name: \"CA10N__newRelicHost__c\"\ \n value:\n FIELD:\n path: \"CA10N__newRelicHost__c\"\n # Nullable.\ \ \n - name: \"CA10N__newRelicHostCpuUsed__c\"\n value:\n FIELD:\n\ \ path: \"CA10N__newRelicHostCpuUsed__c\"\n # Nullable.\n - name: \"\ CA10N__newRelicHostMemoryUsed14Day__c\"\n value:\n FIELD:\n path:\ \ \"CA10N__newRelicHostMemoryUsed14Day__c\"\n # Nullable.\n - name: \"CA10__averageMemoryUsedTwoWeeks__c\"\ \n value:\n FIELD:\n path: \"CA10__averageMemoryUsedTwoWeeks__c\"\ \n # Nullable.\n - name: \"CA10__nagiosMemoryUtilization__c\"\n value:\n\ \ FIELD:\n path: \"CA10__nagiosMemoryUtilization__c\"\n # Nullable.\n\ \ - name: \"CA10N__newRelicHostDiskUtilization__c\"\n value:\n FIELD:\n\ \ path: \"CA10N__newRelicHostDiskUtilization__c\"\n # Nullable.\n -\ \ name: \"CA10N__newRelicHostDiskReadUtilization__c\"\n value:\n FIELD:\n\ \ path: \"CA10N__newRelicHostDiskReadUtilization__c\"\n # Nullable.\n\ \ - name: \"CA10N__newRelicHostDiskWriteUtilization__c\"\n value:\n \ \ FIELD:\n path: \"CA10N__newRelicHostDiskWriteUtilization__c\"\n #\ \ Nullable.\n - name: \"CA10__regionName__c\"\n value:\n FIELD:\n \ \ path: \"CA10__regionName__c\"\n# Values: paravirtual | hvm. Not nullable.\ \ Can't have no access, retrieved via ec2:DescribeInstances\n - name: \"CA10__virtualizationType__c\"\ \n value: \n FIELD:\n path: \"CA10__virtualizationType__c\"\n\ \ undeterminedIf:\n isEmpty: \"Corrupted data. EC2 Instances\ \ Virtualization Type cannot be empty.\"\n # Nullable when OS lifecycle enrichment\ \ is unavailable.\n - name: CA10__osInfoSource__c\n value:\n FIELD:\n\ \ path: CA10__osInfoSource__c\n # Nullable\n - name: CA10__osInfoMaintained__c\n\ \ value:\n FIELD:\n path: CA10__osInfoMaintained__c\n \ \ undeterminedIf:\n isEmpty: The OS lifecycle maintained indicator\ \ is missing.\n # Nullable\n - name: CA10__osInfoEolFrom__c\n value:\n\ \ FIELD:\n path: CA10__osInfoEolFrom__c\n # Nullable\n - name:\ \ CA10__osInfoEoesFrom__c\n value:\n FIELD:\n path: CA10__osInfoEoesFrom__c\n" - path: /types/CA10__CaAwsImage__c/object.extracts.yaml md5Hash: CFB4BAB9CCDF4259FFC0C59F39CB4829 content: "---\nextracts:\n# Nulable. Boolean. Values: true, false.\n - name:\ \ \"CA10__public__c\"\n value: \n FIELD:\n path: \"CA10__public__c\"\ \n# Values: pending | available | invalid | deregistered | transient | failed\ \ | error | disabled. \n# Not nullable\n - name: \"CA10__state__c\"\n value:\ \ \n FIELD:\n path: \"CA10__state__c\"\n undeterminedIf:\n\ \ isEmpty: \"The AMI state is not collected.\"\n#Not nullable\n -\ \ name: \"CA10__creationDate__c\"\n value: \n FIELD:\n path:\ \ \"CA10__creationDate__c\"\n# Nullable\n - name: \"CA10__lastLaunchedTime__c\"\ \n value: \n FIELD:\n path: \"CA10__lastLaunchedTime__c\"\n \ \ # Optional. An absent date on a resolved AMI means no scheduled deprecation.\n\ \ - name: CA10__deprecationTime__c\n value:\n FIELD:\n path:\ \ CA10__deprecationTime__c\n" script: |- CREATE TEMP FUNCTION mock_ExpectedResult() RETURNS ARRAY >> DETERMINISTIC LANGUAGE js AS r""" return [ { "Id" : "past-running", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" } }, { "Id" : "past-stopped", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" } }, { "Id" : "past-stopping", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" } }, { "Id" : "past-pending", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" } }, { "Id" : "future", "expectedResult" : { "status" : "COMPLIANT", "runtimeError" : null, "conditionIndex" : 699, "conditionText" : "extract('CA10__image__r.CA10__deprecationTime__c').afterToday()" } }, { "Id" : "no-deprecation-date", "expectedResult" : { "status" : "COMPLIANT", "runtimeError" : null, "conditionIndex" : 599, "conditionText" : "extract('CA10__image__r.CA10__deprecationTime__c').isEmpty()" } }, { "Id" : "today-midnight", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 700, "conditionText" : "otherwise" } }, { "Id" : "today-before-snapshot", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 700, "conditionText" : "otherwise" } }, { "Id" : "today-after-snapshot", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 700, "conditionText" : "otherwise" } }, { "Id" : "next-utc-day-expired", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" } }, { "Id" : "prior-utc-day-future", "expectedResult" : { "status" : "COMPLIANT", "runtimeError" : null, "conditionIndex" : 699, "conditionText" : "extract('CA10__image__r.CA10__deprecationTime__c').afterToday()" } }, { "Id" : "terminated", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 199, "conditionText" : "setOfText(['terminated', 'shutting-down']).contains(extract('CA10__stateName__c'))" } }, { "Id" : "shutting-down", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 199, "conditionText" : "setOfText(['terminated', 'shutting-down']).contains(extract('CA10__stateName__c'))" } }, { "Id" : "unknown-state", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" } }, { "Id" : "missing-state", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 101, "conditionText" : "CA10__stateName__c.isEmpty()" } }, { "Id" : "blank-state", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 101, "conditionText" : "CA10__stateName__c.isEmpty()" } }, { "Id" : "missing-image-lookup", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 299, "conditionText" : "isEmptyLookup('CA10__image__r')" } }, { "Id" : "unresolved-image-lookup", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 304, "conditionText" : "CA10__state__c.isEmpty()" } }, { "Id" : "disappeared-image-no-date", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 299, "conditionText" : "isEmptyLookup('CA10__image__r')" } }, { "Id" : "disappeared-image-past-date", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 299, "conditionText" : "isEmptyLookup('CA10__image__r')" } }, { "Id" : "missing-image-state", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 304, "conditionText" : "CA10__state__c.isEmpty()" } }, { "Id" : "deregistered-image", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__image__r.CA10__state__c') != 'available'" } }, { "Id" : "disappeared-instance", "expectedResult" : { "status" : "DISAPPEARED", "runtimeError" : null, "conditionIndex" : 99, "conditionText" : "isDisappeared(CA10__disappearanceTime__c)" } }, { "Id" : "missing-native-image-id", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 299, "conditionText" : "isEmptyLookup('CA10__image__r')" } }, { "Id" : "unknown-image-state", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__image__r.CA10__state__c') != 'available'" } }, { "Id" : "pending-image-past-deprecation", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__image__r.CA10__state__c') != 'available'" } }, { "Id" : "pending-image-no-deprecation", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__image__r.CA10__state__c') != 'available'" } }, { "Id" : "invalid-image-past-deprecation", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__image__r.CA10__state__c') != 'available'" } }, { "Id" : "invalid-image-no-deprecation", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__image__r.CA10__state__c') != 'available'" } }, { "Id" : "deregistered-image-past-deprecation", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__image__r.CA10__state__c') != 'available'" } }, { "Id" : "transient-image-past-deprecation", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__image__r.CA10__state__c') != 'available'" } }, { "Id" : "transient-image-no-deprecation", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__image__r.CA10__state__c') != 'available'" } }, { "Id" : "failed-image-past-deprecation", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__image__r.CA10__state__c') != 'available'" } }, { "Id" : "failed-image-no-deprecation", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__image__r.CA10__state__c') != 'available'" } }, { "Id" : "error-image-past-deprecation", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__image__r.CA10__state__c') != 'available'" } }, { "Id" : "error-image-no-deprecation", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__image__r.CA10__state__c') != 'available'" } }, { "Id" : "disabled-image-past-deprecation", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__image__r.CA10__state__c') != 'available'" } }, { "Id" : "disabled-image-no-deprecation", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__image__r.CA10__state__c') != 'available'" } }, { "Id" : "disabled-image-future-deprecation", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__image__r.CA10__state__c') != 'available'" } }, { "Id" : "public-image-deprecated", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" } }, { "Id" : "private-owned-image-deprecated", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" } }, { "Id" : "private-shared-image-deprecated", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" } }, { "Id" : "old-image-no-deprecation", "expectedResult" : { "status" : "COMPLIANT", "runtimeError" : null, "conditionIndex" : 599, "conditionText" : "extract('CA10__image__r.CA10__deprecationTime__c').isEmpty()" } }, { "Id" : "recent-image-deprecated", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" } }, { "Id" : "deprecated-source-current-backup", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" } }, { "Id" : "current-source-deprecated-backup", "expectedResult" : { "status" : "COMPLIANT", "runtimeError" : null, "conditionIndex" : 599, "conditionText" : "extract('CA10__image__r.CA10__deprecationTime__c').isEmpty()" } }, { "Id" : "terminated-missing-image", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 199, "conditionText" : "setOfText(['terminated', 'shutting-down']).contains(extract('CA10__stateName__c'))" } }, { "Id" : "blank-image-state", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 304, "conditionText" : "CA10__state__c.isEmpty()" } }, { "Id" : "missing-image-details", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 304, "conditionText" : "CA10__state__c.isEmpty()" } }, { "Id" : "blank-native-image-id", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 299, "conditionText" : "isEmptyLookup('CA10__image__r')" } }, { "Id" : "offset-time-prior-utc-day", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()" } }, { "Id" : "offset-time-current-utc-day", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 700, "conditionText" : "otherwise" } } ]; """; CREATE TEMP FUNCTION mock_CA10__CaAwsInstance__c() RETURNS ARRAY >> DETERMINISTIC LANGUAGE js AS r""" return [ { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-past-running", "CA10__imageId__c" : "ami-test", "Id" : "past-running" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "stopped", "CA10__image__c" : "image-past-stopped", "CA10__imageId__c" : "ami-test", "Id" : "past-stopped" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "stopping", "CA10__image__c" : "image-past-stopping", "CA10__imageId__c" : "ami-test", "Id" : "past-stopping" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "pending", "CA10__image__c" : "image-past-pending", "CA10__imageId__c" : "ami-test", "Id" : "past-pending" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-future", "CA10__imageId__c" : "ami-test", "Id" : "future" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-no-deprecation-date", "CA10__imageId__c" : "ami-test", "Id" : "no-deprecation-date" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-today-midnight", "CA10__imageId__c" : "ami-test", "Id" : "today-midnight" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-today-before-snapshot", "CA10__imageId__c" : "ami-test", "Id" : "today-before-snapshot" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-today-after-snapshot", "CA10__imageId__c" : "ami-test", "Id" : "today-after-snapshot" }, { "context" : { "snapshotTime" : new Date("2026-10-24T00:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-next-utc-day-expired", "CA10__imageId__c" : "ami-test", "Id" : "next-utc-day-expired" }, { "context" : { "snapshotTime" : new Date("2026-10-22T23:59:59Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-prior-utc-day-future", "CA10__imageId__c" : "ami-test", "Id" : "prior-utc-day-future" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "terminated", "CA10__image__c" : "image-terminated", "CA10__imageId__c" : "ami-test", "Id" : "terminated" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "shutting-down", "CA10__image__c" : "image-shutting-down", "CA10__imageId__c" : "ami-test", "Id" : "shutting-down" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "unexpected", "CA10__image__c" : "image-unknown-state", "CA10__imageId__c" : "ami-test", "Id" : "unknown-state" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : null, "CA10__image__c" : "image-missing-state", "CA10__imageId__c" : "ami-test", "Id" : "missing-state" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "", "CA10__image__c" : "image-blank-state", "CA10__imageId__c" : "ami-test", "Id" : "blank-state" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : null, "CA10__imageId__c" : "ami-test", "Id" : "missing-image-lookup" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-unresolved-image-lookup", "CA10__imageId__c" : "ami-test", "Id" : "unresolved-image-lookup" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-disappeared-image-no-date", "CA10__imageId__c" : "ami-test", "Id" : "disappeared-image-no-date" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-disappeared-image-past-date", "CA10__imageId__c" : "ami-test", "Id" : "disappeared-image-past-date" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-missing-image-state", "CA10__imageId__c" : "ami-test", "Id" : "missing-image-state" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-deregistered-image", "CA10__imageId__c" : "ami-test", "Id" : "deregistered-image" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__disappearanceTime__c" : new Date("2026-10-22T00:00:00Z"), "CA10__stateName__c" : "running", "CA10__image__c" : "image-disappeared-instance", "CA10__imageId__c" : "ami-test", "Id" : "disappeared-instance" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-missing-native-image-id", "CA10__imageId__c" : null, "Id" : "missing-native-image-id" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-unknown-image-state", "CA10__imageId__c" : "ami-test", "Id" : "unknown-image-state" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-pending-image-past-deprecation", "CA10__imageId__c" : "ami-test", "Id" : "pending-image-past-deprecation" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-pending-image-no-deprecation", "CA10__imageId__c" : "ami-test", "Id" : "pending-image-no-deprecation" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-invalid-image-past-deprecation", "CA10__imageId__c" : "ami-test", "Id" : "invalid-image-past-deprecation" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-invalid-image-no-deprecation", "CA10__imageId__c" : "ami-test", "Id" : "invalid-image-no-deprecation" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-deregistered-image-past-deprecation", "CA10__imageId__c" : "ami-test", "Id" : "deregistered-image-past-deprecation" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-transient-image-past-deprecation", "CA10__imageId__c" : "ami-test", "Id" : "transient-image-past-deprecation" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-transient-image-no-deprecation", "CA10__imageId__c" : "ami-test", "Id" : "transient-image-no-deprecation" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-failed-image-past-deprecation", "CA10__imageId__c" : "ami-test", "Id" : "failed-image-past-deprecation" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-failed-image-no-deprecation", "CA10__imageId__c" : "ami-test", "Id" : "failed-image-no-deprecation" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-error-image-past-deprecation", "CA10__imageId__c" : "ami-test", "Id" : "error-image-past-deprecation" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-error-image-no-deprecation", "CA10__imageId__c" : "ami-test", "Id" : "error-image-no-deprecation" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-disabled-image-past-deprecation", "CA10__imageId__c" : "ami-test", "Id" : "disabled-image-past-deprecation" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-disabled-image-no-deprecation", "CA10__imageId__c" : "ami-test", "Id" : "disabled-image-no-deprecation" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-disabled-image-future-deprecation", "CA10__imageId__c" : "ami-test", "Id" : "disabled-image-future-deprecation" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-public-image-deprecated", "CA10__imageId__c" : "ami-test", "Id" : "public-image-deprecated" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-private-owned-image-deprecated", "CA10__imageId__c" : "ami-test", "Id" : "private-owned-image-deprecated" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-private-shared-image-deprecated", "CA10__imageId__c" : "ami-test", "Id" : "private-shared-image-deprecated" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-old-image-no-deprecation", "CA10__imageId__c" : "ami-test", "Id" : "old-image-no-deprecation" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-recent-image-deprecated", "CA10__imageId__c" : "ami-test", "Id" : "recent-image-deprecated" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-deprecated-source-current-backup", "CA10__imageId__c" : "ami-test", "Id" : "deprecated-source-current-backup" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-current-source-deprecated-backup", "CA10__imageId__c" : "ami-test", "Id" : "current-source-deprecated-backup" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "terminated", "CA10__image__c" : null, "CA10__imageId__c" : null, "Id" : "terminated-missing-image" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-blank-image-state", "CA10__imageId__c" : "ami-test", "Id" : "blank-image-state" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-missing-image-details", "CA10__imageId__c" : "ami-test", "Id" : "missing-image-details" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-blank-native-image-id", "CA10__imageId__c" : " ", "Id" : "blank-native-image-id" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-offset-time-prior-utc-day", "CA10__imageId__c" : "ami-test", "Id" : "offset-time-prior-utc-day" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "CA10__stateName__c" : "running", "CA10__image__c" : "image-offset-time-current-utc-day", "CA10__imageId__c" : "ami-test", "Id" : "offset-time-current-utc-day" } ]; """; CREATE TEMP FUNCTION mock_CA10__CaAwsImage__c() RETURNS ARRAY >> DETERMINISTIC LANGUAGE js AS r""" return [ { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-past-running", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:59Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-past-stopped", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:59Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-past-stopping", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:59Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-past-pending", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:59Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-future", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-24T00:00:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-no-deprecation-date", "CA10__state__c" : "available" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-today-midnight", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-23T00:00:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-today-before-snapshot", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-23T12:00:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-today-after-snapshot", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-23T23:59:59Z") }, { "context" : { "snapshotTime" : new Date("2026-10-24T00:00:00Z") }, "Id" : "image-next-utc-day-expired", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-23T23:59:59Z") }, { "context" : { "snapshotTime" : new Date("2026-10-22T23:59:59Z") }, "Id" : "image-prior-utc-day-future", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-23T00:00:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-terminated", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:59Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-shutting-down", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:59Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-unknown-state", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:59Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-missing-state", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:59Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-blank-state", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:59Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : null, "CA10__state__c" : null }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-disappeared-image-no-date", "CA10__disappearanceTime__c" : new Date("2026-10-22T00:00:00Z"), "CA10__state__c" : "available" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-disappeared-image-past-date", "CA10__disappearanceTime__c" : new Date("2026-10-22T00:00:00Z"), "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-22T00:00:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-missing-image-state", "CA10__state__c" : null }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-deregistered-image", "CA10__state__c" : "deregistered" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-disappeared-instance", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-22T00:00:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-missing-native-image-id", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:59Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-unknown-image-state", "CA10__state__c" : "future-state", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:59Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-pending-image-past-deprecation", "CA10__state__c" : "pending", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-pending-image-no-deprecation", "CA10__state__c" : "pending" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-invalid-image-past-deprecation", "CA10__state__c" : "invalid", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-invalid-image-no-deprecation", "CA10__state__c" : "invalid" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-deregistered-image-past-deprecation", "CA10__state__c" : "deregistered", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-transient-image-past-deprecation", "CA10__state__c" : "transient", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-transient-image-no-deprecation", "CA10__state__c" : "transient" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-failed-image-past-deprecation", "CA10__state__c" : "failed", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-failed-image-no-deprecation", "CA10__state__c" : "failed" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-error-image-past-deprecation", "CA10__state__c" : "error", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-error-image-no-deprecation", "CA10__state__c" : "error" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-disabled-image-past-deprecation", "CA10__state__c" : "disabled", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-disabled-image-no-deprecation", "CA10__state__c" : "disabled" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-disabled-image-future-deprecation", "CA10__state__c" : "disabled", "CA10__deprecationTime__c" : new Date("2026-10-24T00:00:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-public-image-deprecated", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-private-owned-image-deprecated", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-private-shared-image-deprecated", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-old-image-no-deprecation", "CA10__state__c" : "available" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-recent-image-deprecated", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-deprecated-source-current-backup", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-22T00:00:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-current-source-deprecated-backup", "CA10__state__c" : "available" }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-blank-image-state", "CA10__state__c" : " " }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-missing-image-details", "CA10__state__c" : null }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-blank-native-image-id", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-22T23:59:00Z") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-offset-time-prior-utc-day", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-23T01:00:00+05:00") }, { "context" : { "snapshotTime" : new Date("2026-10-23T18:00:00Z") }, "Id" : "image-offset-time-current-utc-day", "CA10__state__c" : "available", "CA10__deprecationTime__c" : new Date("2026-10-24T02:30:00+05:00") } ]; """; CREATE TEMP FUNCTION process_CA10__CaAwsInstance__c( obj STRUCT< CA10__disappearanceTime__c TIMESTAMP, CA10__stateName__c STRING, CA10__image__r STRUCT< Id STRING, CA10__disappearanceTime__c TIMESTAMP, CA10__state__c STRING, CA10__deprecationTime__c TIMESTAMP >, CA10__image__c STRING, CA10__imageId__c STRING, Id STRING >, snapshotTime TIMESTAMP ) RETURNS STRUCT DETERMINISTIC LANGUAGE js AS r""" var IsEmptyLib = new function () { this.simpleIsEmpty = function(arg) { return arg == null; }; this.simpleIsNotEmpty = function(arg) { return arg != null; }; }(); var CollectionLib = new function () { this.parse = function(arg, separator, skipEmpty, skipDuplicates, sort, normalize) { if (arg == null) return []; let parts = arg.split(separator); return this.fromArray(parts, skipEmpty, skipDuplicates, sort, normalize); }; this.fromArray = function(arr, skipEmpty, skipDuplicates, sort, normalize) { if (arr == null) return []; let result = []; let seen = new Set(); arr.forEach(el => { let normalized = normalize ? TextLib.normalize(el) : BytesLib.normalize(el); if (!skipEmpty || (normalize ? TextLib.isNotEmpty(el) : BytesLib.isNotEmpty(el))) { if (!skipDuplicates || !seen.has(normalized)) { if (skipDuplicates) seen.add(normalized); result.push(normalized); } } }); if (sort) result.sort(); return result; }; this.equal = function(left, right) { left = left == null ? [] : left; right = right == null ? [] : right; if (left.length !== right.length) return false; for (let i = 0; i < left.length; i++) { if (left[i] !== right[i]) return false; } return true; }; this.notEqual = function(left, right) { return !this.equal(left, right); }; this.size = function(collection) { return collection == null ? 0 : collection.length; }; this.startsWith = function(collection, search, normalize) { if (collection == null || collection.length === 0) return false; let normalizedSearch = normalize ? TextLib.normalize(search) : BytesLib.normalize(search); return collection[0] === normalizedSearch; }; this.endsWith = function(collection, search, normalize) { if (collection == null || collection.length === 0) return false; let normalizedSearch = normalize ? TextLib.normalize(search) : BytesLib.normalize(search); return collection[collection.length - 1] === normalizedSearch; }; this.contains = function(collection, search, normalize) { if (collection == null || collection.length === 0) return false; return collection.includes(normalize ? TextLib.normalize(search) : BytesLib.normalize(search)); }; this.containsAll = function(collection, searchArray, normalize) { if (collection == null || collection.length === 0 || searchArray == null || searchArray.length === 0) return false; return searchArray.every(search => collection.includes(normalize ? TextLib.normalize(search) : BytesLib.normalize(search))); }; this.containsAny = function(collection, searchArray, normalize) { if (collection == null || collection.length === 0 || searchArray == null || searchArray.length === 0) return false; return searchArray.some(search => collection.includes(normalize ? TextLib.normalize(search) : BytesLib.normalize(search))); }; }(); var BytesLib = new function () { this.normalize = function(arg) { return arg == null ? '' : arg; }; 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 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 today = new Date(snapshotTime.toISOString().substr(0,10)+'T00:00:00.000Z').getTime(); var todayPlus1Day = new Date(snapshotTime.toISOString().substr(0,10)+'T00:00:00.000Z').getTime() + (1 * 86400000); var references1 = []; // condition[0], conditionIndex:[0..99] references1.push('Deleted From AWS [CA10__disappearanceTime__c]: ' + obj.CA10__disappearanceTime__c); if (obj.CA10__disappearanceTime__c != null) { return {status: 'DISAPPEARED', conditionIndex: 99, conditionText: "isDisappeared(CA10__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.CA10__stateName__c)) { throw new Error("UNDETERMINED condition:101", {cause: {status: 'UNDETERMINED', conditionIndex: 101, conditionText: "CA10__stateName__c.isEmpty()", currentStateMessage: "Corrupted data. EC2 Instance State Name cannot be empty.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__stateName__c; } function extract3() { if (!this.out) { this.out = fieldChecked4(); } return this.out; }; references1.push('State Name [obj.CA10__stateName__c]: ' + obj.CA10__stateName__c); try { if (CollectionLib.contains(CollectionLib.fromArray(['terminated', 'shutting-down'], true, true, true, true), extract3.call(extract3), true)) { return {status: 'INAPPLICABLE', conditionIndex: 199, conditionText: "setOfText(['terminated', 'shutting-down']).contains(extract('CA10__stateName__c'))", currentStateMessage: "The EC2 instance is terminated or shutting down.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[2], conditionIndex:[200..299] if (TextLib.isEmpty(obj.CA10__imageId__c) || TextLib.isEmpty(obj.CA10__image__c) || obj.CA10__image__r.CA10__disappearanceTime__c != null) { return {status: 'UNDETERMINED', conditionIndex: 299, conditionText: "isEmptyLookup('CA10__image__r')", currentStateMessage: "The source AMI lookup is unresolved or the AMI has disappeared.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } // condition[3], conditionIndex:[300..399] function extractChecked5() { if (TextLib.isEmpty(obj.CA10__imageId__c)) { throw new Error("UNDETERMINED condition:301", {cause: {status: 'UNDETERMINED', conditionIndex: 301, conditionText: "extractCheck(obj.CA10__imageId__c)", currentStateMessage: "Related object via CA10__imageId__c has empty ID", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } if (TextLib.isEmpty(obj.CA10__image__c)) { throw new Error("UNDETERMINED condition:302", {cause: {status: 'UNDETERMINED', conditionIndex: 302, conditionText: "extractCheck(obj.CA10__image__c)", currentStateMessage: "Related object via CA10__image__c is not present", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } if (obj.CA10__image__r.CA10__disappearanceTime__c != null) { throw new Error("UNDETERMINED condition:303", {cause: {status: 'UNDETERMINED', conditionIndex: 303, conditionText: "extractCheck(obj.CA10__image__r.CA10__disappearanceTime__c)", currentStateMessage: "Related object via CA10__image__c is present, but deleted in the source", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return extract6.call(extract6); } function fieldChecked7() { if (TextLib.isEmpty(obj.CA10__image__r.CA10__state__c)) { throw new Error("UNDETERMINED condition:304", {cause: {status: 'UNDETERMINED', conditionIndex: 304, conditionText: "CA10__state__c.isEmpty()", currentStateMessage: "The AMI state is not collected.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__image__r.CA10__state__c; } function extract6() { if (!this.out) { this.out = fieldChecked7(); } return this.out; }; references1.push('State [obj.CA10__image__r.CA10__state__c]: ' + obj.CA10__image__r.CA10__state__c); try { if (TextLib.notEqual(extractChecked5(), 'available')) { return {status: 'INAPPLICABLE', conditionIndex: 399, conditionText: "extract('CA10__image__r.CA10__state__c') != 'available'", currentStateMessage: "The source AMI is not available.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[4], conditionIndex:[400..499] function extractChecked8() { if (TextLib.isEmpty(obj.CA10__imageId__c)) { throw new Error("UNDETERMINED condition:401", {cause: {status: 'UNDETERMINED', conditionIndex: 401, conditionText: "extractCheck(obj.CA10__imageId__c)", currentStateMessage: "Related object via CA10__imageId__c has empty ID", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } if (TextLib.isEmpty(obj.CA10__image__c)) { throw new Error("UNDETERMINED condition:402", {cause: {status: 'UNDETERMINED', conditionIndex: 402, conditionText: "extractCheck(obj.CA10__image__c)", currentStateMessage: "Related object via CA10__image__c is not present", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } if (obj.CA10__image__r.CA10__disappearanceTime__c != null) { throw new Error("UNDETERMINED condition:403", {cause: {status: 'UNDETERMINED', conditionIndex: 403, conditionText: "extractCheck(obj.CA10__image__r.CA10__disappearanceTime__c)", currentStateMessage: "Related object via CA10__image__c is present, but deleted in the source", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return extract9.call(extract9); } function extract9() { if (!this.out) { this.out = obj.CA10__image__r.CA10__deprecationTime__c; } return this.out; }; function dateRelativeRange11() { var dateRelativeRange12 = extractChecked8(); return dateRelativeRange12 != null && dateRelativeRange12.getTime() < today; } references1.push('Deprecation Time [obj.CA10__image__r.CA10__deprecationTime__c]: ' + obj.CA10__image__r.CA10__deprecationTime__c); try { if (dateRelativeRange11()) { return {status: 'INCOMPLIANT', conditionIndex: 499, conditionText: "extract('CA10__image__r.CA10__deprecationTime__c').beforeToday()", currentStateMessage: "The source AMI deprecation time is before the current day.", currentStateReferences: references1.join('\n'), remediation: "Test a maintained replacement AMI and replace the instance through its deployment process.", runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[5], conditionIndex:[500..599] function extractChecked13() { if (TextLib.isEmpty(obj.CA10__imageId__c)) { throw new Error("UNDETERMINED condition:501", {cause: {status: 'UNDETERMINED', conditionIndex: 501, conditionText: "extractCheck(obj.CA10__imageId__c)", currentStateMessage: "Related object via CA10__imageId__c has empty ID", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } if (TextLib.isEmpty(obj.CA10__image__c)) { throw new Error("UNDETERMINED condition:502", {cause: {status: 'UNDETERMINED', conditionIndex: 502, conditionText: "extractCheck(obj.CA10__image__c)", currentStateMessage: "Related object via CA10__image__c is not present", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } if (obj.CA10__image__r.CA10__disappearanceTime__c != null) { throw new Error("UNDETERMINED condition:503", {cause: {status: 'UNDETERMINED', conditionIndex: 503, conditionText: "extractCheck(obj.CA10__image__r.CA10__disappearanceTime__c)", currentStateMessage: "Related object via CA10__image__c is present, but deleted in the source", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return extract14.call(extract14); } function extract14() { if (!this.out) { this.out = obj.CA10__image__r.CA10__deprecationTime__c; } return this.out; }; try { if (IsEmptyLib.simpleIsEmpty(extractChecked13())) { return {status: 'COMPLIANT', conditionIndex: 599, conditionText: "extract('CA10__image__r.CA10__deprecationTime__c').isEmpty()", currentStateMessage: "The resolved source AMI has no scheduled deprecation date.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[6], conditionIndex:[600..699] function extractChecked16() { if (TextLib.isEmpty(obj.CA10__imageId__c)) { throw new Error("UNDETERMINED condition:601", {cause: {status: 'UNDETERMINED', conditionIndex: 601, conditionText: "extractCheck(obj.CA10__imageId__c)", currentStateMessage: "Related object via CA10__imageId__c has empty ID", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } if (TextLib.isEmpty(obj.CA10__image__c)) { throw new Error("UNDETERMINED condition:602", {cause: {status: 'UNDETERMINED', conditionIndex: 602, conditionText: "extractCheck(obj.CA10__image__c)", currentStateMessage: "Related object via CA10__image__c is not present", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } if (obj.CA10__image__r.CA10__disappearanceTime__c != null) { throw new Error("UNDETERMINED condition:603", {cause: {status: 'UNDETERMINED', conditionIndex: 603, conditionText: "extractCheck(obj.CA10__image__r.CA10__disappearanceTime__c)", currentStateMessage: "Related object via CA10__image__c is present, but deleted in the source", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return extract17.call(extract17); } function extract17() { if (!this.out) { this.out = obj.CA10__image__r.CA10__deprecationTime__c; } return this.out; }; function dateRelativeRange19() { var dateRelativeRange20 = extractChecked16(); return dateRelativeRange20 != null && dateRelativeRange20.getTime() >= todayPlus1Day; } try { if (dateRelativeRange19()) { return {status: 'COMPLIANT', conditionIndex: 699, conditionText: "extract('CA10__image__r.CA10__deprecationTime__c').afterToday()", currentStateMessage: "The source AMI deprecation time is after the current day.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } return {status: 'INAPPLICABLE', conditionIndex: 700, conditionText: "otherwise", currentStateMessage: "The source AMI deprecation falls on the current day, outside the date predicates' precision; verify its exact time in AWS.", 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 sObject.CA10__disappearanceTime__c AS CA10__disappearanceTime__c, sObject.CA10__stateName__c AS CA10__stateName__c, STRUCT ( `CA10__image__r`.Id AS Id, `CA10__image__r`.CA10__disappearanceTime__c AS CA10__disappearanceTime__c, `CA10__image__r`.CA10__state__c AS CA10__state__c, `CA10__image__r`.CA10__deprecationTime__c AS CA10__deprecationTime__c ) AS CA10__image__r, sObject.CA10__image__c AS CA10__image__c, sObject.CA10__imageId__c AS CA10__imageId__c, sObject.Id AS Id, process_CA10__CaAwsInstance__c( STRUCT( sObject.CA10__disappearanceTime__c AS CA10__disappearanceTime__c, sObject.CA10__stateName__c AS CA10__stateName__c, STRUCT ( `CA10__image__r`.Id AS Id, `CA10__image__r`.CA10__disappearanceTime__c AS CA10__disappearanceTime__c, `CA10__image__r`.CA10__state__c AS CA10__state__c, `CA10__image__r`.CA10__deprecationTime__c AS CA10__deprecationTime__c ) AS CA10__image__r, sObject.CA10__image__c AS CA10__image__c, sObject.CA10__imageId__c AS CA10__imageId__c, sObject.Id AS Id ), sObject.context.snapshotTime ) as result FROM UNNEST(mock_CA10__CaAwsInstance__c()) AS sObject LEFT JOIN UNNEST(mock_CA10__CaAwsImage__c()) AS `CA10__image__r` ON sObject.CA10__image__c = `CA10__image__r`.Id ) sObject ON sObject.Id = expectedResult.Id;