[1866] in Moira Commits
/svn/moira r4010 - trunk/moira/gen
daemon@ATHENA.MIT.EDU (Garry Zacheiss)
Mon Jun 28 10:49:10 2010
Date: Mon, 28 Jun 2010 10:49:04 -0400
From: Garry Zacheiss <zacheiss@MIT.EDU>
Message-Id: <201006281449.o5SEn4mJ024758@drugstore.mit.edu>
To: moira-commits@mit.edu
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Author: zacheiss
Date: 2010-06-28 10:49:04 -0400 (Mon, 28 Jun 2010)
New Revision: 4010
Modified:
trunk/moira/gen/sapprint.gen
Log:
Don't include printers that aren't active.
Modified: trunk/moira/gen/sapprint.gen
===================================================================
--- trunk/moira/gen/sapprint.gen 2010-06-22 05:50:47 UTC (rev 4009)
+++ trunk/moira/gen/sapprint.gen 2010-06-28 14:49:04 UTC (rev 4010)
@@ -16,7 +16,7 @@
$sth = $dbh->prepare("SELECT p.name, p.hwtype, p.location, p.duplexname, p.rp, m.name ".
"FROM printers p, machine m ".
- "WHERE p.rm=m.mach_id AND p.type='SAP'")
+ "WHERE p.rm=m.mach_id AND p.type='SAP' AND m.status !=3 AND p.status = 1")
|| exit $MR_DBMS_ERR;
$sth->execute || exit $MR_DBMS_ERR;
