Splunk Search

help for retrieving events not found from a lookup list

jip31
Motivator

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?

Labels (1)
Tags (1)
0 Karma
1 Solution

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

View solution in original post

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

jip31
Motivator

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

0 Karma

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

jip31
Motivator

@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...

Tags (1)
0 Karma

jip31
Motivator

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

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| inputlookup lookup_cmdb 
| search HOSTNAME= aaa
    OR HOSTNAME= bbb
    OR HOSTNAME= ccc
    OR HOSTNAME= dddd
| search NOT SITE="*"
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

.conf25 Global Broadcast: Don’t Miss a Moment

Hello Splunkers, .conf25 is only a click away.  Not able to make it to .conf25 in person? No worries, you can ...

Observe and Secure All Apps with Splunk

 Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

What's New in Splunk Observability - August 2025

What's New We are excited to announce the latest enhancements to Splunk Observability Cloud as well as what is ...