Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
05/29/2024 03:19 AM
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.
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?
05/29/2024 03:35 AM
@ybharadwaj319 below article help full
https://forums.saviynt.com/t5/identity-governance/user-history-table-columns/m-p/58985
05/29/2024 07:16 AM
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.
05/29/2024 05:26 AM
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
05/29/2024 07:18 AM
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.
05/29/2024 09:26 PM
I see this has been broken in v24.4
And working 24.5
07/15/2024 10:14 PM
I see like this in v24.5 and 24.7
How to see it in readable format? Is this a known issue?
07/15/2024 11:00 PM
working in both version
07/16/2024 12:51 AM
We recently migrated to v24.5 and still see this option not working.
I have raised a ticket with the support team, who are currently working with Engineering team.
I will keep this thread updated once resolved.
Regards,
Bharadwaj Y.
07/16/2024 09:17 PM
Validate sub version of release