Hey @Splunkerninja, I used makeresults to get a statistical table as provided in the question. You can use the below query to identify a User that has ID to be "AD" and "AR9" | makeresults
| eval User="John", ID="AD"
| append
[| makeresults
| eval User="John", ID="AY9"]
| append
[| makeresults
| eval User="Riya", ID="AD"]
| append
[| makeresults
| eval User="Toby", ID="AR9"]
| append
[| makeresults
| eval User="Nathan", ID="AD"]
| append
[| makeresults
| eval User="Nathan", ID="AR9"]
| append
[| makeresults
| eval User="Sam", ID="AD"]
| append
[| makeresults
| eval User="Sam", ID="AR9"]
| fields - _time
| table User ID
| stats values(ID) as ID by User
| mvcombine ID delim=""
| eval match=if(match(ID,"AD AR9"),1,0)
| search match="1" Thanks, Tejas. --- If the above solution is helpful, an upvote is appreciated.
... View more