Hi Team,
I wants to add more information in alerts generated due to SQLDM. for example – if I got alert for session taking long CPU then I got below things in the alert building in email:
$(Timestamp), $(Metric) on $(Instance) and host $(Hostname) is $(Severity).
$(AlertText)
$(Metric): $(Description)
Where $(AlertText) replaced with information like “SQL Server instance xyz – Session 52 which logged in at 1/17/2018 7:11:00 AM has a cumulative CPU time of 125.611 seconds since login.”
What I want is “SQL Server instance xyz – Session 52, loginName abc from Application Server AppServerName which logged in at 1/17/2018 7:11:00 AM has a cumulative CPU time of 125.611 seconds since login.”
thank you!