Hey thanks for the recommendation, streamstats really give me the "light bulb"
I was thinking this might work:
"search"| sort + Serial | streamstats window=2 global=f current=t first(complete) as next_com, first(serial) as next_serial | fields serial, complete, next_serial, next_com | eval test=if(complete > next_com, serial, 0) | fields serial, complete, test | eventstats max(test) as m_test | where complete == 0 | where (serial > m_test)
However I do not know is this an efficient search...
Comparing to using sub-search, will this be a faster search?
... View more