From f0ef328db5fc34db87070dc83e3af9d382a74eed Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Wed, 13 Apr 2022 12:49:41 +0200
Subject: [statistics] Add PCI device filter option

---
 modules-available/statistics/pages/summary.inc.php | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'modules-available/statistics/pages/summary.inc.php')

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) {
-- 
cgit v1.2.3-55-g7522