Imanami Community

I am attempting to create a SmartDL with all users who report to manager X. Rather than use the Managerial Dynasty which will give me the Manager and Sub managers I am looking for 1 and only 1 manager and all those that report to him/her.  I am using SmartDL 4.0 and am quering Actve Directory for the attribute Manager and using 'Starts With' "CN=Last\, First" and am getting nothing found.  If I place the entire DN in the field and use 'Is Exactly' I receive all those employees who have manager X in the Manager field.  To me this is a pretty important as I cannot see placing the entire DN in and then moving the manager account in AD 1 year later only to find that this DL no longer works because the DN of the manager has changed.

Hello rotondim,

At this time, using the Manager attribute with a value of the DN to the manager is how SmartDL handles a flat level group.  However, we do have a request for performing this function using the built in Managerial Dynasty.  It would be great if you could call the Imanami Client Services team and provide feedback on how you would like SmartDL to handle this function as well.  To contact Imanami Client Service, please call: 925-273-2909 or email: roger.manson@imanami.com.

Have a great day!

Thanks Roger.  I believe I have figured out a solution using an Imported SmartDL

We have an external source – currently a CSV file but in production it will be an Oracle DB.

The Source contains a row for each employee and has the employee number (emp_ID) along with his/her managers employee number (Mngr_ID)

In Active Directory we have the employee number in extensionAttribute2

I set up an Imported SmartDL and associate the key fields to be emp_ID and extensionAttribute2. I then modified the query on the database tab to be as follows:

Select [emp_ID] FROM [some_file.csv] WHERE Mngr_ID='AB123456' 

 

 

 

Hello rotondim,

Great work around.  Thank you for posting it.