X-Git-Url: http://xvm.mit.edu/gitweb/invirt/scripts/outage.git/blobdiff_plain/4fe3c07bd07c1e63dd319fb82da63c2e4b624ede..348de4189eb1f11bfb885c0d3f081c93d3b1e71c:/invirt-deactivate

diff --git a/invirt-deactivate b/invirt-deactivate
index 2bfcb79..529d081 100644
--- a/invirt-deactivate
+++ b/invirt-deactivate
@@ -69,7 +69,8 @@ def main():
     database.session.commit()
 
     database.session.begin()
-    machines_no_access = database.session.query(database.Machine).filter(~database.Machine.acl.any()).all()
+    acl_locker_no_err = database.session.query(database.MachineAccess.machine_id).outerjoin(Locker, database.MachineAccess.user == Locker.name).filter((Locker.type == None) | (Locker.type != "ERR")).group_by(database.MachineAccess.machine_id).subquery()
+    machines_no_access = database.session.query(database.Machine).outerjoin(acl_locker_no_err).filter(acl_locker_no_err.c.machine_id == None).all()
 
     machines_no_locker = database.session.query(database.Machine).join(Locker, database.Machine.owner == Locker.name).filter(Locker.type == None).all()
     machines_err_locker = database.session.query(database.Machine, Locker.message).join(Locker, database.Machine.owner == Locker.name).filter(Locker.type == 'ERR').all()