The Alarm Actions has a filter condition that can act as inclusive or exclusive.
Part A - Putting in a new script for blocking alert to display database name
5. Under severity description, paste over the existing script with the one below which will include the database name in the alarm message:
Session {{KEY_VALUE}} ({{SQLBlockingList.DBName}}) has been blocked by session {{SQLBlockingList.BlockedBySPID}} ({{SQLBlockingList.blockingdatabasename}}) for the last {{value}} seconds.
Part B - Setting up an Alarm Action to send email alerts for the databases that you want
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center