Monitoring -> Service levels: a target (99.9 %) on an endpoint check, a server or an integration, measured over calendar months. Shows the figure, downtime used, the error budget left, and how the last six months went. 80 % of the budget used is a warning and an overspent budget a critical alert. Endpoints are measured day by day, servers and integrations to the minute from the audit log. The report page gains Quarter and Year (same figures, with a Service levels section), and two settings send the quarterly and annual report after the month that ends them. Co-Authored-By: Claude Sonnet 5.5 <noreply@anthropic.com>
11 lines
312 B
SQL
11 lines
312 B
SQL
CREATE TABLE `service_levels` (
|
|
`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
|
|
`name` text NOT NULL,
|
|
`subject_type` text NOT NULL,
|
|
`subject_id` integer NOT NULL,
|
|
`target` real NOT NULL,
|
|
`alert` integer DEFAULT true NOT NULL,
|
|
`created_by` text,
|
|
`created_at` text DEFAULT (current_timestamp) NOT NULL
|
|
);
|