ssh_compliance_results


Description

{“what”:“Results of automated SSH configuration compliance checks, one row per check per scan.”,“why”:“Without it, there is no record of which SSH settings passed or failed over time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.839675515+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('ssh_compliance_results_id_seq'::regclass)

{“what”:“Unique numeric identifier for each compliance result row.”,“why”:“Without it, rows cannot be uniquely referenced for updates or deletions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.856849679+00:00”}

scan_timestamp timestamptz 35,6 null

{“what”:“Time the scan ran, in UTC with timezone offset.”,“why”:“Without it, results from different scans cannot be ordered or compared over time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.874371884+00:00”}

check_name text 2147483647 null

{“what”:“Name of the SSH compliance check, e.g., ‘PermitRootLogin’.”,“why”:“Without it, it is unclear which specific SSH setting or rule the result refers to.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.887630740+00:00”}

status text 2147483647 null

{“what”:“Compliance outcome, e.g., ‘pass’, ‘fail’, ‘error’.”,“why”:“Without it, it is unknown whether the check passed or failed, so no action can be taken.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.903029104+00:00”}

severity text 2147483647 null

{“what”:“Importance level of the check, e.g., ‘high’, ‘medium’, ‘low’.”,“why”:“Without it, failed checks cannot be prioritized for remediation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.916511114+00:00”}

current_value text 2147483647 √ null

{“what”:“Value found on the system for the checked setting, if any.”,“why”:“Without it, the actual configuration is unknown, so the failure cannot be diagnosed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.932703830+00:00”}

expected_value text 2147483647 √ null

{“what”:“Value the check expects for the setting, if defined.”,“why”:“Without it, the target configuration is unknown, so the gap cannot be measured.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.947507531+00:00”}

description text 2147483647 null

{“what”:“Human-readable explanation of what the check verifies.”,“why”:“Without it, engineers lack context on the purpose of the check.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.965011637+00:00”}

auto_fixable bool 1 √ false

{“what”:“Whether the check can be automatically remediated, default false.”,“why”:“Without it, it is unknown which failures can be fixed automatically, blocking automation decisions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.989796967+00:00”}

Indexes

Constraint Name Type Sort Column(s)
ssh_compliance_results_pkey Primary key Asc id

Relationships