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

[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 you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.