Script for searching AD and comparing Givenname.Surname to their Username and exporting any incorrect usernames to a CSV file.

Question

Script for searching AD and comparing Givenname.Surname to their Username and exporting any incorrect usernames to a CSV file.

Christopher Bliss 21

Hello!

I am fairly new to the scripting world and am currently having trouble building a script that can search AD and compare Givenname.Surname to their Username and exporting any incorrect usernames to a CSV file. I appreciate any help in advance. I already have a script that pulls names and compares them, but I am having trouble getting it to list what usernames are the incorrect ones. Thanks for the future help!

Chris

Rich Matheisen 47,901 Reputation points

2022-02-21T02:45:21.867+00:00
Post the script you have . . . or at least the part that gets the users, the properties, and does the comparison.

The code you want might look something like this:

Get-ADUser -Filter * | ForEach-Object{ if ("the names DO match"){ # do nothing } else{ # select the properties you want to export } } |Export-Csv . . .
Christopher Bliss 21 Reputation points

2022-02-21T15:09:12.657+00:00

The script is on a secure server so I can attempt to replicate it via memory.

$username = get-ADuser -Filter -Properties samAccountName
$lastname = get-ADuser -Filter -Properties Surname
$firstname = get-ADuser -Filter * -Properties Givenname

$Users = ($user = ($firstname.$lastname -eq $username))

ForEach ($user in $Users){
Export-Csv ‪C:\Users\iceni\Desktop\BOOK.csv

This may not be exactly the way it was worded but is very close. I apologize for the lack assistance that I provided but I do appreciate your continued support on this topic. Thanks!

Accepted answer

0 additional answers

Your answer

Rich Matheisen 47,901 Reputation points

2022-02-21T02:45:21.867+00:00

Post the script you have . . . or at least the part that gets the users, the properties, and does the comparison.

The code you want might look something like this:

Get-ADUser -Filter * | ForEach-Object{ if ("the names DO match"){ # do nothing } else{ # select the properties you want to export } } |Export-Csv . . .
Christopher Bliss 21 Reputation points

2022-02-21T15:09:12.657+00:00

The script is on a secure server so I can attempt to replicate it via memory.

$username = get-ADuser -Filter -Properties samAccountName
$lastname = get-ADuser -Filter -Properties Surname
$firstname = get-ADuser -Filter * -Properties Givenname

$Users = ($user = ($firstname.$lastname -eq $username))

ForEach ($user in $Users){
Export-Csv ‪C:\Users\iceni\Desktop\BOOK.csv

This may not be exactly the way it was worded but is very close. I apologize for the lack assistance that I provided but I do appreciate your continued support on this topic. Thanks!

Answer 1

Rich Matheisen 47,901

It's not clear if you want ALL users or just the ones that don't match. This code will show you all of them with a TRUE/FALSE column indicating a match or mismatch:

Get-ADUser -Filter * |
    ForEach-Object {
        [PSCustomObject]@{
            givenname = $_.givenname
            surname = $_.surname
            samaccountname = $_.samaccountname
            match = (("{0}.{1}" -f $_.givenname, $_.surname) -eq $_.samaccountname)
        }
    } | Export-Csv C:\Users\iceni\Desktop\BOOK.csv -NoTypeInformation

Christopher Bliss 21 Reputation points

2022-02-22T15:43:00.853+00:00

Perfect! Thanks!

Share via

Script for searching AD and comparing Givenname.Surname to their Username and exporting any incorrect usernames to a CSV file.

0 additional answers

Your answer