Numbers of hours user login and log out time in report, How can i configure this?

[Gulshan Kumar1]

How can I run a report on the number of hours a person logged into UAT?  Not just the time tracked working a ticket but overall using the system?

[Ankur Bawiskar]

@Gulshan Kumar1 

difficult to track that.

you can use event log table and see when the person logged in and when person logged out.

for every login and logout an event gets triggered in event logs table

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Gulshan Kumar1]

Hi ,

   I am unable to find your mentioned table(sysevent_list) in Report please check once again.

Thanks.

[Ankur Bawiskar]

@Gulshan Kumar1 

that table is not available directly for reporting.

you cannot directly determine the hours from that table

[mattystern]

Hi @Gulshan Kumar1

Not 100% sure this will meet your requirements, but you can check System Logs > Transactions (All users) [table syslog_transaction] and group it by "Created By" to see sessions. This will not necessarily help with getting exact counts - if a user is on a record for 10 minutes, this log will only log one record and in reverse if a user is mindlessly clicking around, it will log multiple session records. 

I've found in the many projects I do that people will either do proper UAT or just simple not log into the system. Thus, I've found we can reliably use the above in combination with "Last Logon Time" on the sys_user table to cross-check user activities. 

There may be other, better solutions than the one outlined above. Good luck!

-Matt