Splunk Search

Omit/filter/exclude events from a transaction

pburkholder
New Member

When I do the following search

sourcetype="access*" [ search method="POST" |fields clientip | rename clientip as query ] | transaction clientip

I get transactions that include all the requests for .css, .js, .png, etc. I'd like to remove that clutter from the transactions. Being simple-mineded, I tried:

sourcetype="access*" [ search method="POST" |fields clientip | rename clientip as query ] | transaction clientip | regex url!="\.(png|css|js|ico)"

But that didn't help. How can I exclude stuff I don't want to see within a transaction?

Thanks -- Peter

Tags (2)
0 Karma
1 Solution

dwaddle
SplunkTrust
SplunkTrust

Hi Peter,

Filter it out before it gets into the transaction. Something like:

sourcetype="access*" [ search method="POST" |fields clientip | rename clientip as query ] 
NOT ( png OR css OR js OR ico) | transaction clientip

View solution in original post

0 Karma

dwaddle
SplunkTrust
SplunkTrust

If this resolved your issue, please 'accept' the answer by clicking on the outlined check-box to the left of it. Thanks!

0 Karma

pburkholder
New Member

Doh! Thanks!

0 Karma

dwaddle
SplunkTrust
SplunkTrust

Hi Peter,

Filter it out before it gets into the transaction. Something like:

sourcetype="access*" [ search method="POST" |fields clientip | rename clientip as query ] 
NOT ( png OR css OR js OR ico) | transaction clientip
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Event Series: Level up your SOC: Advancing with Splunk Enterprise Security

AI has fundamentally raised the stakes for security operations, and this three-part series is your guide to ...

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

SOC4Kafka - New Kafka Connector Powered by OpenTelemetry

The new SOC4Kafka connector, built on OpenTelemetry, enables the collection of Kafka messages and forwards ...