Login Report
Report of who has logged in
<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>
