Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Table name for termination timestamp from User Import job

piyushm
Regular Contributor II
Regular Contributor II

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.

piyushm_0-1673544633443.png

 

4 REPLIES 4

Saathvik
All-Star
All-Star

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.


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

piyushm
Regular Contributor II
Regular Contributor II

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.

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


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

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


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.