send powershell script output by email

[eli_sorow]

Hi all,

i'm trying to send the output of a powershell script by mail.

here's the script : collect o365 unused licenses and send the result by mail

$licenses = Get-MsolAccountSku
foreach ($license in $licenses){
$UnusedUnits = $license.ActiveUnits - $license.ConsumedUnits
$output = "$($license.SkuPartNumber) has $unusedUnits unused licenses" | Out-String
}
Send-MailMessage -From sender@email.com -To receptient@email.com -Subject licenses_left -Body $output -SmtpServer 'smtp.office365.com' -Port '587' -UseSsl -Credential sender@email.com

it's working, i receive the mail except in the body i have only one line, the last result:

O365_BUSINESS  has -2 unused licenses

instead of something like :

TREAM has 999999 unused licenses
SPZA_IW has 9999 unused licenses
WINDOWS_STORE has 0 unused licenses
FLOW_FREE has 9829 unused licenses

O365_BUSINESS  has -2 unused licenses

anyone has an idea of what i'm doing wrong ?

thanks ll for your help

KR

Eli

[#2]

Well you are overwriting your $output variable on each iteration. Instead, you should add to it, or use a list, or whichever other method you prefer.

[#3]

@Vasil Michev 

thank you very much for your answer wich i m sorry is not obsvious for me.

i don't see how to add it instead.

i'm trying to keep this script simple without any file insertion.

thanks for your help

[#4 · Accepted solution]

You can do something like this:

$output = @()
$licenses = Get-MsolAccountSku
foreach ($license in $licenses){
$UnusedUnits = $license.ActiveUnits - $license.ConsumedUnits
$output += "$($license.SkuPartNumber) has $unusedUnits unused licenses"
}

[#5]

@Vasil Michev 

Hi,

the send-mailMessage comand doesn't like the "+" parameter in $output +=

and when i remove it , i have got the same result (only one line)

[#6]

You dont need to change that cmdlet, just replace the stuff I posted above.

[#7]

Oh wait, seems I forgot the stringify part... Replace it with

($output | Out-String)

[#8]

@Vasil Michev 

yes thx was already done but

because of the output syntaxt : $output +=  email is not sent

[#9]

Hi

@eli_sorow , as @Vasil Michev  wrote, copy his code and in the Send-Message cmdlet you will need to make this small change

-Body ($output | Out-String) instead of -Body $output 

[#10]

@farismalaeb @Vasil Michev 

it's working fine.

thank you both for your help and time, much appreciated!

KR

Eli

[#11]

@eli_sorow 

This is good 

Please Click on @Vasil Michev answer and Mark it as Best Response.

Thanks