Forum Discussion

Copper Contributor

Nov 25, 2020

Solved

send powershell script output by email

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 ($lic...

office 365

Windows PowerShell

VasilMichev
Nov 26, 2020
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"
}

VasilMichev

MVP

Nov 25, 2020

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.

eli_sorow

Copper Contributor

Nov 25, 2020

VasilMichev

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

VasilMichev
MVP
Nov 26, 2020
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"
}
- eli_sorow
  Copper Contributor
  Nov 26, 2020
  VasilMichev
  
  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)
  - VasilMichev
    MVP
    Nov 26, 2020
    You dont need to change that cmdlet, just replace the stuff I posted above.