Operational Remediation Reports

Rollback Action Report

Choose Remediation

A SQL remediation report can turn a selected failed-check count into an explicit operator action.

Program

Play the query to choose failed checks and inspect the remediation action row.

rollback_action_report.sql 
CREATE TABLE rollback_policy (rollback_limit INTEGER);
INSERT INTO rollback_policy VALUES (1);
WITH params(failed_checks) AS (VALUES ()) SELECT 'service' AS scope, failed_checks, CASE WHEN failed_checks < 1 THEN 'monitor' WHEN failed_checks <= (SELECT rollback_limit + 2 FROM rollback_policy) THEN 'rollback' ELSE 'escalate' END AS action FROM params;

CREATE TABLE rollback_policy (rollback_limit INTEGER);
INSERT INTO rollback_policy VALUES (1);
WITH params(failed_checks) AS (VALUES ()) SELECT 'service' AS scope, failed_checks, CASE WHEN failed_checks < 1 THEN 'monitor' WHEN failed_checks <= (SELECT rollback_limit + 2 FROM rollback_policy) THEN 'rollback' ELSE 'escalate' END AS action FROM params;

CREATE TABLE rollback_policy (rollback_limit INTEGER);
INSERT INTO rollback_policy VALUES (1);
WITH params(failed_checks) AS (VALUES ()) SELECT 'service' AS scope, failed_checks, CASE WHEN failed_checks < 1 THEN 'monitor' WHEN failed_checks <= (SELECT rollback_limit + 2 FROM rollback_policy) THEN 'rollback' ELSE 'escalate' END AS action FROM params;
parameter row `failed_checks` is a selected scalar in the parameter CTE.
rollback policy The fixed policy table supplies the rollback threshold.
action label The CASE expression maps the selected count to monitor, rollback, or escalate.