Powershell script to find AD user with firstname and lastname

active-directorypowershell

I wrote a script to find users in AD using their firstname and lastname from a csv file.
When i execute the script, I dont get any output. Also no error…. Please help if any issues with the script.

Import-module ActiveDirectory
$users = Import-Csv -Path 'C:\Users\smishra\Desktop\list.csv'
$aduser = foreach ($user in $users)
{
$firstname = "$user.first"
$lastname = "$user.last"
Get-ADUser -Filter {GivenName -like $firstname -and Surname -like $lastname} -properties EmailAddress | select UserPrincipalName, EmailAddress
}
$aduser | Export-Csv user.csv -NoTypeInformation

Best Answer

Made a few of changes. 1. Declaration of Variables, removed quotes. 2. Get-AdUser command, changed "surname" to "SN". 3. Declared an array to contain the complete report with incremental addition.

Import-module ActiveDirectory 
$users = Import-Csv -Path 'file.csv' 
$CompleteReport=@()
foreach ($user in $users) {
    $firstname = $user.first
    $lastname = $user.last
    $aduser = Get-ADUser -Filter 'GivenName -eq $firstname -and sn -eq $lastname' -properties EmailAddress | select UserPrincipalName, EmailAddress
    $CompleteReport = $CompleteReport+$aduser
} 
$CompleteReport | Export-Csv user.csv -NoTypeInformation

Related Solutions

Windows – How to list all Active Directory Users and their group membership

Install the Quest CMDlets and then run this code:

Add-PSSnapin Quest.ActiveRoles.ADManagement
$memberships = @()

Get-QADGroup -SizeLimit 0 | Foreach-Object {
        $NameGroup = $_.Name
        Write-Host "Working with $NameGroup"
        $membership = Get-QADGroupMember $_.DN -Enabled -SizeLimit 0
        if ($membership -ne $null ) {
        $membership | Add-Member -type NoteProperty -name AuditGroupUserIsMemberOf -value $_.Name
        $memberships += $membership
        }
    }

$memberships | Select-Object AuditGroupUserIsMemberOf, NTAccountname | Export-Csv "GroupsWithUsers.csv"

This will give you a 1 record per group-user connection so expect multiple occurrences of users and groups. If you wan't other fields, you can just edit the Select-Object statement. Use $memberships | gm to see all the possibilities for the users. If you want more fields for the groups, use Get-QADGroup | gm, you will then need to add these by adding a new NoteProperty.

If you don't really care about more options, here is a one-liner you can just mash in the terminal:

Get-QADGroup -sizeLimit 0 | select @{name="Group";expression={$_.name}} -expand members | select Group,@{n='User';e={ (Get-QADObject $_).NTAccountName}} | Export-Csv "MyUsersAndGroups.csv"

Powershell – Getting AD username from first name and surname in CSV file

Add as the first line of your CSV file a row containing the column headers for your file. You then use those headers as the property names when iterating through the file.

So your file should look something like:

Firstname,Lastname
Joe,Schmoe
John,Doe
Jane,Doe

~~Then your code should work as is.~~

Also, the filter seems not to like $Name.lastname. I'm not sure exactly why, but even property expansion is not doing the trick. If you collapse this into a single string variable it work:

$names = Import-CSV C:\path\to.csv
ForEach ($Name in $Names)
{
    $nameFilter = $Name.Firstname
    Get-ADUser -Filter { GivenName -like $nameFilter }
}

Best Answer

Related Solutions

Windows – How to list all Active Directory Users and their group membership

Powershell – Getting AD username from first name and surname in CSV file

Related Topic