From 81a7b937f874493cff3b24627e4a3a73353e83b0 Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Thu, 21 Nov 2024 23:36:59 +0100 Subject: [PATCH] etc/dbq/data.php --- etc/dbq/data.php | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/etc/dbq/data.php b/etc/dbq/data.php index ce4524ee..3cf1eed2 100644 --- a/etc/dbq/data.php +++ b/etc/dbq/data.php @@ -67,7 +67,7 @@ $DBQ['data'] = [ } foreach ($row as $k=>$v) { - if (strpos($k,'updated') !== false) $row[$k] = preg_replace('/\..*$/','',$v); + if (strpos($k,'updated') !== false) $row[$k] = preg_replace('/:\d\d\..*$/','',$v); } }, ], @@ -98,7 +98,7 @@ $DBQ['data'] = [ foreach ($row as $k=>$v) { if (strpos($k,'updated') !== false) { - $row[$k] = preg_replace('/\..*$/','',$v); + $row[$k] = preg_replace('/:\d\d\..*$/','',$v); } } }, @@ -106,9 +106,9 @@ $DBQ['data'] = [ 'host_info_datas' => [ 'sql' => preg_replace('/[\t\r\n]/',''," SELECT host - ,REPLACE(key,'backup-datas.','') as key - ,val - ,updated + ,REPLACE(key,'backup-datas.','') as service + ,TO_CHAR(updated,'YYYY-MM-DD HH:MI') as updated + ,val as exit_code FROM host_info WHERE key LIKE 'backup-datas.%' ORDER BY updated DESC, host -- 2.47.3