Splunk Search

Get percentage of matchin to all events

Simon
Contributor

Hi all

I think this will be easy for you guys but I have no clue at the moment 😉

My search is very simple:

sourcetype=access_combined | regex uri="\.(gif|jpg|jpeg|png)$"

With adding

| stats count(_raw)

I get the number of events matching my regex.
How can I get the percentage of events matching my regex to the total number of events of the base search

sourcetype=access_combined

?

Thanks,
Simon

0 Karma
1 Solution

ziegfried
Influencer
sourcetype=access_combined | eval request_type=if(match(uri, "\.(gif|jpe?g|png)"),"image", "other") | stats count(eval(request_type="image")) as image_requests count as total | eval img_pct=image_requests/total*100

or simplified:

sourcetype=access_combined | stats count(eval(match(uri, "\.(gif|jpe?g|png)"))) as image_requests count as total | eval img_pct=image_requests/total*100

View solution in original post

ziegfried
Influencer
sourcetype=access_combined | eval request_type=if(match(uri, "\.(gif|jpe?g|png)"),"image", "other") | stats count(eval(request_type="image")) as image_requests count as total | eval img_pct=image_requests/total*100

or simplified:

sourcetype=access_combined | stats count(eval(match(uri, "\.(gif|jpe?g|png)"))) as image_requests count as total | eval img_pct=image_requests/total*100

Simon
Contributor

Absolutely what I searched for - thanks a lot!

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...