Login Report

<report title="Login Report" description="Report of who has logged in" active="1">
<query>
select user_name, b_ExpireSet as `Date Exp Enabled` , date_ExpireDate as `Expire Date`, b_LocalLockSet as `Needs PIN for local` , b_RemoteLockSet as `Needs PIN for remote`, max(log.dateTime) as `last login` from security, log   where security.provider_no = log.provider_no  and log.content = 'login'  group by log.provider_no order by `last login` desc;</query>

</report>