All Apps and Add-ons

what actually dnslookup doing in my query? and what is it?

pavanae
Builder

Generally, In splunk the below is the way to open or display a lookup file

| inputlookup ABCD.csv

but what does the below lookup used in between my query

| inputlookup ABCD.csv | lookup dnslookup field_1 AS Field_one OUTPUT field_2 AS field_two

While trying to understand the above query. The first thing I tried is below to check what's inside the lookup dnslookup

| inputlookup dnslookup

which didn't displayed any results. Could someone explains what actually | lookup dnslookup does in my query and how to check what's inside that lookup?

0 Karma
1 Solution

mayurr98
Super Champion

This is a DNS lookup example, the CSV file contains the two fields clienthost and clientip. It is an external_lookup.py file invoked through scripts that is why you can not see using inputlookup command.
Here is doc which says this
http://docs.splunk.com/Documentation/Splunk/7.0.1/Knowledge/DefineanexternallookupinSplunkWeb#Extern...

so if you have clientip you can get clienthost or vice-versa using this lookup file.
Also on Web UI it is configured in Settings » Lookups » Lookup definitions » dnslookup

let me know if it helps !

View solution in original post

mayurr98
Super Champion

This is a DNS lookup example, the CSV file contains the two fields clienthost and clientip. It is an external_lookup.py file invoked through scripts that is why you can not see using inputlookup command.
Here is doc which says this
http://docs.splunk.com/Documentation/Splunk/7.0.1/Knowledge/DefineanexternallookupinSplunkWeb#Extern...

so if you have clientip you can get clienthost or vice-versa using this lookup file.
Also on Web UI it is configured in Settings » Lookups » Lookup definitions » dnslookup

let me know if it helps !

Get Updates on the Splunk Community!

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer at Splunk .conf24 ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...

Share Your Ideas & Meet the Lantern team at .Conf! Plus All of This Month’s New ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...