Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Which table should I use to calculate agent login time? — 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

Which table should I use to calculate agent login time?

Received Response
1
Views
5
Comments
edited Oct 19, 2021 1:10PM in Reporting & Analytics for B2C Service 5 comments

Summary:

Do I need to develop a report that calculates the login / logout time and which table is the most correct to use?

accountsessionhistory or user_trans.type = 1?

And is it possible to combine with time calculations of incidents?

Thank you guys!

Version (include the version you are using, if applicable):

Latest

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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