Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/29/2024 01:35 AM
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
05/29/2024 03:56 AM
@KhaoulaD please refer to the above article.
05/29/2024 11:03 PM
This is issue till 24.4 and fixed in v24.5