Splunk Search

InputLookup - find unique values across 4 fields

brdr
Contributor

I have a lookup file that contain 4 fields (field1, field2, field3, field4) which contains an account number. Same account number can exist across the different fields as well as unique account numbers in these fields. I need a search that provides a count of unique account numbers across the 4 fields (and as a separate list of events).

0 Karma

somesoni2
Revered Legend

Try this

| inputlookup yourlookup.csv | table field1 field2 field2 field4 | eval temp=1
| untable temp field AccountNumber
| stats dc(AccountNumber) as UniqueAccountNumbers
0 Karma

brdr
Contributor

Nice. Will try it out. Thanks.

0 Karma
Get Updates on the Splunk Community!

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...

From Alert to Resolution: How Splunk Observability Helps SREs Navigate Critical ...

It's 3:17 AM, and your phone buzzes with an urgent alert. Wire transfer processing times have spiked, and ...