From 7638264b21c2a29022dce60d7e9ef8e0e624645c Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Mon, 4 Nov 2024 08:24:23 +0100 Subject: [PATCH] lib/postgres/host_report.sql --- lib/postgres/host_report.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/postgres/host_report.sql b/lib/postgres/host_report.sql index 5ad12afe..364af909 100644 --- a/lib/postgres/host_report.sql +++ b/lib/postgres/host_report.sql @@ -10,7 +10,7 @@ CREATE VIEW host_report AS ,(SELECT MAX(hb.val) FROM host_info hb WHERE hb.key LIKE CONCAT('backup_servers.',hi.host,'.files_transfer')) as backup_files FROM host_info hi GROUP BY host -ORDER BY git_updated DESC,backup_updated DESC,host +ORDER BY backup_updated DESC,git_updated DESC,host ; GRANT ALL PRIVILEGES ON host_report TO nico; GRANT ALL PRIVILEGES ON host_report TO icolas; -- 2.47.3