Splunk Search
Highlighted

How can we only see results when they are NOT found?

Explorer

I have a large CSV lookup table operational and working well but would like to run a search on my data that only shows values that are NOT in the table. Any ideas?
If no result is found, the default is “Definition Not defined”.
Thank you

Tags (4)
0 Karma
Highlighted

Re: How can we only see results when they are NOT found?

SplunkTrust
SplunkTrust

Generally you could run a subsearch with your CSV lookup table to filter your indexed data (e.g. index=foo sourcetype=bar NOT [| inputlookup yourLookup.csv | table field1 field1.. | format]). With little information in the question about your lookup table, your indexed data search and their relationship, I would suggest give something like above a try. Providing more information in your question would yield you better suggestion from the community.

Highlighted

Re: How can we only see results when they are NOT found?

Explorer

After doing more research, what I really need is:
|stats count by Events |lookup EventList EC AS Events OUTPUTNEW Result AS MSG| (I only want MSG=Definition Not Defined)

0 Karma