Splunk Search

My search works when I run it manually, but why does it not produce results when I use it to populate a table?

smhsplunk
Communicator
index=main source=locations sourcetype=location_information  
                     | search * AND address=$token1$ OR address="LocationXYZ"
                     | table site_name, address, state, country

When I run this search manually, it works fine, but when I use it in a table, it doesn't do anything

  <table>
        <title>Location</title>
        <search>

          <default>*</default>
          <query>index=main source=locations sourcetype=location_information | search * AND address=$token1$ OR address="LocationXYZ" | table site_name, address, state, country </query>
        </search>

      </table>

I would like to use two tokens also:

search * AND address =$token1$ or address=$token2$

0 Karma

sundareshr
Legend

Try removing the search * and move the address search to base search. Like this

index=main source=locations sourcetype=location_information (address=$token1$ OR address="token2") | table site_name, address, state, country

smhsplunk
Communicator

Your Awesome!

0 Karma

smhsplunk
Communicator

Sorry, seems this is giving me all the rows, not just the one's selected by the token

0 Karma

sundareshr
Legend

Did you have quotes around your tokens? Like this?

index=main source=locations sourcetype=location_information (address="$token1$" OR address="$token2$") | table site_name, address, state, country
0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...