Splunk Search

What is a shorthand way to reference a fixed list of host names in a search?

williamcharlton
Path Finder

We're using Spunk in a Windows domain that has hundreds of computers. There is a fixed subset of computers that I want to keep an eye on using events available from Splunk indexes. These indexes contain data from all computers in the domain. I want to write queries that return events only from my subset, but I don't want to have to filter on my subset for each query I write, e.g., I don't want to have to do this:

index=foo host="bar1" OR host="bar2" OR host="bar3" OR host="bar4" OR host="bar5" OR host="bar6" OR host="bar7" OR host="bar8" .....

Is there a way to make a list of the names of the fixed subset of computers that I can reference when doing any search, e.g.,

index=foo host="myComputerList" .....
Tags (3)
0 Karma
1 Solution

FrankVl
Ultra Champion

I guess there are two main options:

1: Store the host="bar1" OR host="bar2" OR host="bar3" OR host="bar4" OR host="bar5" OR host="bar6" OR host="bar7" OR host="bar8" ..... into a search macro. So you can then write your search as:

index= foo `host_filter_macro`

More info on search macros: https://docs.splunk.com/Documentation/Splunk/latest/Knowledge/Definesearchmacros

2: Store the list of hosts into a lookup, and write your search with a subsearch like this:

index=foo [| inputlookup hostlist]

More info on subsearches: https://docs.splunk.com/Documentation/Splunk/latest/Search/Aboutsubsearches

View solution in original post

FrankVl
Ultra Champion

I guess there are two main options:

1: Store the host="bar1" OR host="bar2" OR host="bar3" OR host="bar4" OR host="bar5" OR host="bar6" OR host="bar7" OR host="bar8" ..... into a search macro. So you can then write your search as:

index= foo `host_filter_macro`

More info on search macros: https://docs.splunk.com/Documentation/Splunk/latest/Knowledge/Definesearchmacros

2: Store the list of hosts into a lookup, and write your search with a subsearch like this:

index=foo [| inputlookup hostlist]

More info on subsearches: https://docs.splunk.com/Documentation/Splunk/latest/Search/Aboutsubsearches

jason_prondak
Explorer
  1. Store the list of hosts in an eventtype.

https://docs.splunk.com/Documentation/Splunk/latest/Knowledge/Abouteventtypes

[special_hosts]
    search = ( index=foo host="bar1" OR host="bar2" OR host="bar3" OR host="bar4" OR host="bar5" OR host="bar6" OR host="bar7" OR host="bar8" )

then just search

eventtype=special_hosts
0 Karma
Get Updates on the Splunk Community!

Welcome to the Splunk Community!

(view in My Videos) We're so glad you're here! The Splunk Community is place to connect, learn, give back, and ...

Tech Talk | Elevating Digital Service Excellence: The Synergy of Splunk RUM & APM

Elevating Digital Service Excellence: The Synergy of Real User Monitoring and Application Performance ...

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...