Instead of lookup you can use a search, but it's a limited check because you're not sure to check all IDs:
in this example I'm checking if the IDs of the last hour were present in the 24 hours before:
your_search earliest=-25h@h latest=-h@h
| stats count by ID
| append [
your_search earliest=-h@h latest=now
| dedup ID
| count=0
| table ID count ]
| stats sum(count) AS Total by ID
| where Total=0
If the problem is to manage the lookup, you could generate it automatically using a scheduled search (e.g. every hour or every night):
your_search earliest=-h@h latest=now
| dedup ID
| count=0
| table ID count
I usually prefer use the lookup.
Bye.
Giuseppe
... View more