We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Logged in / Logged off

Accepted answer
44
Views
13
Comments
edited Feb 23, 2017 3:54PM in Reporting & Analytics for B2C Service 13 comments

Content

I've been asked to have a list of accounts that shows "logged in / logged off" for all accounts and then show the last time logged in (or off)

I got somewhat annoyed at it showing the two rows per account if I used the user_trans table and all I wanted to know out of say 100 people who was logged in, who was logged out. I moved to the account_session_history table and then got annoyed with the "max" command. Long story short I had to have a 2 next to Logged in and a 1 next to Logged Off to allow this to work as it seems that it's using a "max" on the logged in/ logged out and because "out" is after "in" alphabetically it throws a

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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