The most common way to handle this is to use append instead. The following example uses eventstats. index=aruba sourcetype="aruba:stm" "*Denylist add*" OR "*Denylist del*"
| eval stuff=split(messag...
See more...
The most common way to handle this is to use append instead. The following example uses eventstats. 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)
| dedup mac,denyListAction,reason
| append
[ search index=main host=thestor Username="*adgunn*"
| dedup Client_Mac
| eval Client_Mac = "*" . replace(Client_Mac,"-",":") . "*"
| rename Client_Mac AS mac
| fields mac Username ]
| eventstats values(UserName) as UserName by mac
| where isnotnull(UserName)
| table _time,mac,denyListAction,reason,UserName