help for retrieving events not found from a lookup list

[jip31]

Hello

I use the search below in order to display the list of HOSTNAME which have a SITE field that matches

| inputlookup lookup_cmdb 
| search HOSTNAME= aaa
    OR HOSTNAME= bbb
    OR HOSTNAME= ccc
    OR HOSTNAME= dddd
| stats values(SITE) as SITE by HOSTNAME
| table HOSTNAME

Instead the host which have a SITE field that matches, I would like to display the host list that have no SITE field

How to do please?

[ITWhisperer]

| inputlookup lookup_cmdb 
| search HOSTNAME= aaa
    OR HOSTNAME= bbb
    OR HOSTNAME= ccc
    OR HOSTNAME= dddd
| where isnull(SITE)

[jip31]

I have already tested it but like this I have no results......

[ITWhisperer]

| inputlookup lookup_cmdb 
| search HOSTNAME= aaa
    OR HOSTNAME= bbb
    OR HOSTNAME= ccc
    OR HOSTNAME= dddd
| where isnull(SITE) OR SITE=""

[jip31]

---

@ITWhisperer wrote:

| inputlookup lookup_cmdb 
| search HOSTNAME= aaa
    OR HOSTNAME= bbb
    OR HOSTNAME= ccc
    OR HOSTNAME= dddd
| where isnull(SITE) OR SITE=""

---

no results too...

[jip31]

| where isnotnull(SITE) works but not | where isnull(SITE)

[ITWhisperer · Accepted solution]

| inputlookup lookup_cmdb 
| search HOSTNAME= aaa
    OR HOSTNAME= bbb
    OR HOSTNAME= ccc
    OR HOSTNAME= dddd
| search NOT SITE="*"