https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37919 Bug ID: 37919 Summary: Unable to report on MFA-enabled users Change sponsored?: --- Product: Koha Version: 23.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: david.roberts@ptfs-europe.com QA Contact: testopia@bugs.koha-community.org As a result of Bug 37508, it isn't possible to use the reports module to identify which users are MFA enabled using e.g. the following SQL which used to work: SELECT p.borrowernumber, p.firstname, p.surname, p.cardnumber, p.branchcode, IF( power(2, 2) & flags, 'yes', 'no' ) as Staff, IF( power(2, 0) & flags, 'yes', 'no' ) as Superlibrarian FROM borrowers p WHERE p.flags > 0 AND p.auth_method = 'password' AND p.dateexpiry > CURDATE() HAVING Staff = 'yes' OR Superlibrarian = 'yes' ORDER BY p.branchcode -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.