Splunk Search

How to add inputlookup file in the query

Harish2
Path Finder

Hi ,
I have uploaded the lookupfile with application host and hostip details in the splunk.

i am not sure where to add this inputlookup file so that when i run this query i should get application details.
when i run this query i am getting only _time and ClientName  responsetime data, i need application details as well.

My Query:

index=app_cust_ctl sourcetype=applicationdata
|bin _time span=1s
|rex "\d{2}:\d{2}:\d{2}:\d{3} (?<responsetime>;\d+) ms"
|stats count(eval(Status="success")) as sucessapp, count(eval(Status="error")) as errorapp, avg(responsetime) as appresponsetime, max(responsetime) as maxresponsetime by _time application ClientName

|eval record="location"




Labels (1)
0 Karma
1 Solution
Get Updates on the Splunk Community!

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

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...

Updated Data Type Articles, Anniversary Celebrations, and More on Splunk Lantern

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

A Prelude to .conf25: Your Guide to Splunk University

Heading to Boston this September for .conf25? Get a jumpstart by arriving a few days early for Splunk ...