Splunk Enterprise

Bar Chart Alert

michaelsplunk1
Path Finder

Hi all!

I would like to set an alert on a bar chart. The bar chart shows the number of service desk tickets per each device.

How can I alert when one of these bars increases by five tickets within five minutes?

This is the query that produces the bar chart:

index=sample_index
| stats dc(ticket_number) by device_name 
| head 15

 

Thank you!

Labels (3)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Try something like this as the basis for your alert

index=sample_index
| bin _time span=1m
| stats dc(ticket_number) as tickets by _time device_name 
| streamstats time_window=5m earliest(tickets) as previous_tickets by device_name
| eval diff=tickets-previous_tickets
| where diff>4

This uses a rolling 5 minute window in case your increase happens across a 5 minute boundary 

0 Karma
Get Updates on the Splunk Community!

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...

Security Highlights | January 2023 Newsletter

January 2023 Splunk Security Essentials (SSE) 3.7.0 ReleaseThe free Splunk Security Essentials (SSE) 3.7.0 app ...

Platform Highlights | January 2023 Newsletter

 January 2023Peace on Earth and Peace of Mind With Business ResilienceAll organizations can start the new year ...