Hi! I want to display column “Last User Login” to IR(on that report I use database table) and display date and time for this column. Is there an apex table to track user logins? If exist, could I display this column on existing IR? Thanks in advance!
Share
There is no such existing table from which you can get the login details. But you can create one and log the details as follows: Create a table, for example:
Now in the login page (9999), create a process after Login to insert the user login date and time:
Then you would be able to show the last user login column in any report.
Thanks a lot Vinish! But, how can I add source of login_datetime column on existing IR?
I assume that your interactive report based on any table must have the user_id column.
Then you should join the user_id column to get the last login date and time. For example:
This way, you can get the last_login_datetime column in your IR report.
Let me know if any queries.
Thank you!
I thought I had to add a source outside the sql query 🙂