Bulk add users in a specific AD group from Identity Manager application

Hello everyone, I have a requirement where I want to add more than 200 users in a specific AD group in bulk. 

In Identity Manager application, when I try to add members a popup appears to search a specific user but there is no option to select multiple users.

Is there a way to add 100+ users from Manager application via SQL or filter?

Regards,

Daniel

  • What version of Identity Manager are you using? You could use a business role that includes a dynamic role to include the multiple members if they have something in common like for instance the same department or job role.  That is also another way to do it, assign the group to a Cost Center, Department or Location if this is something that would be common for all of the members you want to add. For example, you have an IT Department which has group A assigned to it, this means that anyone that gets assigned this department would get that group.

  • Hi, we have Version 8.0 in Production. Thanks for valuable input. I wish there would be something in common but this is not the case. I have users from different departments and requirement is to add them in bulk (although I can do it manually one by one but provided the list is huge so its not a feasible approach).

    Is there a way to do it in bulk for users which don't have anything in common? I think this is a very common scenario in identity management where you have to add multiple uses in a group/role/ERP responsibility in one go. There should be some filter/ sql statement option in Manager tool on user selection page.

    Regards,

    Daniel

  • You could do an SQL Data Import.  you will have to prep the CSV file with the following columns.

    UID_ADSAccount, UID_ADSGroup

    UID_Value of User1, UID_Value of Group1

    UID_Value of User2, UID_Value of Group1

    UID_Value of User3, UID_Value of Group1

    Make both columns key columns.  Import in to table "ADSAccountinADSGroup"

    i have done this for bulk group membership updates.  This will solve your problem.

    Thanks,

    Jay

     

  • Hi, Thanks for your input. I'll definitely try this one!

    As of now I achieved the requirement via dynamic business role and linked that role with the required AD group and provided all users in the role condition.

    I am thinking of creating bulk AD groups by following your approach, is this doable using data import?

    Regards,

    Daniel

  • Yes, this is a data import process.  Once you have prepped the CSV file, you can import it via Data Import and map it to the appropriate table.