From 727e75b77ed195a7568ed2bbd2f320b7ab83649b Mon Sep 17 00:00:00 2001 From: jweiss Date: Wed, 17 Jun 2009 14:45:33 +0000 Subject: [PATCH] select *unique* hostnames that are printers, since nagios doesn't like seeing the same hostname appear twice. --- gen/nagios-cluster.gen | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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; -- 2.45.1