Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/26/2024 02:27 AM
I want to write a query to obtain users whose department number has changed within the last month using reporting.
However, the users table and user history table do not contain the information required for this condition.
How can I write a query to generate this report?
Solved! Go to Solution.
06/26/2024 03:30 AM
Store and Read blob data from user update history ... - Saviynt Forums - 40660
06/26/2024 09:49 AM
Refer this if it helps:
Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.
06/26/2024 10:52 AM
Use below query for your requirement
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%'