get sender email address

[masber]

Hi very simple question,

How could I get the sender email address from the Veeam global options/settings using powershell?

thanks

[tsightler]

I could be wrong, but I don't believe that any of the global server options are available via Powershell, however, you could probably get to that information directly from the SQL database. I believe that the "From Address" that you're looking for is stored in the "Options" table as an XML configuration, so something like this should work:

Code: Select all

$DBServer = "<SQL_Server>"  # Name of SQL Server hosting Veeam DB
$DBName = "VeeamBackup"  # Name of Veeam DB, default is VeeamBackup

# Setup SQL server connection
$SqlConn = New-Object System.Data.SqlClient.SqlConnection
$SqlConn.ConnectionString = "Server=$DBServer;Database=$DBName;Integrated Security=True"
$SqlConn.Open()
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.Connection = $SqlConn

# Grab XML options for job from SQL table, and get the From email address
$SqlCmd.CommandText = "select value from dbo.Options where name = 'email_notification'"
$MailFrom = ([xml]$SqlCmd.ExecuteScalar()).CMailOptions.From

# Close the SQL Connection
$SqlConn.Close()

# Write Mail From field to console
Write-Host $MailFrom