]> andersk Git - moira.git/commitdiff
select *unique* hostnames that are printers, since nagios doesn't like
authorjweiss <jweiss>
Wed, 17 Jun 2009 14:45:33 +0000 (14:45 +0000)
committerjweiss <jweiss>
Wed, 17 Jun 2009 14:45:33 +0000 (14:45 +0000)
seeing the same hostname appear twice.

gen/nagios-cluster.gen

index c283ba46adbef033dd57418cb4200a4cceb09542..b5253e33daa78b0288eef06b05cbe57ed28c5b49 100755 (executable)
@@ -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;
This page took 0.037095 seconds and 5 git commands to generate.