Hi meenal901
given your lookup table is like this:
my_name, my_description
foo_name, this is used for logging
get the entries from the lookup table first, filter it based on which host you are seeing in the system logs. Let's say your lookup table is called my_lookup.csv , the relevant logs have sourcetype my_systemlogs and that the field my_name exists in those log events. In that case, this search should get you going:
| inputlookup my_lookup.csv | search NOT [search sourcetype="my_systemlogs" | dedup my_name | fields my_name]
hope this helps or gets you starting to find the result you're looking for
cheers,
MuS
... View more