When we choose to send an email as an alert action in Splunk, is there a way for Splunk to take the oldest ServiceNow incident in the alert results and link to it or at least provide it's info (e.g., incident number) in the email it sends out with the alert?
Alerts can be configured to include the results in the email. Make that query include the oldest incident and you're all set.
Thank you @richgalloway ! This helps so much! I can include the oldest incident in the query, but if it's included as a result, it will affect the alert triggering because I'm triggering based on a number of results. What should I do?