troubleshooting Question

Add users to security group from csv

Avatar of SAM IT
SAM IT asked on
Powershell
12 Comments1 Solution66 ViewsLast Modified:
Hi,
I tried the script, it adds the users which are in first line  in the CSV, however when I have users more than one, it gives the following error:

adding users to group "narasimha.s"
 - Cannot find an object with identity: '' under: 'DC=test,DC=local'.

CSV format:
Group                                                                      Samaccount
DL-WGK-US-Houston-Projects-XXXXXX-RW           Test102
                                                                              GG-WGP-US-test-Projects-XXXXXX-RO-TEST
                                                                              Narasimha.S



Import-Module ActiveDirectory
Import-Csv "C:\Users\a.narasimha.s\Desktop\Project folder creation\Adduserstogroup.txt" |
 ForEach `
 {
   $users = @($_.samAccount -split ",")
   $group = $_.group
   write-output "adding users to group ""$group"""
   #$users
   $users |
    ForEach `
    {
      try
      {
        $user = $_
        Add-ADGroupMember -Identity $group -Members $user
      }
      catch
      { Write-Output "$user - $($error[0].exception.message)" }
    }
 }
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros