[5148] in Moira
don't tell nagios about deleted printers
daemon@ATHENA.MIT.EDU (Jonathon Weiss)
Wed Jul 11 11:03:50 2007
Date: Wed, 11 Jul 2007 11:03:17 -0400
Message-Id: <200707111503.l6BF3HKE008275@distraction.mit.edu>
To: moiradev@MIT.EDU
From: Jonathon Weiss <jweiss@MIT.EDU>
Don't tell nagios about deleted, etc. printers.
Jonathon
Index: nagios-printers.gen
===================================================================
RCS file: /afs/athena.mit.edu/astaff/project/moiradev/repository/moira/gen/nagios-printers.gen,v
retrieving revision 1.1
diff -u -r1.1 nagios-printers.gen
--- nagios-printers.gen 31 Jan 2006 21:42:44 -0000 1.1
+++ nagios-printers.gen 11 Jul 2007 14:32:00 -0000
@@ -15,7 +15,7 @@
$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;
