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)