I’m working on a NRQL alert query to notify via email when a SSL certificate is about to expire. Everything is working fine. The thing is when I want to include the
daysToExpiration attribute on the Custom Violation Description, the email will come with something like:
https://example.com_95 query result is < 100 on 'My Alert’
95 is the value of
daysToExpiration attribute. As you can see the link is broken because of the
_95 at the end of the url, this is how I currently receive the emails.
My NRQL query is the following:
SELECT latest(DaysToExpiration) FROM SSLCertificate facet Url, DaysToExpiration
Is there a way I can get the DaysToExpiration value on the email notification without screwing the URL?