1

How add members into a group using a csv file

5 Spice ups
2

You’re leaving a lot of details up to my assumptions but here goes:

Get-ADGroup -Identity GroupName | Add-ADGroupMember -Members (Import-CSV .\test.csv | Select-Object -ExpandProperty name)
3 Spice ups
3

Indeed a lot of assumptions. We definitely need more information on what you are trying to accomplish before we can give a definitive answer.

4

Check this for some more advanced options when creating groups and members:

5

Wild guess you are trying to add users in active directory. I hope this helps out

Open Notepad and type the following lines. Each bullet is one line of text in Notepad but
do not include the bullets:

  1. Save the file to your Documents folder with the name “Importgroups.csv” including the
    quotes so that Notepad doesn’t add a .txt extension.

  2. Open a command prompt and type the following command:
    csvde -i -f “%userprofile%\importgroups.csv”

  3. Open the Active Directory Users And Computers snap-in and check to confirm that the
    groups were created successfully. You might need to refresh the view if the Active Direc-
    tory Users And Computers snap-in was open prior to performing the step.

6

Import-module ActiveDirectory
Import-CSV “C:\Scripts\Users.csv” | % {
Add-ADGroupMember -Identity TestGroup1 -Member $_.UserName
}

… or you can use a vendor tool that does all this for you. LOL

1 Spice up
7

Well, technically you just DID use a vendor tool to do it for you :wink:

4 Spice ups
8

Good point - since it is PowerShell, should should have added the standard "Use at your own risk" statement?

1 Spice up
9

We’re IT. Everything we do is “use at your own risk”. It goes with the job.

10

Is there a specific step I should be taking when running this in powershell because I receive an error stating this. Check the attached document

Capture2.PNG
Capture2.PNG1024×105 46.8 KB
11

Does your csv file have a UserName field?

12

yes

Capture3.PNG

13

Do you have any lines where that field is blank, or any blank lines at the end of the file (open it in notepad or something)?

14

This works fine but I realize that we are using display names. Would this work with those properties?

15

Nope, this is from the help file on what can be passed to that parameter:

Distinguished Name
  Example:  CN=SaraDavis,CN=Europe,CN=Users,DC=corp,DC=contoso,DC=com
GUID (objectGUID)
  Example: 599c3d2e-f72d-4d20-8a88-030d99495f20
Security Identifier (objectSid)
  Example: S-1-5-21-3165297888-301567370-576410423-1103
SAM Account Name (sAMAccountName)
  Example: saradavis
1 Spice up
16

But, it’s pretty easy to build a conversion hash table…

$hash = @{}
Get-ADUser -filter * | foreach {$hash.Add($_.Name,$_.SamAccountName)}

Then you can use $hash[$_.username] where ever you need the SamAccountName.