Splunk Search

Create a report/alert to display hosts that are not reporting /var/log/secure

daniel333
Builder

All,

I have a list of PCI hosts. Now what I want to do is take that list of hosts and create a report/alert to display hosts which are not reporting /var/log/secure. Any idea how I might do this from a search?

0 Karma

lfedak_splunk
Splunk Employee
Splunk Employee

Hey @daniel333, if @somesoni2's solution worked then please don't forget to accept his answer to award karma points and close the question. 🙂

0 Karma

somesoni2
SplunkTrust
SplunkTrust

Assuming you can create a lookup table file with your list of hosts (say myhosts.csv with header as host), try like this

| tstats count WHERE index=IndexWhichHasSecurelogData source="/var/log/secure" [| inputlookup myhosts.csv | table host ] by host
| append [| inputlookup myhosts.csv | table host | eval count=0 ] | stats max(count) as count by host | where count=0
0 Karma
Get Updates on the Splunk Community!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

Splunk is officially part of Cisco

Revolutionizing how our customers build resilience across their entire digital footprint.   Splunk ...

Splunk APM & RUM | Planned Maintenance March 26 - March 28, 2024

There will be planned maintenance for Splunk APM and RUM between March 26, 2024 and March 28, 2024 as ...