Controls with stale review (count)
Controls whose last_reviewed_at is older than 180 days. Common surveillance-audit finding.
complianceDQ pass
cmmc.controls_stale_count
0
controls · 5/3/2026, 4:46:18 AM
- Source
- cmmc-tracker (mvp-01)
- Owner
- ISSO
- Versions
- 1
30-day trend
Current published version
Published 5/2/2026 by seed-script
v1
Formula
count where last_reviewed_at < now() - interval '180 days'
Source SQL
select count(*)::int as value
from control_status
where last_reviewed_at is null
or last_reviewed_at < now() - interval '180 days'Data-quality assertions (1)
- rangeNon-negative counterror
Recent snapshots (32)
| Captured | Value | DQ | Notes |
|---|---|---|---|
| 5/3/2026, 4:46:18 AM | 0 | DQ pass | |
| 5/2/2026, 6:43:23 PM | 0 | DQ pass | |
| 5/1/2026, 6:44:33 PM | 0 | DQ pass | synthetic |
| 4/30/2026, 6:44:33 PM | 0 | DQ pass | synthetic |
| 4/29/2026, 6:44:34 PM | 0 | DQ pass | synthetic |
| 4/28/2026, 6:44:34 PM | 0 | DQ pass | synthetic |
| 4/27/2026, 6:44:34 PM | 0 | DQ pass | synthetic |
| 4/26/2026, 6:44:34 PM | 0 | DQ pass | synthetic |
| 4/25/2026, 6:44:34 PM | 0 | DQ pass | synthetic |
| 4/24/2026, 6:44:34 PM | 0 | DQ pass | synthetic |
| 4/23/2026, 6:44:34 PM | 0 | DQ pass | synthetic |
| 4/22/2026, 6:44:35 PM | 0 | DQ pass | synthetic |
| 4/21/2026, 6:44:35 PM | 0 | DQ pass | synthetic |
| 4/20/2026, 6:44:35 PM | 0 | DQ pass | synthetic |
| 4/19/2026, 6:44:35 PM | 0 | DQ pass | synthetic |
| 4/18/2026, 6:44:35 PM | 0 | DQ pass | synthetic |
| 4/17/2026, 6:44:35 PM | 0 | DQ pass | synthetic |
| 4/16/2026, 6:44:35 PM | 0 | DQ pass | synthetic |
| 4/15/2026, 6:44:36 PM | 0 | DQ pass | synthetic |
| 4/14/2026, 6:44:36 PM | 0 | DQ pass | synthetic |
| 4/13/2026, 6:44:36 PM | 0 | DQ pass | synthetic |
| 4/12/2026, 6:44:36 PM | 0 | DQ pass | synthetic |
| 4/11/2026, 6:44:36 PM | 0 | DQ pass | synthetic |
| 4/10/2026, 6:44:36 PM | 0 | DQ pass | synthetic |
| 4/9/2026, 6:44:36 PM | 0 | DQ pass | synthetic |
| 4/8/2026, 6:44:37 PM | 0 | DQ pass | synthetic |
| 4/7/2026, 6:44:37 PM | 0 | DQ pass | synthetic |
| 4/6/2026, 6:44:37 PM | 0 | DQ pass | synthetic |
| 4/5/2026, 6:44:37 PM | 0 | DQ pass | synthetic |
| 4/4/2026, 6:44:37 PM | 0 | DQ pass | synthetic |