I'm stumbing over subsearches.
In our system, app server logs contain an SID (session ID). It's trivial to find all (valid/known) SIDs for a given account with:
SID!=SID_UNKNOWN sourcetype=unicorn account="customer@example.com" | top SID | table SID
I can also break down the status codes easily:
sourcetype=unicorn HTTP_CODE>=400 | top HTTP_CODE
But I can't figure out how to put the two together using a subsearch. If I try:
sourcetype=unicorn HTTP_CODE>=400 | top HTTP_CODE [ SID!=SID_UNKNOWN sourcetype=unicorn account="customer@example.com" | top SID | table SID ]
I get:
Unknown search command 'sid'.
What am I missing here?
... View more