Get and add users to securoty group

Question

Trying add users with a specific details in the company field in AD to a security group and was not able to. Below is the script, any help?

#Retrieve a list of users with '123' in AD company field.

Get-aduser -Server (server name) -properties Company -Filter { enabled -eq $true -and company -like "Testing" } | select name, | Export-Csv C:\Temp\123.csv

$Users = Import-Csv "C:\Temp\123.csv"

foreach ($User in $Users) {

Add-ADGroupMember -Identity "123-Users" -Members $users }

Answer 1

Hello there,

I would suggest checking the CSV files and the data.

To specify the group and members we can use the following values:

-distinguished name
-objectGUID (GUID)
-objectSid (security identifier)
-SAMAccountName (Security Account Manager account name)

You can import CSV file in PowerShell scripts and load users in a local variable as below

#Import csv file and loads adusers in variable
$Users = Import-Csv -Path "C:\adusers.csv"
#Iterate AdUsers to add user account in Group
foreach($User in $Users){
        try
        {
            Add-ADGroupMember -Identity Finance -Members $User.User -ErrorAction Stop -Verbose
        }
        catch
        {
            Write-Host "Error while adding user to adgroup"
        }
    }

Hope this resolves your Query !!

--If the reply is helpful, please Upvote and Accept it as an answer–