Hello;
Is it possible to add the trigger condition inside the alert message, any shape or form?
Thank you
Within the Edit alert interface, go to Trigger Actions
Double click on the "Send E-Mail/Page to email@email.com" This should bring up a screen that says Edit E-Mail/Page Actions.
Click on Message. You can alter the message presented there You can change it to fit your needs.
In the trigger action (email, log, whatever) include this:
AlertTrigger: ${SQL: select AlertDefinitions.TriggerQuery from AlertDefinitions where AlertDefinitions.AlertName = ${AlertName} }
That will embed the SQL for the alert query in your message. It won't be pretty, but it will be there in "any shape or form".
