From b06dd0d35f2d85a00d3204b5383b865ba8548faf Mon Sep 17 00:00:00 2001
From: jweiss <jweiss>
Date: Thu, 12 Jul 2007 17:42:37 +0000
Subject: [PATCH] Don't tell nagios about deleted printers

---
 gen/nagios-printers.gen | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/gen/nagios-printers.gen b/gen/nagios-printers.gen
index 4c66cc91..88d3d656 100755
--- a/gen/nagios-printers.gen
+++ b/gen/nagios-printers.gen
@@ -15,7 +15,7 @@ $dbh = DBI->connect("dbi:Oracle:moira", "moira", "moira")
 
 $sth = $dbh->prepare("SELECT m.name FROM machine m, printers p " .
 		     "WHERE (p.type = 'DORM' OR p.type ='CLUSTER') " .
-		     "AND p.mach_id = m.mach_id")
+		     "AND p.mach_id = m.mach_id AND m.status=1")
     || exit $MR_DBMS_ERR;
 
 $sth->execute || exit $MR_DBMS_ERR;
-- 
2.45.2