Users whose department numbers have changed within the last month.

[JPMac]

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?

[Manu269]

Store and Read blob data from user update history ... - Saviynt Forums - 40660

[dgandhi]

Refer this if it helps:

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

[rushikeshvartak · Accepted solution]

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%'

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