Splunk Search

Exclude events that do not occur each day from search

C4r7m4n
Path Finder

Hello

I have this search:

earliest=-7d@d latest=@d  source="/var/log/snmptrapfmt.log" (timeout_url="*.GE" OR timeout_url="*.tv" OR unavailable) AND NOT (timeout_url="*.com") | timechart count by timeout_url

and the result of this search is here: http://imageshack.us/photo/my-images/10/mollq.jpg/

Does somebody know how to remove/exclude from search events that do not occur in each day e.g. l(pink), w(dark green)

Tags (3)
0 Karma
1 Solution

kristian_kolb
Ultra Champion

Perhaps this will help you...

your_search | eventstats dc(date_wday) AS daysaweek by url | where daysaweek > 6

Perhaps...

/kristian

View solution in original post

0 Karma

kristian_kolb
Ultra Champion

Perhaps this will help you...

your_search | eventstats dc(date_wday) AS daysaweek by url | where daysaweek > 6

Perhaps...

/kristian

0 Karma

C4r7m4n
Path Finder

Thanks @kristian.kolb, it's working 😉

0 Karma
Get Updates on the Splunk Community!

Observability | How to Think About Instrumentation Overhead (White Paper)

Novice observability practitioners are often overly obsessed with performance. They might approach ...

Cloud Platform | Get Resiliency in the Cloud Event (Register Now!)

IDC Report: Enterprises Gain Higher Efficiency and Resiliency With Migration to Cloud  Today many enterprises ...

The Great Resilience Quest: 10th Leaderboard Update

The tenth leaderboard update (11.23-12.05) for The Great Resilience Quest is out >> As our brave ...