List of User ID(s) With Last Logon Date & Time

[Former Member]

I need to have a list of E-sourcing user id(s) along with their last logon date and time.

I tried to find in the system but I couldn't find any, is there anyway I can pull those information out from the system?

Thanks.

[Former Member]

Solution found.

[Former Member]

After logging into the applicaton, navigate to Set Up > System Administration> Administrative Reports>User Activity

Please ensure that you have the correct access to run the report.

Also if you have access to the back end i.e. Oracle or DB2 database, run select query on the table name: FCI_UPP_USER_ACCOUNT. The column - DATE_LAST_LOGGEDIN should contain the value that you are looking for.

Regards,

Parankush

[Former Member]

Hi Parankush,

Thanks for the info on the User Activity report, I've found that earlier but then sadly that report didn't return the list of users but rather just the count. And the count is number of logon to the system, example if the same user logon to the system 5 times in a day, the counter will have 5.

Then I managed to enhance an existing Query in the system to pull out the last login date from the system. So I'm done with this task. Thanks a lot.