Splunk Search

How to search for a pattern in logs using regex or rex

srinivas0704
New Member

I have following lines in logs

1 ADM.ADMX policies
Found ADM/ADMX policies

How do I search to filter only 1 ADM/ADMX policies?

0 Karma

to4kawa
Ultra Champion

you can't do that, because there is not 1 ADM/ADMX policies

| makeresults
| eval _raw="1 ADM.ADMX policies
Found ADM/ADMX policies"
| multikv noheader=t 
| table _raw
| regex "\d*\sADM\.ADMX\spolicies"

We can't answer that because that's not what you're talking about in the question and comment.
Check the results of regex before saying there is no result of stats.

0 Karma

sanjeev543
Communicator

@srinivas0704 Could you try index=foo | regex _raw="1\s+ADM\.ADMX\spolicies" if you need to match with 1 ADM.ADMX policies literally but if you need to capture string with any digit at the start you can try with index=foo | regex _raw="\d\s+ADM\.ADMX\spolicies"

0 Karma

srinivas0704
New Member

@sanjeev543 regex _raw="\d\s+ADM\/ADMX\spolicies"| stats count but still count shows as 0

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Have you tried index=foo "ADM/ADMX" or index=foo | regex "ADM\/ADMX"?

---
If this reply helps you, Karma would be appreciated.
0 Karma

srinivas0704
New Member

Hi I have tried first one,my intention is to take line which starts from digit and has ADM/ADMX

0 Karma

richgalloway
SplunkTrust
SplunkTrust

OK. I misunderstood the question. Try \d\sADM\/ADMX.

---
If this reply helps you, Karma would be appreciated.
0 Karma

srinivas0704
New Member

@richgalloway Not a problem regex _raw="\d\s+ADM\/ADMX\spolicies"| stats count ,but still count shows as 0

0 Karma

richgalloway
SplunkTrust
SplunkTrust

There's a contradiction in what you want to find. Is it "1 ADM.ADMX policies" or "1 ADM/ADMX policies"? My latest response will find the latter. This should find the former: \d\sADM\.ADMX policies.

---
If this reply helps you, Karma would be appreciated.
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, ...