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.

failed_checks
rollback_action_report.sql
Replay: real traced execution (multi-file project)
CREATE TABLE rollback_policy (rollback_limit INTEGER);
INSERT INTO rollback_policy VALUES (1);
WITH params(failed_checks) AS (VALUES (2)) 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 (0)) 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 (4)) 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;

  1. tables ← 1 row

    1CREATE TABLE rollback_policy (rollback_limit INTEGER);2INSERT INTO rollback_policy VALUES (1);
    values this step1 rowtables

  2. rollback_policy ← 1 row

    1CREATE TABLE rollback_policy (rollback_limit INTEGER);2INSERT INTO rollback_policy VALUES (1);3WITH params(failed_checks) AS (VALUES (2)) 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;
    values this step1 rowrollback_policy

  3. result ← 1 row

    2INSERT INTO rollback_policy VALUES (1);3WITH params(failed_checks) AS (VALUES (2)) 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;
    values this step1 rowresult

  1. tables ← 1 row

    1CREATE TABLE rollback_policy (rollback_limit INTEGER);2INSERT INTO rollback_policy VALUES (1);
    values this step1 rowtables

  2. rollback_policy ← 1 row

    1CREATE TABLE rollback_policy (rollback_limit INTEGER);2INSERT INTO rollback_policy VALUES (1);3WITH params(failed_checks) AS (VALUES (0)) 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;
    values this step1 rowrollback_policy

  3. result ← 1 row

    2INSERT INTO rollback_policy VALUES (1);3WITH params(failed_checks) AS (VALUES (0)) 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;
    values this step1 rowresult

  1. tables ← 1 row

    1CREATE TABLE rollback_policy (rollback_limit INTEGER);2INSERT INTO rollback_policy VALUES (1);
    values this step1 rowtables

  2. rollback_policy ← 1 row

    1CREATE TABLE rollback_policy (rollback_limit INTEGER);2INSERT INTO rollback_policy VALUES (1);3WITH params(failed_checks) AS (VALUES (4)) 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;
    values this step1 rowrollback_policy

  3. result ← 1 row

    2INSERT INTO rollback_policy VALUES (1);3WITH params(failed_checks) AS (VALUES (4)) 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;
    values this step1 rowresult
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.