Splunk Search

Combine RegEx with a condition

mkrauss1
Explorer

Assume the following squid log samples:

(squid-1): 1515606581.001 100 1.2.3.4 TCP_TUNNEL/200 500 CONNECT some.fqdn.com:443 - DIRECT/1.2.3.4
(squid-1): 1515606582.002 200 1.2.3.4 TCP_TUNNEL/200 2000 CONNECT some.fqdn.com:443 - DIRECT/1.2.3.4
(squid-1): 1515606583.003 200 1.2.3.4 TCP_TUNNEL/200 5000 CONNECT some.fqdn.com:443 - DIRECT/1.2.3.4

Example search with a regular expression to filter for TIME, SIZE and URL:

 squid-1  |rex field=_raw "squid-1\):\s+\d+\.\d+\s+(?<TIME>\d+).*TCP_TUNNEL\/200\s+(?<SIZE>.*)\s+CONNECT\s+(?<URL>.*)\:" 
|  top TIME,SIZE,URL

How can i set a condition for the size to list only for example SIZE>1000?

Many thanks

0 Karma
1 Solution

micahkemp
Champion

You would do that after using rex to extract the field:

  squid-1  |rex field=_raw "squid-1\):\s+\d+\.\d+\s+(?<TIME>\d+).*TCP_TUNNEL\/200\s+(?<SIZE>.*)\s+CONNECT\s+(?<URL>.*)\:"
 | search SIZE>1000
 |  top TIME,SIZE,URL

View solution in original post

0 Karma

mayurr98
Super Champion

hey try this

squid-1  |rex field=_raw "squid-1\):\s+\d+\.\d+\s+(?<TIME>\d+).*TCP_TUNNEL\/200\s+(?<SIZE>.*)\s+CONNECT\s+(?<URL>.*)\:" 
| where SIZE>1000  
|  top TIME,SIZE,URL

Let me know if this helps you!

0 Karma

micahkemp
Champion

You would do that after using rex to extract the field:

  squid-1  |rex field=_raw "squid-1\):\s+\d+\.\d+\s+(?<TIME>\d+).*TCP_TUNNEL\/200\s+(?<SIZE>.*)\s+CONNECT\s+(?<URL>.*)\:"
 | search SIZE>1000
 |  top TIME,SIZE,URL
0 Karma

mkrauss1
Explorer

Ah, it was the search command which was missing. THANK YOU!

0 Karma
Get Updates on the Splunk Community!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

Splunk is officially part of Cisco

Revolutionizing how our customers build resilience across their entire digital footprint.   Splunk ...

Splunk APM & RUM | Planned Maintenance March 26 - March 28, 2024

There will be planned maintenance for Splunk APM and RUM between March 26, 2024 and March 28, 2024 as ...