I have a search and subsearch that is working as required but there is a field in the subsearch that I want to display in the final table output but is not a field to be searched on. index=aruba sourcetype="aruba:stm" "*Denylist add*" OR "*Denylist del*"
| eval stuff=split(message," ")
| eval mac=mvindex(stuff,4)
| eval mac=substr(mac,1,17)
| eval denyListAction=mvindex(stuff,3)
| eval denyListAction= replace (denyListAction,":","")
| eval reason=mvindex(stuff,5,6) | search mac="*:*"
[ search index=main host=thestor Username="*adgunn*"
| dedup Client_Mac
| eval Client_Mac = "*" . replace(Client_Mac,"-",":") . "*"
| rename Client_Mac AS mac
| fields mac ]
| dedup mac,denyListAction,reason
| table _time,mac,denyListAction,reason What I want is for the value held in field Username to be included in the table command of the outer search. How do I pass it from the subsearch to be used in the table command and not used as part of the search? Thanks.
... View more