Files
Homelab-manager/server/drizzle/0067_shallow_mastermind.sql
bobbanandClaude Sonnet 5.5 5a2b320175 Dockhand vulnerability scans: warn about critical findings, with a setting to turn it off
Reads what Dockhand's scans have already stored (never starts one) every
15 minutes and raises a warning per Docker host with critical findings.
Unknown counts and stale readings are held, not treated as clean.
Settings -> Notifications has a switch (on by default); the Docker page
shows counts, scan coverage and the critical findings; /metrics and docs
updated.

Co-Authored-By: Claude Sonnet 5.5 <noreply@anthropic.com>
2026-10-25 22:34:06 +01:00

16 lines
498 B
SQL

CREATE TABLE `dockhand_vulnerabilities` (
`integration_id` integer NOT NULL,
`environment_id` integer NOT NULL,
`environment_name` text NOT NULL,
`critical` integer,
`high` integer,
`medium` integer,
`low` integer,
`images_scanned` integer,
`total_images` integer,
`findings` text DEFAULT '[]' NOT NULL,
`updated_at` text NOT NULL,
PRIMARY KEY(`integration_id`, `environment_id`),
FOREIGN KEY (`integration_id`) REFERENCES `integrations`(`id`) ON UPDATE no action ON DELETE cascade
);