Latest user update timestamp

[Community_User]

Originally posted on October 19 2020 at 06:44 UTC

Hello,

According to Saviynt Security Manager (SSM) Schema Guide UPDATEDATE field in USERS tables should specify the most recent data of updating user details in SSM.

UPDATEDATE

Specifies the most recent date of updating the user details in SSM.

But it seems that UPDATEDATE is not updated whenever user details are updated via a connection or via a CSV upload, even if updates are visible in update history.
What is the logic for updating UPDATEDATE field in USERS tables?
And furthermore, is there any other data in SSM that can be used reliably to query recent updated users.

[Community_User]

Originally posted on October 19 2020 at 08:14 UTC

Hi Juha,

The description for updatedate on documentation needs a correction. The updatedate column refers to the mapped date from the target system, this is used when we need to manage the updatedate for the user from the target.

SAVUPDATEDATE is the saviynt column where lastupdate date for the ssm is maintained.

Thanks

Ajay

[Community_User · Accepted solution]

Originally posted on October 19 2020 at 08:28 UTC

Thanks Ajay,

SAVUPDATEDATE seems to have the data I was looking for.

I think documentation on SAVUPDATEDATE needs updates too. Currently schema guide says that:

SAVUPDATEDATE

Specifies the date when the SAV role is assigned to the user.

Thanks,
Juha