Dashboards & Visualizations

How to Ignore few hosts in a search

Ash1
Communicator

Hi all, we have around 8 dashboards fetching data from same index.  There are around 150 hosts with this index, but we don't want to see the data from particular 50 hosts in a dashboard.  how this can be done???
Any inputs on this please???

 

Labels (2)
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @Ash1 ,

if you need to exclude many hosts (like 509 from your search the best solution is the one from @burwell : a lookup containing the host list.

If instead they are three or four, you can also insert them in each search or create a macro to excude them.

Ciao.

Giuseppe

0 Karma

burwell
SplunkTrust
SplunkTrust

If you always want to ignore the same hosts each time, you could create a lookup file with names of the hosts and use a search as described in this post: https://community.splunk.com/t5/Splunk-Search/How-to-search-for-all-IP-s-not-in-a-lookup-table/m-p/3...

Something like

index=myindex NOT [|inputlookup mylookup.csv | fields host]

 

Get Updates on the Splunk Community!

Splunk Mobile: Your Brand-New Home Screen

Meet Your New Mobile Hub  Hello Splunk Community!  Staying connected to your data—no matter where you are—is ...

Introducing Value Insights (Beta): Understand the Business Impact your organization ...

Real progress on your strategic priorities starts with knowing the business outcomes your teams are delivering ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...