Powershell - Exporting data from powershell into a csv file using custom objects

This is sample code, since I'm not going to type out all that stuff again. And it isn't tested.

What you want, apparently, is to check there's an enabled AD user account that matches your userlist. For Powershell versions greater than 3.0, you can output [pscustomobject] directly into an array from a Foreach.

You just need ONE query to AD to determine if a user exists and whether the account is enabled ("Enabled" is one of the default properties returned in Get-AdUser).

It's probably more convenient for output if you simply have a "Verified" column and set that to TRUE or FALSE. Or you can have a "Status" column and output text to that like "Disabled" or "NotPresent" or "Verified". Whatever, really, I'm going with the easiest.

The try/catch is so you don't get a load of errors when the user doesn't exist. If you want to set different statuses for each "state", then you can place strings in there rather than $true/$false.

$employmentStatus = Foreach ($GID in $MyList) {
    $ID = $GID.SamAccountname
    try { 
        # if the user isn't found, it'll go to the Catch block after the next line
        $u = get-aduser $ID -erroraction stop
        if ($u.enabled) {
            $verified = $true
        }
        else {
            $verified = $false
        }
    }
    catch {
        # if the user doesn't exist, they're not verified
        $verified = $false
    }
    # output the per-user status as a pscustomobject in $employmentStatus
    [pscustomobject]@{
           ADUser = $ID
           Verified = $verified
    }
}

You should find that if you process your userlist with that, you can check the result with $employmentStatus | out-gridview.

That should show the "AdUser" and "Verified" columns, with TRUE or FALSE for each user.

If that looks OK, so will your CSV export: $employmentStatus | export-csv [path].

If you're using an old PS version, then you may need to predefine your output array as you did originally. Then you'd just fix up the line with the [pscustomobject] to append it to the array. Everything else works the same.

$employmentStatus = @()
Foreach ($GID in $MyList) {
...
    # output the per-user status as a pscustomobject - append to $employmentStatus
    $employmentStatus += [pscustomobject]@{
           ADUser = $ID
           Verified = $verified
    }
}