Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/17/2024 07:00 PM
Hi All,
In our implementation, saviynt generates few attribute values. HR wrongly sent us the bad data and now the values are updated and those values cant be reused by logic again.
I need to build a query to get the data from "update history" for those 2 attributes. Anyone has any query to do this?
09/17/2024 07:49 PM
Sample
select u.username, u.userkey, uh.changelog from users u inner join usershistory uh on u.userkey = uh.userkey where username = '137658'
and uh.UPDATEDATE >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) and changelog like '%departmentname%'
09/17/2024 07:56 PM
I tried this but I still see data in blob. We are on 24.5 version
09/17/2024 08:04 PM
Run report 2 times
09/17/2024 08:05 PM
sorry we are 24.4
09/17/2024 08:22 PM
Thanks - Running twice works....How can I filter with multiple attributes and only the last update?
09/17/2024 08:28 PM
select u.username, u.userkey, uh.changelog from users u inner join usershistory uh on u.userkey = uh.userkey where username = '137658'
and uh.UPDATEDATE >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) and (changelog like '%departmentname%' or changelog like '%customproperty1%')
09/17/2024 11:15 PM
Thanks @rushikeshvartak : Do you know if there is a way I can convert the blob data into a json?
09/18/2024 05:25 AM
https://codebeautify.org/online-json-editor/cbaea050
09/18/2024 08:42 PM
Thanks mate, not sure what I am missing but I get this error
09/18/2024 08:43 PM
and my query is
select changelog, userkey, updatedby from usershistory where UPDATEDATE >= '2024-09-16' and UPDATEDATE <= '2024-09-19' and changelog like '%customproperty11%'
09/18/2024 08:44 PM
Its not Blob data its array data what is expected output you need here ?
09/19/2024 05:38 PM
I get it now, We will just need to parse this array data and send it as part of our report.
Thanks for your help