Massive Alarm Actions configuration (Email notifications, SNMP traps or Run script) in Veeam Monitor

1.  Backup Veeam Monitor's database (default database name is VeeamOne);
 
2. Run the following script against VeeamOne database (feel free to use SQL Server Management Studio Express to do this):
 
                 Update monitor.Alarm Set actions = '<Actions>ACTION_TAG</Actions>'
 
                 ACTION_TAG might have the following values (depending on your needs):
 
                To send an email notification - <SendMail Value="receiver@domain.com"/>
 
                To send SNMP Trap to SNMP server - <SendTrap Value="SNMP_Server_Address"/>
 
                To run the script - <RunScript Value="Full_path_to_the_script"/>
 
                To clean the actions - just use no ACTION_TAG at all.
 
NOTE: Please keep in mind that you are allowed to use multiple ACTION_TAGs in order to have several actions to perform once the alarm has been triggered.
 
3. Restart “Veeam Data Collector Service” service.

1. Send email notifications to admin@company.net email address:
     Update monitor.Alarm Set actions = '<Actions><SendMail Value="admin@company.net"/></Actions>'
 
2.  Send SNMP Traps (make sure you have global SNMP settings configured properly):
      Update monitor.Alarm Set actions = '<Actions><SendTrap Value=""/></Actions>'
 
3.  Run Magic.bat file which is located in C:\scripts\ folder :
      Update monitor.Alarm Set actions = '<Actions><RunScript Value=" C:\scripts\Magic.bat"/></Actions>'
 
4.  Erase all predefined actions on all the alarms:
      Update monitor.Alarm Set actions = '<Actions></Actions>'
 
5.  Send email notification to admin@company.net and support@company.net email addresses:
      Update monitor.Alarm Set actions = '<Actions><SendMail Value="admin@company.net"/><SendMail     Value="support@company.net"/></Actions>'
 
6.  Send email notification to admin@company.net and run Magic.bat file which is located in C:\scripts\ folder:
     Update monitor.Alarm Set actions = '<Actions><SendMail Value="admin@company.net"/><RunScript Value=" C:\scripts\Magic.bat"/></Actions>'

1. either to disable any unwanted alarms before implementing this script (but this way the disabled alarms will not trigger at all);
2. or delete the "send e-mail" action from the alarm settings (on those alarm which you do not need to e-mail) after you run the query.