Splunk Search

consequence of lookup command with or without OUTPUT parameter

ankithreddy777
Contributor

What is the difference between with or without using OUTPUT parameter in lookup command.

Tags (1)
0 Karma

s2_splunk
Splunk Employee
Splunk Employee

From the documentation

Usage
When using the lookup command, if an OUTPUT or OUTPUTNEW clause is not specified, all of the fields in the lookup table that are not the match field are used as output fields. If the OUTPUT clause is specified, the output lookup fields overwrite existing fields. If the OUTPUTNEW clause is specified, the lookup is not performed for events in which the output fields already exist.

somesoni2
Revered Legend

Without OUTPUT it'll return all the fields from the lookup table.

Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

(view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...