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

Usershistory - Changelog - Blob data is not readable

Alex
Regular Contributor
Regular Contributor

Hi, 
based on the documentation and some forum threads, the blob data should be readable with version 2022 and higher. https://docs.saviyntcloud.com/bundle/EIC-Admin-v2022x/page/Content/Chapter17-EIC-Analytics/Generatin...

Still we facing issues:
Version: 23.5
Report:
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 = u.userkey where username = '${username}'
Result:

Alex_0-1694101484345.png

Is there some known issue or I'm missing something?
Thanks

2 REPLIES 2

adriencosson
Valued Contributor
Valued Contributor

Hi @Alex ,

I tried the same on a 23.5 environment with a simple Select Query (without the "${username}" dynamic attribute and it is working fine :

adriencosson_0-1694114159774.png

Can you let us know if this work without your dynamic attribute ?

Otherwise I would suggest you to get in touch with support team and open a FD ticket.

Regards,
Adrien COSSON

Alex
Regular Contributor
Regular Contributor

Hi @adriencosson,
found the issue. The issue was not related to the dynamicattribute. It is related to the report type:
- SQL Query => it is working
- Runtime Analytics => no working

Based on the doc, it should work for every type of analytic, which is not the case. I assume I should created an FD ticket for this to receive a fix in the future.

BR
Alex