X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/blobdiff_plain/a1d1b4961792159c7eee2fe62ee12e877b74b468..0041862dcee4646f8bc7fea981e1fb7007cc066f:/gen/nagios-printers.gen

diff --git a/gen/nagios-printers.gen b/gen/nagios-printers.gen
index 4c66cc91..adb48d28 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;
@@ -33,6 +33,7 @@ define host{
 	host_name		$name
 	alias			$name
 	address			$name
+	contact_groups          ops-printers
 	use			generic-host
 	}
 
@@ -82,7 +83,6 @@ print OUT <<END;
 define hostgroup{
         hostgroup_name          printers
         alias                   printers
-        contact_groups          ops-printers
 END
 
 print OUT "\tmembers\t\t";