Do you see anything wrong with this search? The subsearch returns results, however combined with the out search no results are returned. What am I missing?
index=sendmail qid=* [search eventtype=smimta_to to="email@example.com" | fields qid] | transaction
qid | table _time host qid from to subject
your subsearch returns the
qid field to the main search, but your subsearch does not have any index defined therefore my question are those needed fields all in the same index?
if so, you could do something like this and avoid a subsearch:
index=sendmail qid=* eventtype=smimta_to to="firstname.lastname@example.org" | ...