How to get a report on user update history with Change log in text format - 5.5SP3.13

[SugandhaVarma1]

Hello Techies,

We are trying to fetch list of user's attributes (eg. Location , dept, owner etc) that were changed on a specified date using Userhistory table. 

We tried fetching the result using below query:

select changelog,userkey,updatedby,RULERUNS from usershistory where userkey in (select userkey from users where username like 'XXXXXXXXX') and CAST(UPDATEDATE AS Datetime) >= '2022-10-19 06:49:53.840'

but unable to get the result in desired format. 

Below is the result when we tried the query from data analyzer.

If we use above query in Analytics:

If i try to convert the data into text format(UTF8) below is the screen from Analytics:

I want the result in below format:

Any suggestions how this can be achieved.

regards,

Sugandha

[smithamg]

Hi @SugandhaVarma1 ,

We had similar requirement. Below is the forum discussion I started for the same. 

https://forums.saviynt.com/t5/identity-governance/how-to-fetch-user-update-data/td-p/36147

Let me know if this helped you.

Thanks,
Smitha