New comment on reddit

Now you need a join (most likely – it may be statsable … but my brain isn't gonna do that right now ?)

index=windows dstip=* Account_Name=* [| search index=firewall user=* dstip=* | stats count by dstip | fields dstip ] | stats count by dstip Account_Name | join dstip [| search search index=firewall user=* dstip=* | stats count by user dstip | fields - count ] | stats count by Account_Name user | fields - count 

July 22, 2020 at 12:22PM
via reddit https://www.reddit.com/r/Splunk/comments/hvvgge/how_to_show_results_from_both_the_main_search_and/fyvw0t6?utm_source=ifttt