From: jweiss <jweiss>
Date: Wed, 17 Jun 2009 14:45:33 +0000 (+0000)
Subject: select *unique* hostnames that are printers, since nagios doesn't like
X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/commitdiff_plain/727e75b77ed195a7568ed2bbd2f320b7ab83649b

select *unique* hostnames that are printers, since nagios doesn't like
seeing the same hostname appear twice.
---

diff --git a/gen/nagios-cluster.gen b/gen/nagios-cluster.gen
index c283ba46..b5253e33 100755
--- a/gen/nagios-cluster.gen
+++ b/gen/nagios-cluster.gen
@@ -97,7 +97,7 @@ END
 
 print OUT "\n### Printers\n\n";
 
-$sth0 = $dbh->prepare("SELECT m.name FROM machine m, printers p " .
+$sth0 = $dbh->prepare("SELECT UNIQUE m.name FROM machine m, printers p " .
 		     "WHERE (p.type = 'DORM' OR p.type ='CLUSTER') " .
 		     "AND p.mach_id = m.mach_id AND m.status=1")
     || exit $MR_DBMS_ERR;