Specify a "details" query for custom metric
When I define a custom metric it would be super-helpful to be able to see some details that gave rise to the metric value. For example, I have one for "count of failed SQL logins in the last 10 mins". But to find out which logins failed, I have to go run queries in SSMS.
I'd like to be able to define a "details" query on the custom metric, the results of which are captured at time of collection, and are then available from the alert.
This would indeed be useful. I think Asaf's solution would be good step forward while keeping it simple. 1st columns is the integer metric, 2nd column is the alert description string.
Guess the new idea "Be able to run a query (or powershell) in response to an alert" is also very similar to this. I vote for any topic about adding custom content to alerts. :-)
Thanks for your suggestion - I think this is related to another suggestion so am merging the two so votes will be added - I hope that makes sense.
Shay Saar commented
When creating a custom metric, we usually want to get some additional data from the server, related to the alert. This data is often just plain text.
This is really a must have.
Possible solution can be to allow second string column (in addition to the first scalar metric), so this string column value will be specified in the alert as the additional info.
Steven John Cuthill commented
agreed, its really unhelpful that we cant capture any log our output message here. its 1/2 useless.
Andrew Lackenby commented
Add the ability to display the results of a query when generating an alert from a custom metric