]> andersk Git - moira.git/commitdiff
Don't tell nagios about deleted printers
authorjweiss <jweiss>
Thu, 12 Jul 2007 17:42:37 +0000 (17:42 +0000)
committerjweiss <jweiss>
Thu, 12 Jul 2007 17:42:37 +0000 (17:42 +0000)
gen/nagios-printers.gen

index 4c66cc913ffbb6b19e425b5ab0ab07895caecc73..88d3d656ea90756f0c44fdb0044c183ace1ba943 100755 (executable)
@@ -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;
This page took 0.101431 seconds and 5 git commands to generate.