Executing Powershell script everytime alert is triggered in Solarwinds?

itengineer

Hello there,

Using Orion Platform 2019.2 HF2, SAM 6.9.1

How can I execute the Powershell script and include the result into the email alert every time there is certain alert is triggered?

Get-ADComputer -Filter {name -Like "*${NodeName}*"} -Properties description | Select-Object Name, Description

Thank you in advance.

silverbacksays

Hi itengineer​

Orion can only include data from information that is available in the database at the time of the alert trigger. As you're currently looking to execute the PowerShell script and pull back the result AFTER the alert has triggered, you can't include that in the notification email.

One option is to run that script as a second component in the application template that you're getting the initial alert from. That way the information that you're looking for from the PowerShell script will be polled at the same time as what you're testing for in the alert, and it will allow you to put both component metrics in the body of the triggered alert, using the default 'Send and Email' trigger action.

Alternatively, you could write a larger script, which includes the sending of the intended notification within the script itself, and then use the' Execute External Program' trigger action to execute it, when the condition you are testing for in the alert is true.

With this option, you can use PowerOrion to pull back the alerting component metrics within the script using SWIS, allowing you to do what you're looking to achieve in combining the polled alert metrics, and the PowerShell commands you wanted to run subsequently, and using PowerShell to send the notification, knitting it all together, rather than Orion's 'Send an Email' action.

Details on PowerOrion can be found here:

PowerOrion A Module for PowerShell · solarwinds/OrionSDK Wiki · GitHub