Splunk Search

How To Filter IP Field Using Subnet Value Stored In Variable

joemarty82
Explorer

Hello,

 

I am trying to create a drill down dashboard. Basically I want to pass a subnet value (which is currently represented as a string) from one pane to another search pane and search on data in that query using the subnet value. I have tried several methods and none seem to work.

 

Ideally I thought something like the below would work in pseudo code.

 

Search ... |
eval subnet_value=$subnet value from first query$ |
where ipv4=subnet_value 

 

However, I get back no results. Perhaps someone has some tips on some things I can try next as I am stuck currently.

 

Thanks in advance,

Joe

Labels (1)
0 Karma

thambisetty
SplunkTrust
SplunkTrust

how are you passing your subnet value?

can you share example subnet value?

you can't compare ipv4 with subnet (for example 10.10.10.0/24) as you mentioned in your pseudo code 

where ipv4=subnet_value

instead, you get value to current search from other dashboard ( I believe your subnet value coming from dashboard would be something like 10.10.10.0/24 ). you can write this value to lookup using outputlookup command from current search. define lookup where lookup can match cidr for specified field.

and then you have to use lookup command instead of where like above.

————————————
If this helps, give a like below.
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!

Laser Bananas and Edge Hubs: Exploring Operational Technology (OT) Data Through a ...

  OT is a different environment to traditional IT and can have interesting challenges when interfacing the ...

Event Series: Mastering AI Tokenomics and Splunk Agent Observability

Beyond the Black Box: Correlating AI Performance and Tokenomics with Splunk Agent Observability   As ...

span_metrics: The OpenTelemetry-Idiomatic Way to See Inside Your Services

You open a trace in Splunk Observability Cloud and everything looks fine. One root span, order-pipeline, with ...