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

Usershistory table Changelog - Blob data is not readable

ybharadwaj319
New Contributor
New Contributor

Hi Everyone,

We are on version 24.3 and are trying to fetch the changelog column data from the usershistory table.

As per the below document, I see that this column should be retrieved in human-readable format, but we are still seeing this in BLOB format.

https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter17-EIC-Analytics/Managing-An...

I tried with both SQL query and Runtime analytics as well, but it is not working on both.

Anyone of you are aware if this needs any separate config turned on or should we raise a FD ticket with Saviynt?

5 REPLIES 5

Hi @Raghu,

Thanks for responding, but I referred these forum posts before posting my query.

I see it has worked for them but none of it explains what can be done if it is not returning the data in human readable format.

Regards,

Bharadwaj Y.

PremMahadikar
Valued Contributor
Valued Contributor

Hi @ybharadwaj319 ,

Can you try passing the below query:

Using SQL Query: (Run it twice)

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

 OR 

Runtime Analytics: (Run it twice)

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 and u.username=${username}

 

Both the queries are working fine (24.5). What I noticed is, the first run didn't display correct data, the second run did. Probably try running twice.

 

If this helps, please select Accept As Solution and hit Kudos

Hi @PremMahadikar,

I tried multiple times but still I see the data is being returned in BLOB format.

When you say it didn't display correct data on first run, was it still reporting it in BLOB format for you?

If so, was anything done different before trying it the next time?

Regards,

Bharadwaj Y.

I see this has been broken in v24.4

rushikeshvartak_3-1717043194514.png

 

And working 24.5 

rushikeshvartak_2-1717043150035.png

 

 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.