]> andersk Git - moira.git/commitdiff
Changes for also reporting IPM queues.
authorzacheiss <zacheiss>
Mon, 11 Dec 2000 22:04:18 +0000 (22:04 +0000)
committerzacheiss <zacheiss>
Mon, 11 Dec 2000 22:04:18 +0000 (22:04 +0000)
gen/sapprint.gen

index 6d6f73a5f41199ca934005554e9c3c6a5a0f9e49..7b2c0bbf4abd0748bbb0946cf2c842a9d274be7c 100755 (executable)
@@ -16,7 +16,7 @@ $dbh = DBI->connect("dbi:Oracle:moira", "moira", "moira")
 
 $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' OR p.type='IPM')")
   || exit $MR_DBMS_ERR;
 
 $sth->execute || exit $MR_DBMS_ERR;
This page took 0.10238 seconds and 5 git commands to generate.