What's new in Customer Journeys?

Connect and learn more!
Trying to show Last Login time for all active agents — Cloud Customer Connect
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
edited Dec 13, 2011 11:41PM in Reporting & Analytics for B2C Service 5 comments


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.


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