Splunk Search

need help or ideas on how to check status of server within the hour

owie6466
Explorer

still a newbie, need help or ideas on how to check the status of a server if it's changed or stayed the same within the hour. here's an example of the status of a server. alt text

0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

You may be able to do that with the stats command.

... | stats latest(ClusStatus) as lastState, dc(ClusStatus) as statuses by host
| eval changed = if(statuses>1, "Yes", "No")
| table host lastState changed
---
If this reply helps you, Karma would be appreciated.

View solution in original post

0 Karma

sphiwee
Communicator

how do you get the up/down status? what query are you using?

0 Karma

richgalloway
SplunkTrust
SplunkTrust

You may be able to do that with the stats command.

... | stats latest(ClusStatus) as lastState, dc(ClusStatus) as statuses by host
| eval changed = if(statuses>1, "Yes", "No")
| table host lastState changed
---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Introducing Ingest Actions: Filter, Mask, Route, Repeat

WATCH NOW Ingest Actions (IA) is the best new way to easily filter, mask and route your data in Splunk® ...

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...