Hi C_Sparn,
try something like this:
index=_internal sourcetype="splunkd" OR sourcetype="splunk_web_access"
| streamstats count by status, idx, sourcetype
| stats values(idx) AS idx, values(status) AS status, values(sourcetype) AS sourcetype
| mvexpand status
| eval Status = if(match(idx,status), "MATCH", "NO MATCH")
| table status, idx, Status
| where Status="NO MATCH"
Update: this is a run everywhere example of the final search used to get the expected result. streamstats hint came from a originally hint to use stats made by @somesoni2 🙂
hope this helps to get you started ...
cheers, MuS
... View more