Splunk Search

How to merge two regex in single query?

Rakzskull
Path Finder

I'd want to merge two regex strings into a single one; any suggestions would be greatly appreciated.

Reference Search Query -

index=* sourcetype=XYZ "<ABC2>" "<ABC1>"

| regex _raw="<ABC1>[^\x00-\x7F]"
| regex _raw="<ABC2>[^\x00-\x7F]"

Thanks in advance. 🙂

 

Labels (4)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

If you know the order of ABC1 and ABC2 and you only want events where both start with a character outside the range then you could try

index=* sourcetype=XYZ "<ABC2>" "<ABC1>"

| regex _raw="<ABC1>[^\x00-\x7F].+<ABC2>[^\x00-\x7F]"

If you need either order, you could try

index=* sourcetype=XYZ "<ABC2>" "<ABC1>"

| regex _raw="(<ABC1>[^\x00-\x7F].+<ABC2>[^\x00-\x7F]|<ABC2>[^\x00-\x7F].+<ABC1>[^\x00-\x7F])"

 Or if you want events where either start with a character outside the range

index=* sourcetype=XYZ "<ABC2>" "<ABC1>"

| regex _raw="(<ABC1>[^\x00-\x7F]|<ABC2>[^\x00-\x7F])"
0 Karma

PaulPanther
Motivator

Hello Rakzskull,

you can just combine two regex strings into one like everywhere else.

Easy example in your internal data would be 

index=_internal | regex _raw="^(\d{2,3}\.\d{1,3}\.\d{1,3}\.\d{1,3})\s-\s(splunk-system-user)"

 If it does not work like expected please provide some example data and your regex strings.

Thank you!

0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  &#x1f680; Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...