Hi @PickleRick Thanks for the help - again 🙂 I do believe it's not working because of this: "Streamed search execute failed" The reason is: lookup output is streaming and it can not be the input for anomaly command. In the search logs i can see: 03-18-2025 17:14:39.482 INFO SearchPhaseGenerator [1439947 searchOrchestrator] - Optimized Search =| search (userid!=null earliest=-1d index=data sourcetype=mydata) | where match(ip,"^\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}$") | lookup maxmind_lookup ip OUTPUT country, region, city | anomalies threshold=0.0001 by field1, field2, ip
03-18-2025 17:14:39.482 INFO ScopedTimer [1439947 searchOrchestrator] - search.optimize 0.001056652
03-18-2025 17:14:39.482 INFO FederatedInfo [1439947 searchOrchestrator] - No federated search providers defined.
03-18-2025 17:14:39.482 INFO PhaseNodeGenerationVisitor [1439947 searchOrchestrator] - FallBackReason: Fallback to 2-phase mode because of empty split key of cmd: anomalies The search fails immediately, its not even really executed. I've tried with CHAT GPT to change the output from lookup for it to be in non-streaming format, but failed (it's not trivial since my lookup is external, not csv file). Still trying to find the right query. Thanks, Michal
... View more