Last login time

[snowuser111]

Hi Experts,

When I open 'My profile' i get the present login time i have logged in as 'last time logged in'.

What if I need the time stamp when I logged in last time.

Any idea please

Thanks

[Chuck Tomasi]

The last login field on the sys_user table only contains the information about a single more recent login. If you want a history, you would have to create a table and track that information yourself. If you didn't want to go that far, you might find information in the system's event log helpful. Search for the event 'login'. Example below.

[snowuser111]

Hi Chuck,

Thanks for that post.

So I can query that table and update the date time on to the last login time field under My profle.

Thanks

[Chuck Tomasi]

You can query the table to find previous logins. I don't understand the reason for modifying the value of the last_login field on the profile. If my last login was Tuesday, and the log said I logged in Tuesday, the previous Sunday, and Friday before that. I'd leave the profile at "Tuesday" because that was my last login. What's the reason for trying to modify the last_login field? It would help if I understood the underlying requirement or business use case you are trying to accomplish.

Thank you

[Bradley Pingel]

Can this history data been used to get the “most logged on user” for the past x months?