Trying to show Last Login time for all active agents
Content
I'm working on trying to put together a report that shows me all active Staff Accounts as well as each Staff Account's Last Login time. The built-in report "Staff Accounts by Group" has everything I need except the login time, so I've made a copy of that to use. Adding in a column for "Last Login" was also easy enough, and seems to work -- at least for any staff accounts who actually have logged in.
Trouble I'm having is that it's only showing users who actually have logged in. I've configured the accounts => user_trans join to be an Outer join, yet it's still only returning me rows for Staff Accounts where a 'Login' event actually exists.
Tagged:
0