Don't output hosts that aren't status 1 or that have address 'unassigned'.

diff --git a/gen/dhcp.pc b/gen/dhcp.pc
index ebdfba55a37664dc8f6006ecfd2b37586bce7258..2250a2eeb10bdbdcbc3496fac59b7685727783f6 100644 (file)
--- a/gen/dhcp.pc
+++ b/gen/dhcp.pc
@@ -96,6 +96,7 @@ int main(int argc, char **argv)
     FROM printers pr, machine m, machine m2
     WHERE pr.type != 'ALIAS' AND pr.mach_id != 0
     AND pr.mach_id = m.mach_id AND pr.loghost = m2.mach_id
+    AND m.status = 1 AND m.address != 'unassigned'
     ORDER BY m.hwaddr;
   EXEC SQL OPEN csr_boot;
   while (1)