Splunk Search

Organizing-Filtering URL results

wrays
New Member

host=server sourcetype=iis #Software NOT #Fields NOT /favicon.ico
(method=GET OR method=POST) NOT eventtype="web-imagefile"
| fillnull
| stats count first(_time) last(_time) by user,src_ip,uri_stem

I am trying to approach organizing/filtering the uri_stem results to return just the information that seems useful. I see functions for eval and command but am not sure of the best way to approach.

Thanks!

Tags (1)
0 Karma

yannK
Splunk Employee
Splunk Employee

Hint : You may need to use rex field extractions functions or eval functions (like case) to filter your uri_stem and normalize them.
see http://docs.splunk.com/Documentation/Splunk/6.0/SearchReference/Rex

If you want help, please provide a sample and a clear idea of the expected result.

0 Karma

yannK
Splunk Employee
Splunk Employee

to see them
uri_stem=*/fraud*"

to exclude them
NOT uri_stem=*/fraud*"

0 Karma

wrays
New Member

/fraudintro.html
/fraudmenu.htm
/fraudpost.asp
/fraudview.asp

Out of the results I am getting in the uri_stem column, I would like to learn the ability to either see just these result or completely exclude them.

0 Karma
Get Updates on the Splunk Community!

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...