Only active hosts, please.

[moira.git] / gen / nagios-colo.gen

diff --git a/gen/nagios-colo.gen b/gen/nagios-colo.gen
index 2c9780fe5a46b92fb92919c453ecb0bbe371fa81..1cc10fe689828524c994538cea701da64bf33174 100755 (executable)
--- a/gen/nagios-colo.gen
+++ b/gen/nagios-colo.gen
@@ -26,7 +26,7 @@ while (($root_list_id, $hostname) = $sth0->fetchrow_array) {
     print OUT "# This file is automatically generated by Moira.  Do not edit.\n";
     $sth = $dbh->prepare("SELECT m.name FROM machine m, imembers i " .
                         "WHERE i.list_id = " . $dbh->quote($root_list_id) .
-                        "AND i.member_type = 'MACHINE' " .
+                        "AND i.member_type = 'MACHINE' AND m.status = 1 " .
                         "AND i.member_id = m.mach_id AND i.direct = 1 ORDER BY m.name") 
        || exit $MR_DBMS_ERR;
     $sth->execute;