Splunk Search

How to compare search results using csv as input containing two columns - and show difference (present and absent)

itsppp1234
New Member

I need to search using the input from csv and compare the results with the same csv containing two columns - and show the difference between them (accountname present and accountname absent)

eventcode=4768 contains Account_Name in NTID format

eventcode=4769 contains Account_Name in UPN format

index=<index_name> host=<host_list> EventCode=4768 OR EventCode=4769 [| inputlookup accountname.csv] | dedup Account_Name | table Account_Name, Ticket_Encryption_Type, Supplied_Realm_Name, Service_Name,Service_ID

how do I make the results from above query to show the difference?

Appreciate the help.

Thanks

Labels (1)
0 Karma

itsppp1234
New Member

Also, how do I get it to search for both EventCode above.

Currently, it is only searching for a 4768 or 4769 due to the change in the value format of Account_Name field.

0 Karma
Get Updates on the Splunk Community!

Build Scalable Security While Moving to Cloud - Guide From Clayton Homes

 Clayton Homes faced the increased challenge of strengthening their security posture as they went through ...

Mission Control | Explore the latest release of Splunk Mission Control (2.3)

We’re happy to announce the release of Mission Control 2.3 which includes several new and exciting features ...

Cloud Platform | Migrating your Splunk Cloud deployment to Python 3.7

Python 2.7, the last release of Python 2, reached End of Life back on January 1, 2020. As part of our larger ...