Monitoring Splunk

Address MAC flapping noise with Splunk

JPrictoe
Loves-to-Learn

Hi All,

Just a general question about best practices/network monitoring. What are some ways to address MAC flapping with Splunk? what are some of the queries people are running to identify and pull reports of multiple interfaces receiving packets from the same source?

Tags (1)
0 Karma
1 Solution

Richfez
SplunkTrust
SplunkTrust

Sounds like you need to fix your network.

Of course, this report you want may go a long way toward convincing people it's broken. 🙂

Because you were asking "generally", I'll give a couple of basic, general answers that hopefully will lead you to what you need. Assume all these are appended to the end of a base search (like index=network sourcetype=blah ...)

... | stats dc(mac_address) AS distinct_MACs BY ip_address

or

... | stats dc(ip_address) AS distinct_IPs BY mac_address

That's where I'd start. You might want to use some variant of sort or top at the end of that, or something else, but it should get you at least the first step.

Happy Splunking,
Rich

View solution in original post

0 Karma

Richfez
SplunkTrust
SplunkTrust

Sounds like you need to fix your network.

Of course, this report you want may go a long way toward convincing people it's broken. 🙂

Because you were asking "generally", I'll give a couple of basic, general answers that hopefully will lead you to what you need. Assume all these are appended to the end of a base search (like index=network sourcetype=blah ...)

... | stats dc(mac_address) AS distinct_MACs BY ip_address

or

... | stats dc(ip_address) AS distinct_IPs BY mac_address

That's where I'd start. You might want to use some variant of sort or top at the end of that, or something else, but it should get you at least the first step.

Happy Splunking,
Rich

0 Karma

JPrictoe
Loves-to-Learn

I'll start there, thanks Rich!

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!

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

[Puzzles] Solve, Learn, Repeat: Matching cron expressions

This puzzle (first published here) is based on matching timestamps to cron expressions.All the timestamps ...