report samples/examples to detect movers with in eic?

[theosveg]

Hello community,

are there report samples, or examples available to detect movers? 

Movers are triggered when there is a change in departmentnumber on import

[rushikeshvartak]

• You need to maintain flag on user customproperty level with today days to report movers
• otherwise use usershistory for movers report
• https://forums.saviynt.com/t5/identity-governance/query-for-rule-triggered/m-p/114211#M76364
• https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter17-EIC-Analytics/Managing-An...

[Amit_Malik]

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;

[theosveg]

Select command denied for usershistory, is that normal?

[theosveg]

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 

[rushikeshvartak]

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