Russell D said:
If you can work out how to get a numeric value out of it this could be feasible - the only requirement is that its a single, numeric or null value: https://documentation.red-gate.com/sm9/configuring-sql-monitor/creating-custom-metrics-and-alerts/step-1-define-metric.
Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal