You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Trying to show Last Login time for all active agents

Accepted answer
32
Views
5
Comments
edited Dec 13, 2011 11:41PM in Reporting & Analytics for B2C Service 5 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!