Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/17/2024 01:52 PM
Hello community,
are there report samples, or examples available to detect movers?
Movers are triggered when there is a change in departmentnumber on import
09/17/2024 02:06 PM - edited 09/17/2024 02:08 PM
09/17/2024 03:28 PM
1) using user update rule and sav for sav connector, update user customproperty with mover and date. Use that in report.
2) trigger user update rule to notify or do something else. And then use user history table to fetch that in query.
SELECT u.username FROM USERS U JOIN usershistory uh ON u.userkey = uh.userkey WHERE uh.ruleruns LIKE '%Mover Notification%' AND uh.updatedate >= CURDATE() - INTERVAL 7 DAY;
09/19/2024 07:25 AM
Select command denied for usershistory, is that normal?
09/19/2024 07:59 AM
okay I guess this only works with in analytics, is there way to read the change log? it looks like this and i would like to identify if possible the users old title, department, manager and new title, department and manager after change.?? @rushikeshvartak @Amit_Malik
09/19/2024 10:33 AM - edited 09/19/2024 10:35 AM
You need to use from analytics and run history only preview will not show BLOB data
https://docs.saviyntcloud.com/bundle/Release-Notes/page/Content/v24x/Release-Notes-24-8.htm
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%'
09/19/2024 11:48 AM - edited 09/19/2024 11:49 AM
thanks, my version is 24.5 additionally, is it possible to identify with users history or by other means, an users old attribute value and new attribute value?
09/19/2024 11:51 AM
No You need export and do excel manipulation