Splunk Search

Is it possible to highlight a specific term from an inputlookup?

TheJagoff
Communicator

All;
I am running Splunk 6.3.5 and need to see what term "hits" in the resulting event. The search is:

index=proxysg sourcetype=proxysg_base [|inputlookup aterms.csv | return 10000 $aterms]

I attempted to use index=proxysg sourcetype=proxysg_base [|inputlookup aterms.csv | return 10000 $aterms] |highlight $aterms
with no luck.

Is this possible? I have seen this done automatically in 6.5. without the |highlight

Many thanks.

1 Solution

somesoni2
Revered Legend

The highlight accepts the string that you want to highlight. You're passing string to your base search to filter records, pass same strings to highlight commands using subsearch like this:

 index=proxysg sourcetype=proxysg_base [|inputlookup aterms.csv | return 10000 $aterms] | highlight  [|inputlookup aterms.csv | return 10000 $aterms]

View solution in original post

somesoni2
Revered Legend

The highlight accepts the string that you want to highlight. You're passing string to your base search to filter records, pass same strings to highlight commands using subsearch like this:

 index=proxysg sourcetype=proxysg_base [|inputlookup aterms.csv | return 10000 $aterms] | highlight  [|inputlookup aterms.csv | return 10000 $aterms]

TheJagoff
Communicator

Hi, yes that works and many thanks! It also highlights the word "or" in the events log so I'm assuming that this is occurring because of the implied "expression1" or "expression2" or "expresion3" or ... that is happening due to the inputlookup? I'm guessing that this will just have to be because of the nature of the command. Many thanks again.

0 Karma

somesoni2
Revered Legend

You're right about 'OR' being highlighted due to the subsearch returning a giant OR expression. You can avoid this by changing the subsearch of highlight command as below.

index=proxysg sourcetype=proxysg_base [|inputlookup aterms.csv | return 10000 $aterms] | highlight  [|inputlookup aterms.csv | table aterms | rename aterms as search | format "" "" "" "" "" ""]

cmerriman
Super Champion
0 Karma
Get Updates on the Splunk Community!

Data Management Digest – December 2025

Welcome to the December edition of Data Management Digest! As we continue our journey of data innovation, the ...

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...