Splunk Search

How to compare string values between two fields and only return results from the search that do not match?

kharma
New Member

So I currently have Windows event log (security) files and am attempting to compare two strings that are pulled out via the rex command (lets call them "oldlogin" and "newlogin")

Values of each variable are as follows:

oldlogin = ad.user.name
newlogin = user.name

What I am trying to do is to compare oldlogin and newlogin, and if they are both the same (minus the "ad.), then don't return them.

Unfortunately, I am rather new to Splunk and am not familiar with how to do this, so I will try to provide as much data as possible upon request.

0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

Perhaps something like this will help.

<your search> | eval matchname="ad.".newlogin | where oldlogin<>matchname | ...
---
If this reply helps you, Karma would be appreciated.

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

Perhaps something like this will help.

<your search> | eval matchname="ad.".newlogin | where oldlogin<>matchname | ...
---
If this reply helps you, Karma would be appreciated.

kharma
New Member

This worked perfectly thank you. I didn't realize that eval allowed you to do string additions.

0 Karma

MuS
SplunkTrust
SplunkTrust
0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...