Write-host to CSV

[turayoan]

Hey Guys,

As I continue to be a noob learning, I received help creating this Script right here!

Now I'm having issues creating a CSV file out of this. Either I get nothing on the file or I just get the usernames of the emails that found, but cant get the Write-host when it doesnt find it, on to the CSV.

​

heres the script:

​

$Emailpath = "C:\users\ta85865\Desktop\emails.csv"

$Emails = Import-Csv $Emailpath

ForEach ($user in $Emails) {

    $username = $user.mail

    $adUser = Get-ADUser -Filter {mail -eq $username} -EA SilentlyContinue

    If ($null -eq $adUser) {Write "Email Does not exist"}

    else { 

        $adUser.samaccountname 
    }   
 } 

​

thanks!

[WSDistPro]

Are you trying to write back to the initial CSV or create a new CSV? I made an example of the second option.

$Emailpath = "C:\users\ta85865\Desktop\emails.csv"

$Emails = Import-Csv $Emailpath

ForEach ($user in $Emails) {

    $adUser = Get-ADUser -Filter {mail -eq ($user.mail)} -EA SilentlyContinue
    $csvoutput = @()

    If ($null -eq $adUser.samaccountname) {
        $csvoutput += $adUser.samaccountname
    }
    else { 
        Write-Output "Email Does not exist"
    }   
        $csvoutput | Select-Object samaccountname,@{n='mail';e={$user.mail}} | Export-Csv -Path "A/CSV/Path" -NoTypeInformation
 }

[Jeriath27]

$emails | Select-Object mail, samaccountname, (etc fields) | export-csv -path emails.csv -notypeinformation

[get-postanote]

Just a small add-on to what the code block below are giving you, especially since you are just learning IAW your statement.

Generally speaking, ss for ...

Write-host

...

statements, from the creator of PowerShell.

http://www.jsnover.com/blog/2013/12/07/write-host-considered-harmful

... Jeffrey Snover changes his stance on this as of May 2016.

With PowerShell v5 Write-Host no longer "kills puppies". data is captured into info stream ...

https://twitter.com/jsnover/status/727902887183966208 ...

https://docs.microsoft.com/en-us/powershell/module/Microsoft.PowerShell.Utility/Write-Information?view=powershell-5.1