Open Issues

Active Issues

TABLE criticality, business_owner, approver, next_review, requirements, controls, systems
FROM "08.2 Issues"
WHERE status != "closed" AND status != "dismissed"
SORT criticality DESC, next_review ASC

High and Critical Issues

TABLE status, business_owner, next_review, requirements
FROM "08.2 Issues"
WHERE status != "closed" AND status != "dismissed" AND (criticality = "high" OR criticality = "critical")
SORT criticality DESC, next_review ASC

Closed or Dismissed Issues

TABLE status, criticality, business_owner, last_reviewed
FROM "08.2 Issues"
WHERE status = "closed" OR status = "dismissed"
SORT last_reviewed DESC