I have tried all of the examples but am still not getting accurate results. I have a lookup table with (1) column only, a list of hostnames under the heading "name". I have an index that is the output of an internal scanner with an event field "dvc". I need a search that will be used on a regular basis to compare the lookup table and scan results with the output being those hostname that appear in the scan list, but not in index during a particular period of time.
The problem is, with the search below, I get inaccurate results. What I get is the first host listed in the lookup table (in the uploaded CSV) and nothing more. What I expected as output was a much longer list of "dvc" that existed in both the lookup table, and the index. When I manually validate I find many records in the lookup table that ARE in the index.
The host that does appear, is accurate, but am missing many others that should be there. I am suspicious the output is stopping after the first lookup table entry. I checked the spelling of all of my hostnames in both the lookup table and the index, focusing on those that should be appearing. Spelling is exactly the same, including case.
index=scanner dvc=* [|inputlookup test_lookup.csv | fields name | rename name AS dvc] earliest="02/01/2017:00:00:01" latest="02/02/2017:23:59:59"
| dedup dvc
| table dvc, _time
| sort dvc
... View more