Splunk Search

Query help lookup

surekhasplunk
Communicator

Hi,

I am using below query to get a match by SUBNET from B.csv and get the IP filed.
And show all fields from A.csv with the matching SUBNET from b.csv and get the IP field.

| inputlookup A.csv |bla blal | where arp_usage_percentage>60 | rename subnet_global as SUBNET |lookup B.csv SUBNET output IP

But now i am facing issue where all the IPs are not show in my result. Only 100 records are coming whereas there are more than that.

Why i am getting only 100 results and is there any other way to show.

Tags (2)
0 Karma

manjunathmeti
Champion

You are using OUTPUT clause which makes the output lookup fields overwrite existing fields in the events. You can use below query to preserve IP field:

| inputlookup A.csv |bla blal | where arp_usage_percentage>60 | rename subnet_global as SUBNET | lookup B.csv SUBNET OUTPUT IP AS MATCHED_IP
0 Karma

surekhasplunk
Communicator

Hi @manjunathmeti ,

Thanks for the reply but looks its the same even if i use IP as MATCHED_IP
Note: there is no IP field in A.csv file. So overwriting cant be the issue from my point of view.
there is something which just limits and so we are getting only 100 IPs for each of the SUBNET

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Kubernetes Alerts That Work Out of the Box with AutoDetect detectors in Splunk ...

A deployment rolls out slowly, one pod sits not ready for a few minutes, and whoever is on call gets an alert ...

Observability at Your Fingertips Directly From Splunk Platform—for Free

At .conf, we announced our roadmap to bring observability foundations to Splunk Platform. Bringing metrics and ...

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...