diff options
author | Simon Rettberg | 2022-04-13 12:49:41 +0200 |
---|---|---|
committer | Simon Rettberg | 2022-04-13 12:49:41 +0200 |
commit | f0ef328db5fc34db87070dc83e3af9d382a74eed (patch) | |
tree | 659ddf697a91daf947b47f0eeda3627ce6929b9f /modules-available/statistics/pages/summary.inc.php | |
parent | [inc/Database] Force more sql_mode options in debug mode (diff) | |
download | slx-admin-f0ef328db5fc34db87070dc83e3af9d382a74eed.tar.gz slx-admin-f0ef328db5fc34db87070dc83e3af9d382a74eed.tar.xz slx-admin-f0ef328db5fc34db87070dc83e3af9d382a74eed.zip |
[statistics] Add PCI device filter option
Diffstat (limited to 'modules-available/statistics/pages/summary.inc.php')
-rw-r--r-- | modules-available/statistics/pages/summary.inc.php | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/modules-available/statistics/pages/summary.inc.php b/modules-available/statistics/pages/summary.inc.php index 4599b8b6..1adad7bd 100644 --- a/modules-available/statistics/pages/summary.inc.php +++ b/modules-available/statistics/pages/summary.inc.php @@ -247,8 +247,9 @@ class SubPage $filterSet->makeFragments($where, $join, $args); $args['cutoff'] = ceil(time() / 3600) * 3600 - 86400 * 10; - $res = Database::simpleQuery("SELECT machineuuid, clientip, hostname, firstseen, mbram, kvmstate, id44mb FROM machine m $join" - . " WHERE firstseen > :cutoff AND $where ORDER BY firstseen DESC LIMIT 32", $args); + $res = Database::simpleQuery("SELECT m.machineuuid, m.clientip, m.hostname, m.firstseen, m.mbram, m.kvmstate, m.id44mb + FROM machine m $join + WHERE firstseen > :cutoff AND $where ORDER BY firstseen DESC LIMIT 32", $args); $rows = array(); $count = 0; foreach ($res as $row) { |