01-12-2023 09:31 AM
I am trying to figure out which table/column stores the timestamp when a user is terminated from user import job. I am specifically looking for the time that is shown on the update history tab on users page on UI.
Solved! Go to Solution.
01-12-2023 09:42 AM
if you are talking about update timestamp on user update history then that is stored in column savupdatedate of user table.
If you are talking about termination date that purely depends on how you implemented your termination logic.
01-12-2023 09:47 AM
Termination is implemented through User Import. But the timestamp in the screenshot which is when the user was terminated, is not matching with the savupdatedate value in users table.
01-12-2023 09:50 AM
01-12-2023 09:54 AM
select REFIREACTIONTRAIL,RULEACTIONFAILED,RULEACTIONSUCCESSFUL,RULEACTIONTOBEFIRED,RULERUNS,UPDATEDATE as date,UPDATEDBY,USERKEY,USERSHISTORYKEY from usershistory where userkey=1