Alerting

How do you find hosts that are not sending specific EventIDs?

simpsobr345
New Member

I'm trying to search my log data and figure out if a list of host names are not sending specific event IDs.

I have a lookup table called audit_items.csv with the following: 4624 has data while 7777 purposely shows nothing.

EventID
4624
7777

My search looks like this.

| inputlookup audit_items.csv
| join type=outer EventID 
 [ search host="127.0.0.1:8088" 
 | stats count by EventID Hostname]
  | table Hostname, EventID count 
 | fillnull value=0 

What I would like to do is add another lookup table with a list of Hostnames so that instead of my results showing nothing for an EventID 7777 that it will also tell me each Hostname not sending each type of EventID.

Thanks

Tags (1)
0 Karma

renjith_nair
Legend

@simpsobr345 ,

Give this a try,

host="127.0.0.1:8088" | stats count by EventID Hostname|append [|inputlookup audit_items.csv] 
|eventstats values(Hostname) as Hostname
|stats values(Hostname) as tempHost,values(Hostname) as Hostname by EventID
|mvexpand Hostname|eval Found=mvfind(tempHost,Hostname)
|eval Found=if(isnull(Found),"No","Yes")|fields - Hostname
---
What goes around comes around. If it helps, hit it with Karma 🙂
0 Karma
Get Updates on the Splunk Community!

Prove Your Splunk Prowess at .conf25—No Prereqs Required!

Your Next Big Security Credential: No Prerequisites Needed We know you’ve got the skills, and now, earning the ...

Splunk Observability Cloud's AI Assistant in Action Series: Observability as Code

This is the sixth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...