X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/blobdiff_plain/c6556bcbc1f03e80fe894859e8c847f0268dd61d..727e75b77ed195a7568ed2bbd2f320b7ab83649b:/gen/nagios-cluster.gen 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;