ssh_auth_events


Description

{“what”:“One row per SSH authentication event, capturing attempt outcome and client details.”,“why”:“Without it, no audit trail for SSH access attempts, making intrusion detection and compliance reporting impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:23.625614782+00:00”}

Columns

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

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

timestamp timestamptz 35,6 null

{“what”:“UTC timestamp of when the SSH event occurred.”,“why”:“Without it, event ordering and time-based analysis (e.g., brute-force detection) are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:23.958689700+00:00”}

event_type text 2147483647 null

{“what”:“Outcome category such as ‘success’, ‘failed’, ‘timeout’.”,“why”:“Without it, cannot distinguish successful logins from failed attempts, hiding security breaches.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:23.974531127+00:00”}

source_ip text 2147483647 null

{“what”:“IP address of the client that initiated the SSH connection.”,“why”:“Without it, cannot identify attack sources or geolocate suspicious activity.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:23.991322241+00:00”}

username text 2147483647 √ null

{“what”:“Account name attempted or used in the SSH authentication.”,“why”:“Without it, cannot attribute events to specific users or detect username enumeration attacks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:24.003911525+00:00”}

auth_method text 2147483647 √ null

{“what”:“Authentication mechanism used, e.g., ‘password’, ‘publickey’.”,“why”:“Without it, cannot assess security posture or enforce policies on weak methods.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:24.033724340+00:00”}

key_fingerprint text 2147483647 √ null
ssh_key_inventory.fingerprint Implied Constraint R

{“what”:“SHA256 fingerprint of the SSH public key used, if any.”,“why”:“Without it, cannot track key-based access or revoke compromised keys.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:24.047465874+00:00”}

details text 2147483647 √ null

{“what”:“Free-form additional context such as error messages or client version.”,“why”:“Without it, diagnostic information for troubleshooting or forensic analysis is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:24.123038148+00:00”}

Indexes

Constraint Name Type Sort Column(s)
ssh_auth_events_pkey Primary key Asc id
idx_ssh_auth_source Performance Asc source_ip
idx_ssh_auth_ts Performance Asc timestamp

Relationships