Splunk Search

How to check a table for multiple mac addresses with the same IP

jhick
Observer

Currently my splunk search to get a list of macs of the security cameras with their respective IP is 

index = dhcp 00:04:7d 10.101.240.* |table dest_mac, dest_ip |dedup dest_ip | dedup dest_mac

How would I get it to check for  multiple mac addresses with the same IP. This will indicate that the IP is not fixed.

Thank you!

Labels (4)
Tags (4)
0 Karma

abowesman
Explorer

Try

 

| stats values(dest_mac) as MacAddresses by dest_ip

 

0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

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