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

Need to capture user attribute update on firstname ,lastname feilds.

Swetha
New Contributor III
New Contributor III

Hi All,

We have a requirement to capture the user attribute updates such as firstname , lastname ,title and department for disconnected applications and send the data to application team.

We don't have user history table in data analyzer, hence we tried with sql describe we are getting below error . 

Can anyone please suggest on this.

Swetha_0-1695302399361.png

Regards,

Swetha

3 REPLIES 3

smitg
Regular Contributor III
Regular Contributor III

Hi @Swetha 

User history table is not exposed in Data Analyzer. Create a analytics with below query
SELECT
u.username, u.firstname, u.lastname, uh.updatedate as 'Update Date', uh.changelog
FROM
users u
INNER JOIN
usershistory uh ON u.userkey = uh.userkey;

Reference: https://forums.saviynt.com/t5/identity-governance/get-user-update-history-via-api-database-schema/m-...

Thanks,
Smitha

Swetha
New Contributor III
New Contributor III

Hi Smita,

Thank you for the query and document , will go through this document.

Regards,

Swetha

Swetha
New Contributor III
New Contributor III

@smitg 

Is it possible we can get the column names from updatehistory table.

Regards,

Swetha