Getting Data In

Regex to extract for fqdn

jaydee12
Engager

Hi - Was looking for some assistance in extracting the FQDNs from the paths below:

/var/log/remote/ldap.inftech.net/2021-08-03/auth.log
/var/log/remote/web-proxy-01.int.inftech.net/2021-08-03/proxy.log
/var/log/remote/ns01.inftech.net/2021-08-03/named.log

Regex isn't my strongest area, and one of the domains has an additional level, which makes it that much harder for me.

Labels (2)
0 Karma
1 Solution

venkatasri
SplunkTrust
SplunkTrust

Hi @jaydee12 

try this,

 

<your_search_goes_here>
| rex field=<your_field_name> "var\/log\/remote\/(?<fqdn>.+?)\/"

 

View solution in original post

0 Karma

venkatasri
SplunkTrust
SplunkTrust

Hi @jaydee12 

try this,

 

<your_search_goes_here>
| rex field=<your_field_name> "var\/log\/remote\/(?<fqdn>.+?)\/"

 

0 Karma

jaydee12
Engager

HI @venkatasri  - Thanks for the quick reply.  No, I wasn't able to get that to work.  Basically what I am trying to do is extract the FQDN hostname so that I can use it in my input.conf file.

Similar to what this guy is doing:

https://community.splunk.com/t5/Getting-Data-In/Help-extracting-hostname-with-host-regex-from-path/m...

0 Karma

venkatasri
SplunkTrust
SplunkTrust

@jaydee12  Rex looks fine see below. commands before | rex for testing you shall replace with your own search.

venkatasri_0-1628041378654.png

 

0 Karma

jaydee12
Engager

Yes, you are correct...that did work,  Greatly appreciate your help!

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...