Writing a powershell script to add users from a csv to a group in Active Directory?

Question

We are wanting to use a CSV file to bulk upload users to a certain security group. Some users in the CSV will already be in the group. Is there a good source to help write this powershell script?

Answer 1

Without writing the simple script for you that will do this, the script will follow the steps below.

Get the distinguishedName of the security group
for each user in the CSV
    Get the AD User and their memberOf property
    is the security groups' distinguished name in the users' memberOf property?
        do nothing, they're already a member
    if not
        add the user to the security group

If you have a problem with your script, post the script along with an explanation and any error message you receive.

Answer 2

Hi Elizabeth N. McClary,

The Import-Csv cmdlet can import the CSV file of the AD users to PowerShell and Add-ADGroupMember adds members to an AD group. Please refer to the help files below.

https://learn.microsoft.com/en-us/powershell/module/microsoft.Powershell.utility/import-csv

https://learn.microsoft.com/en-us/powershell/module/activedirectory/add-adgroupmember

Best Regards,

Ian Xue

---

If the Answer is helpful, please click "Accept Answer" and upvote it.