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.
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