Splunk Search

How to extract a field that is within an already extracted field?

Path Finder

Hi Ninja

I've done a field extraction for apache access log like Referer.

Referer= http(s)://FQDN/Abc/dasd/sadfasf/

Now I am trying to get only FQDN from the referer but field extractions is not allowing me to do this since that FQDN is already in a field I extracted.

I want to create a table with count of unique FQDN

Application               Count
FQDN1                       4
FQDN2                       30


0 Karma

Esteemed Legend

Check out these great apps:

URL Parser: https://splunkbase.splunk.com/app/1545/
URL Toolbox: https://splunkbase.splunk.com/app/2734/
URL Expander (what is that tinyurl?): https://splunkbase.splunk.com/app/3460/

0 Karma


If you are happy to extract it in SPL (same regex can be used elsewhere like field extractor) then try to see if this works for you:

your base query to give field Referer
| rex field=Referer "https?:\/\/(?<FQDN>[^\/]+)\/.*"
| stats count by FQDN

See extraction here

Get Updates on the Splunk Community!

Build Scalable Security While Moving to Cloud - Guide From Clayton Homes

 Clayton Homes faced the increased challenge of strengthening their security posture as they went through ...

Mission Control | Explore the latest release of Splunk Mission Control (2.3)

We’re happy to announce the release of Mission Control 2.3 which includes several new and exciting features ...

Cloud Platform | Migrating your Splunk Cloud deployment to Python 3.7

Python 2.7, the last release of Python 2, reached End of Life back on January 1, 2020. As part of our larger ...