Extract a list of leaver managers from IdentityNow who have active subordinates

Is it possible to retrieve a list of leaver managers from IdentityNow who have active subordinates through a search query or another method?

Hi @Aishwarya1008 ! Welcome to the SailPoint Developer Community!

I would utilize a workflow in this case, you could create a trigger that detects a change in the Lifecycle State to inactive (or the specific LCS you’ve set for leaver), then use an HTTP request to do a search for anyone that has that user’s DN as their managerDN and send an email with the results.

1 Like

There’s not a single query that will fulfill all of your criteria, but you can use the following search query to get inactive managers.

isManager:true AND attributes.cloudLifecycleState:active

If you want to check if they have active subordinates, you would need a script that can loop through each manager returned by the search query and run another search query to see if there are any employees under that manager.

manager.id:2c9180837dfe6949017e208e26b27b28 AND attributes.cloudLifecycleState:active

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.