Table name for termination timestamp from User Import job

[piyushm]

Hello,

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.

[Saathvik]

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.

[piyushm]

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.

[Saathvik]

what about updatedate? that value should go to either of these columns

[rushikeshvartak · Accepted solution]

select REFIREACTIONTRAIL,RULEACTIONFAILED,RULEACTIONSUCCESSFUL,RULEACTIONTOBEFIRED,RULERUNS,UPDATEDATE as date,UPDATEDBY,USERKEY,USERSHISTORYKEY from usershistory where userkey=1