Changeset 42923 for trunk/ippMonitor/raw/storage.php

Timestamp:

Sep 11, 2025, 12:59:29 PM (8 months ago)

Author:

cclin33

Message:

update czartool

File:

• trunk/ippMonitor/raw/storage.php (modified) (1 diff)

trunk/ippMonitor/raw/storage.php

@@ -58 +58 @@
     exec("neb-host |cut -b 17-30,86-", $hostnoteall);
 
-    $sql = "SELECT host, format(total, 2), format(available, 2), format(used, 2), writable, readable, format(used/total*100,3) as ratio FROM hosts where xattr <> 3 ORDER BY CASE WHEN ROUND(used/total*100,3) = 100 THEN 0 ELSE 1 END, CASE WHEN host LIKE '%\_bck.0' THEN 1 ELSE 0 END, host;";
+    $sql = "SELECT host, format(total, 2), format(available, 2), format(used, 2), writable, readable, format(used/total*100,3) as ratio FROM hosts where xattr <> 3 ORDER BY CASE WHEN ROUND(used/total*100,3) = 100 THEN 0 ELSE 1 END, xattr, host;";
     $qry = $db->query($sql);