Splunk Search

Host Check-in to Sourcetype

itsmevic
Communicator

Hi,

We have a sourcetype type called "WinHostMon" and many hosts report into it.   Does anyone have any SPL laying around that would allow me to query the last time a host checked in with that particular Sourcetype? 
Tags (1)
0 Karma

woodcock
Esteemed Legend

Like this:

| tstats max(_indextime) AS time_event_was_indexed max(_time) AS time_event_happened WHERE index="*" AND sourcetype="WinHostMon" BY host
| sort 1 - time_event_was_indexed 
0 Karma

dindu
Contributor

Hi,

Try the below SPL.Modify based on your need.

|tstats count where  sourcetype=WinHostMon by host,_time,sourcetype
|table host,sourcetype,_time
|sort - _time  
|head 1
0 Karma
Get Updates on the Splunk Community!

This Week's Community Digest - Splunk Community Happenings [9.26.22]

Get the latest news and updates from the Splunk Community here! Upcoming User Group Events! 👏 Check ...

BSides Splunk 2022 - The Call for Papers is now Open!

TLDR; Main Site: https://bsidessplunk.com CFP Site: https://bsidessplunk.com/cfp CFP Opens: December 15th, ...

Sending Metrics to Splunk Enterprise With the OpenTelemetry Collector

This blog post is part of an ongoing series on OpenTelemetry. The OpenTelemetry project is the second largest ...