Help with error handling output to file for Get-ADUser

Question

The below works for me but I need to figure out how to get the output file to have the EMPID listed as bad if it is not found. These lists are sometimes created manually so I need to find out what line or the currently listed EMPID that is not found. Currently the script runs and gets me the information I need but it doesn't tell me if any of the EMPIDs were not found. I only know there is an issue because the output comes out a line or 2 short of what I expected.

Answer 1

Hi，

Please don't post your code as an image. You just need to test if the AD user exists

Import-Csv C:\Temp\EMPID.csv | ForEach-Object {  
    $user = Get-ADUser -Filter "EmployeeID -eq $($_.EmployeeID)"   
    $user | Select-Object Name, SamAccountName, UserPrincipalName          
    if(-not $user){  
        $_ |Export-Csv C:\temp\EmpIDnotfound.csv -Encoding UTF8 -NoTypeInformation -Append  
    }  
} | Export-Csv C:\temp\EmpIDresults.csv -Encoding UTF8 -NoTypeInformation  

Best Regards，
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

How about something like this?

Import-CSV C:\temp\empids.csv |
    ForEach-Object{
        $x = Get-ADUser -Filter "EmployeeID -eq $($_.EmployeeID)"
        if ($x){
            $x | Select-Object sAMAccountName, UserPrincipalName, EmployeeID
        }
        else{
            [PSCustomObject]@{
                sAMAccountName = "NotFound"
                UserPrincipalName = "NotFound"
                EmployeeID = $_.EmployeeID
            }
        }
    } | Export-CSV . . .