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

[kharma]

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.

[richgalloway · Accepted solution]

Perhaps something like this will help.

<your search> | eval matchname="ad.".newlogin | where oldlogin<>matchname | ...

[kharma]

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

[MuS]

and eval can do even more, see the docs http://docs.splunk.com/Documentation/Splunk/6.2.6/SearchReference/Eval