Evidence under retention lock (count)
Evidence records whose locked_until timestamp is in the future. Demonstrates retention-control compliance.
complianceDQ pass
cmmc.evidence_locked_total
12
files · 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 locked_until > now()
Source SQL
select count(*)::int as value
from evidence
where locked_until is not null and locked_until > now()Data-quality assertions (1)
- rangeNon-negative counterror
Recent snapshots (32)
| Captured | Value | DQ | Notes |
|---|---|---|---|
| 5/3/2026, 4:46:18 AM | 12 | DQ pass | |
| 5/2/2026, 6:43:16 PM | 9 | DQ pass | |
| 5/1/2026, 6:43:46 PM | 9 | DQ pass | synthetic |
| 4/30/2026, 6:43:46 PM | 9 | DQ pass | synthetic |
| 4/29/2026, 6:43:46 PM | 9 | DQ pass | synthetic |
| 4/28/2026, 6:43:46 PM | 9 | DQ pass | synthetic |
| 4/27/2026, 6:43:46 PM | 9 | DQ pass | synthetic |
| 4/26/2026, 6:43:47 PM | 9 | DQ pass | synthetic |
| 4/25/2026, 6:43:47 PM | 9 | DQ pass | synthetic |
| 4/24/2026, 6:43:47 PM | 9 | DQ pass | synthetic |
| 4/23/2026, 6:43:47 PM | 9 | DQ pass | synthetic |
| 4/22/2026, 6:43:47 PM | 8 | DQ pass | synthetic |
| 4/21/2026, 6:43:47 PM | 8 | DQ pass | synthetic |
| 4/20/2026, 6:43:47 PM | 8 | DQ pass | synthetic |
| 4/19/2026, 6:43:47 PM | 9 | DQ pass | synthetic |
| 4/18/2026, 6:43:48 PM | 9 | DQ pass | synthetic |
| 4/17/2026, 6:43:48 PM | 9 | DQ pass | synthetic |
| 4/16/2026, 6:43:48 PM | 9 | DQ pass | synthetic |
| 4/15/2026, 6:43:48 PM | 9 | DQ pass | synthetic |
| 4/14/2026, 6:43:48 PM | 9 | DQ pass | synthetic |
| 4/13/2026, 6:43:48 PM | 9 | DQ pass | synthetic |
| 4/12/2026, 6:43:48 PM | 8 | DQ pass | synthetic |
| 4/11/2026, 6:43:49 PM | 9 | DQ pass | synthetic |
| 4/10/2026, 6:43:49 PM | 9 | DQ pass | synthetic |
| 4/9/2026, 6:43:49 PM | 8 | DQ pass | synthetic |
| 4/8/2026, 6:43:49 PM | 8 | DQ pass | synthetic |
| 4/7/2026, 6:43:49 PM | 8 | DQ pass | synthetic |
| 4/6/2026, 6:43:49 PM | 8 | DQ pass | synthetic |
| 4/5/2026, 6:43:49 PM | 8 | DQ pass | synthetic |
| 4/4/2026, 6:43:50 PM | 8 | DQ pass | synthetic |