This ask could have two interpretations. The simple one is extremely simple. Let me give you the formula first. | inputlookup pod_name_lookup where NOT
[search index=abc sourcetype=kubectl
...
See more...
This ask could have two interpretations. The simple one is extremely simple. Let me give you the formula first. | inputlookup pod_name_lookup where NOT
[search index=abc sourcetype=kubectl
| eval pod_name = mvindex(split(pod_name, "-"), 0)
| stats values(pod_name) as pod_name]
| stats dc(pod_name) as count values(pod_name) as pod_name by importance Your mock data will give you something like pod_name importance podc critical Now, my interpretations of your use case. First, I think your lookup table actually look like this, with pod_name as column name instead of pod_name_lookup. Is this correct? pod_name importance poda non-critical podb critical podc critical I call the lookup name "pod_name_lookup". Second, I interpret the "pod_name" column in the lookup table, mocked up as "poda", "podb", "podc", to be the first part of running pod names (mocked up as "poda-284489-cs834" and "podb-834hgv8-cn28s") that does not contain a dash. If this is not how the two names match, you will need to either make the transformation, or come up with more accurate mockups. Now, I am assuming that 'importance" in lookup and events match exactly. If you want to detect the discrepancies in "importance" as well, the search will be more complicated.