Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

[Analytics]: ChangeLog from userHistory Table is not readable

KhaoulaD
New Contributor III
New Contributor III

Hello,

I'm trying to retrieve C information from CHANGELOG usershistory table to be able to check the source of a customproprerty that jas been emptyed. I'm suspecting a job but need to confirm it going through an analytics using the query below:

SELECT u.username,uh.CHANGELOG,uh.RULERUNS,uh.UPDATEDATE as date,uh.UPDATEDBY,uh.USERKEY,uh.USERSHISTORYKEY from usershistory uh left join users u on uh.userkey

When executing this query on V2 Analytics, the column CHANGELOG is encrypted and not readable.

 

Have you faced this issue before, Could you suggest a solution to make it clear?

 

Best Regards,

Khaoula DOUHI

2 REPLIES 2

naveenss
All-Star
All-Star

https://forums.saviynt.com/t5/saviynt-knowledge-base/store-and-read-blob-data-from-user-update-histo...

@KhaoulaD please refer to the above article.

 

Regards,
Naveen Sakleshpur
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

rushikeshvartak
All-Star
All-Star

This is issue till 24.4 and fixed in v24.5

Refer https://forums.saviynt.com/t5/identity-governance/usershistory-table-changelog-blob-data-is-not-read...


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.