Splunk Search

How to search two strings and create a message in email body?

sandeepparcha44
Explorer

Hi Team,

I am trying to search <string1> and <String2> from different lines in same log having 100 lines, if both matched i want to show in result with _time, Sring1, String2. Please assist me.

Sample log is like below

... 66 lines omitted ...

Linexx

Linexx ]: "<string1>"

Linexx <string2>

 

Result should be link 

_time , String1 

Labels (3)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

If the 100 lines are all in the same event then a simple AND should do it.

index=foo "string1" "string2"
| eval string1="string1"
| table _time string1

The result will not be a link, however.

If the 100 lines are in separate events then correlating string1 and string2 requires something common to the two events.  What would that be?

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

sandeepparcha44
Explorer

Thank you for reply,

Sorry i missed one thing, Sting 1 is like "*(DC)_String1",  when it is showing result it show DC_String1. Is it possible.

Example like AZ_String1 or TX_String1 like this.

0 Karma

PickleRick
SplunkTrust
SplunkTrust

A side note - remember that searching for terms with a wildcard at the start is very inefficient.

0 Karma

yuanliu
SplunkTrust
SplunkTrust

It is possible only if you state the problem accurately.  Using the same formula as @richgalloway's,

index=foo "*_String1" "string2"
| rex "\b(?<dc_string>\w+_String1)\b"
| table _time dc_string

Based on your example, the above assumes that this (DC)_String1 is surrounded by word boundaries.

Tags (1)

sandeepparcha44
Explorer

Example like AZ_String1 or TX_String1 like this.

0 Karma

yuanliu
SplunkTrust
SplunkTrust

Then the above rex should give you that.

0 Karma
Get Updates on the Splunk Community!

Automatic Discovery Part 1: What is Automatic Discovery in Splunk Observability Cloud ...

If you’ve ever deployed a new database cluster, spun up a caching layer, or added a load balancer, you know it ...

Real-Time Fraud Detection: How Splunk Dashboards Protect Financial Institutions

Financial fraud isn't slowing down. If anything, it's getting more sophisticated. Account takeovers, credit ...

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...