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!

Stay Connected: Your Guide to May Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...