Pass Get-VBRBackupSession results to Function

[user0000001]

How to I pass the results of this command to an function?

Code: Select all

$body = Get-VBRBackupSession |select JobName, Name, Result, CreationTime, EndTime |  where { $_.EndTime -gt $b} | where { $_.Result -eq "Success"} 

Currently I get System.Object[] or Veeam.Backup.Core.CBackupSession.

My work around is to attach a csv file to the email but I want the results in the email.

Code: Select all

Function SendEmail($body)
{
     Write-Host "Sending Email" 


     #SMTP server name
     $smtpServer = "server"
 
     #Creating a Mail object
     $msg = new-object Net.Mail.MailMessage
 
     #Creating SMTP server object
     $smtp = new-object Net.Mail.SmtpClient($smtpServer)
 
     #Email structure 
     $msg.From = "veeamscript@email.com"
     #$msg.ReplyTo = "replyto@xxxx.com"
     $msg.To.Add("scripts@email.com")
     $msg.subject = "Veeam Successfull Jobs 1"
     $msg.Attachments.Add("C:\Users\user\Documents\Test1.csv")

     $msg.body = $body
    
     #Sending email 
     $smtp.Send($msg)
     }
#End Function 




#gets the past 24 hours
$a = (get-date).adddays(-1)
#put date in correct format
$b = $a.tostring("MM/dd/yyyy HH:mm tt")

#the veeam command
$body = Get-VBRBackupSession |select JobName, Name, Result, CreationTime, EndTime |  where { $_.EndTime -gt $b} | where { $_.Result -eq "Success"} 
#workaround
Get-VBRBackupSession |select JobName, Name, Result, CreationTime, EndTime |  where { $_.EndTime -gt $b} | where { $_.Result -eq "Success"} | Export-CSV Test1.csv -notype

SendEmail($body)

4

[nefes]

You can utilize Out-File cmdlet and use that file as email body:

Code: Select all

Get-VBRBackupSession |select JobName, Name, Result, CreationTime, EndTime |  where { $_.EndTime -gt $b} | where { $_.Result -eq "Success"} |Out-File "C:\body.txt"
$msg.body = Get-Content "C:\body.txt"

You could also format output before sending it to file, for example, with Format-Table or Format-List

[tsightler]

Or if you like the general format, a simple Out-String

Code: Select all

$body = Get-VBRBackupSession |select JobName, Name, Result, CreationTime, EndTime |  where { $_.EndTime -gt $b} | where { $_.Result -eq "Success"} | Out-String

[user0000001]

Thanks, both options works!

I like the out-string as it has better formatting.

Thanks!

Really Thanks!