The Detail Contain rule of Alarm Action will search for keywords in the Description field of the alarm. Locks – Blocked Processes alarm as default has this description: “Session {{KEY_VALUE}} has been blocked by session {{SQLBlockingList.BlockedBySPID}} for the last {{value}} seconds.” which does not contain any information about the query statement causing the deadlock. However, keywords used in your Detail Contain condition were in the causing query statement.
Add following variable in this alarm Description field to include causing query statement:
1. Open Configure | Alarms window and select Locks – Blocked Process alarm (either as default for all connections or specific ones).
2. On the right side under Description column of each enable Severity add this value somewhere inside description:
{{SQLBlockingList.blocking_sql_text}}
Note: SQLBlockingList is the procedure used to raise this alarm and blocking_sql_text one is parameters
3. Hit OK in Alarms windows
