PowerShell CSV Not Exporting Missing Active Directory Objects

Question

previously I tried to make a powershell script to compared asset tags from a text files with computer names in AD, that was successful. However, when an asset isn't found in AD it just skips through that line and moves on to the next. The asset that cannot be found is not exported into the CSV file.

Is there a way to get it to print in the CSV file the missing Asset, along with a message like "Asset not found" next to the asset tag? I tried using this line but all that does is add spaces in between the lines.

if ($_.samaccountname -notlike "*$line*") {"Asset does not exist in AD"}

Code:

Import-Module ActiveDirectory

   [Array]$Collection = foreach($line in Get-Content H:\AssetNames.txt)  {
        Get-ADComputer -Filter * -Property Description | Where {$_.samaccountname -Like "*$line*"} | Select Name, Description
        #if ($_.samaccountname -notlike "*$line*") {"Asset does not exist in AD"}
    }

$Collection | Export-Csv C:\test.csv -NoTypeInformation

Query AD and Export to CSV comes up all the time. There's enough in the combination of these to do all the things you want ... stackoverflow.com/q/25789067/478656 and stackoverflow.com/q/22303219/478656 and stackoverflow.com/q/4381943/478656 and stackoverflow.com/q/40930461/478656 and stackoverflow.com/q/19164485/478656 and stackoverflow.com/q/36292356/478656 and stackoverflow.com/q/38407983/478656 and stackoverflow.com/q/41573219/478656 — TessellatingHeckler
– TessellatingHeckler, Commented Mar 17, 2017 at 2:28

Mark Wragg · Accepted Answer · 2017-03-20 08:55:21Z

0

Your issue is that you are excluding Assets that don't match in your Get-ADComputer filter, so then you have no way of knowing when they haven't matched. If you do this to a variable, then you can check:

Import-Module ActiveDirectory

   [Array]$Collection = foreach($line in Get-Content H:\AssetNames.txt)  {
        $Match = Get-ADComputer -Filter * -Property Description | Where {$_.samaccountname -Like "*$line*"} | Select Name, Description
        if (!$Match) {
            "Asset $($_.samaccountname) does not exist in AD" | Out-File -FilePath "ErrorLog.txt" -Append
        } else {
            Write-Output $Match
        }
    }

$Collection | Export-Csv C:\test.csv -NoTypeInformation

edited Mar 20, 2017 at 8:55

answered Mar 17, 2017 at 6:22

Mark Wragg

23.6k7 gold badges48 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

ilovetaufu Over a year ago

Hey Mark, sorry for the late response. Just tried this but the write-output isn't writing the missing assets into the CSV file, any assets that can't be found in AD is replaced by an empty line in the CSV file.

Mark Wragg Over a year ago

Try removing the [array] part.

ilovetaufu Over a year ago

Tried that, it is still the same. If I let it write to a separate text file the missing assets do show up in that text file however.

Collectives™ on Stack Overflow

PowerShell CSV Not Exporting Missing Active Directory Objects

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related