summaryrefslogtreecommitdiffstats
path: root/src/lib/Server/Plugins/Hostbase.py
diff options
context:
space:
mode:
Diffstat (limited to 'src/lib/Server/Plugins/Hostbase.py')
-rw-r--r--src/lib/Server/Plugins/Hostbase.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/lib/Server/Plugins/Hostbase.py b/src/lib/Server/Plugins/Hostbase.py
index 5639359c4..cd9d572b7 100644
--- a/src/lib/Server/Plugins/Hostbase.py
+++ b/src/lib/Server/Plugins/Hostbase.py
@@ -274,7 +274,7 @@ class Hostbase(Plugin):
SELECT hostname, mac_addr, ip_addr
FROM (hostbase_host h INNER JOIN hostbase_interface i ON h.id = i.host_id)
INNER JOIN hostbase_ip ip ON i.id = ip.interface_id
- WHERE h.dhcp=1 AND h.status='active' AND i.mac_addr <> ''
+ WHERE i.dhcp=1 AND h.status='active' AND i.mac_addr <> ''
AND i.mac_addr <> 'float' AND i.mac_addr <> 'unknown'
ORDER BY h.hostname, i.mac_addr
""")