Is there a wiki or some document that I can use to help construct the messages that get emailed as an Alert Response?For example, the initial is as follows:Subject: SQLDM Alert ($(Severity)) - $(AlertSummary) on $(Instance)
Message:
$(Timestamp), $(Metric) on $(Instance) and host $(Hostname) is $(Severity).
$(AlertText)
I would like to see what else I can add in order to make the messages the most useful.
I'm not entirely sure what you are asking for. However, you should be able to update the subject and body of the email as you see fit. You can, additionally, leverage the usage of the built-in variables for the email as well. You can access those variables from the "arrow" icon on the far right of the screen.
Note that you may have to experiment with some alerts to see what kind of data is provided with each one of these variables. Some metrics, for example, will not have any value for the "Database" variable.
Are those the only variables available? Or are there more that are not part of the menu?
As far as I am aware, those are the only variables that are available. If you have some suggestions on variables that should be added, I would submit those suggestions to the feature request section of the community at https://community.idera.com/database-tools/monitoring--performance/i/feature-requests.
Thanks for the info.