Hi @atebysandwich I'm not 100% sure I understand what you are trying to do but does this run anywhere example help... | makeresults
| eval _raw="DNS,Identified_Host
host1.domain.com,host1.domain...
See more...
Hi @atebysandwich I'm not 100% sure I understand what you are trying to do but does this run anywhere example help... | makeresults
| eval _raw="DNS,Identified_Host
host1.domain.com,host1.domain.com
host1-admin.domain.com,host1.domain.com
host1-mgt.domain.com,host1.domain.com
host2.domain.com,host2.domain.com
host2-admin.com,host2.domain.com
host2-mgt.admin.com,host2.domain.com
host3.domain.com,host3.domain.com
host3-admin.com,host3.domain.com"
| multikv forceheader=1
| table DNS Identified_Host
```^^^ dummy events ^^^```
| where DNS!=Identified_Host
| stats values(DNS) BY Identified_Host