Comments
-
Apologies for the late reply, I was on leave. I scratched the alert, and created a PowerShell script that runs when the event is triggered. The script queries the database for the needed information, and automatically sends emails. Thank you @"adam.beedell" for your support & suggestions.
-
You're right, it does accept queries. My apologies. Although it appears that it does not accept string functions (replace, substring...). When I tried add the below query, it accepts. ${N=SWQL;M=SELECT TOP 1 Owner_Email FROM SolarWindsOrionDb.VIM_VirtualMachinesCustomProperties WHERE Name LIKE…
-
Hi Adam, Thank you for your input so far. Unfortunately, the "TO" does not accept queries. Only valid emails or variables. I have tried SQL & SWQL query variables, but it still won't accept. I'm thinking of trying to run PowerShell scripts from the alert but I'm worried about spamming. As each VM that is HA rebooted will…
-
So the event that I am capturing is as follows: vSphere HA restarted virtual machine <vm_name> on host <vshpere_host> in cluster <cluster_name> I'm using the below query to get the <vm_name> from the event message: ${SQL: SELECT SUBSTRING(replace('${N=OLM.AlertingMacros;M=OLMAlertMessage.EventMessage}','vSphere HA…
-
Hi Adam, Thank you for the reply. Can you tell me where to find the section in the DB that you mentioned? I'm kinda new SolarWinds.
