Splunk Search

how to iterate a column's values like python in command?

cyberportnoc
Explorer

"daily.cld" | rex field=_raw "version: (?\d+.)," | rex field=_raw "sigs: (?\d+.)," | convert timeformat="%Y-%m-%d" ctime(_time) AS date | table source, date, version, sigs | where date=strftime(now(), "%Y-%m-%d")

is there a command like python to find missing server log file?

input a correct full list of name ["name1", "name2", "name3"]
and compare with the columns values , to find which name in full list not in the values of columns of search table

Tags (1)
0 Karma
1 Solution

gcusello
SplunkTrust
SplunkTrust

Hi cyberportnoc,

create a lookup with all your servers (e.g. perimeter.csv) calling column host and possibly using only uppercase (not mandatory)
run this search:

your search
| eval host=upper(host)
| stats count by host
| append [ | inputlookup perimeter.csv | eval host=upper(host), count=0 | fields host count ]
| stats sum(count) AS Total by host
| where Total = 0

In this way you listed all missing hosts.
without the last condition (where Total=0) you have the status of all your servers that you can display in a dashboard also in graphic mode.

Bye.
Giuseppe

View solution in original post

gcusello
SplunkTrust
SplunkTrust

Hi cyberportnoc,

create a lookup with all your servers (e.g. perimeter.csv) calling column host and possibly using only uppercase (not mandatory)
run this search:

your search
| eval host=upper(host)
| stats count by host
| append [ | inputlookup perimeter.csv | eval host=upper(host), count=0 | fields host count ]
| stats sum(count) AS Total by host
| where Total = 0

In this way you listed all missing hosts.
without the last condition (where Total=0) you have the status of all your servers that you can display in a dashboard also in graphic mode.

Bye.
Giuseppe

Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Kubernetes Alerts That Work Out of the Box with AutoDetect detectors in Splunk ...

A deployment rolls out slowly, one pod sits not ready for a few minutes, and whoever is on call gets an alert ...

Observability at Your Fingertips Directly From Splunk Platform—for Free

At .conf, we announced our roadmap to bring observability foundations to Splunk Platform. Bringing metrics and ...