Solved: Re: Search to filter data - Splunk Community

Splunk Search

Hi, Can I write my search as:

index=idx1 host != (a,b,c) | stats count by host

The thing is I want to filter some of the hosts in the count.

1 Solution

Solution

You can do this:

index="idx1" AND NOT host IN("a","b","c")
| stats count by host

View solution in original post

Solution

You can do this:

index="idx1" AND NOT host IN("a","b","c")
| stats count by host

Get Updates on the Splunk Community!

Meet the .conf26 AI Agent Buildathon Winners

At the .conf26 AI Agent Buildathon, Splunk users turned their operational expertise into working AI agents ...

Trusted Autonomy in the SOC: A Maturity Journey

AI is compressing attacker timelines and pushing SOC teams beyond human capacity thresholds. The next SOC ...

Supercharging Windows Security Detection Performance: Introducing Hybrid Field ...

Windows event logs—from Security auditing and Sysmon to PowerShell script blocks—form the operational backbone ...