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

[Swetha]

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.

Regards,

Swetha

[smitg]

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]

Hi Smita,

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

Regards,

Swetha

[Swetha]

@smitg 

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

Regards,

Swetha