Getting Data In

Get top 20 countries from Cisco ASA events

madstylex
New Member

Hi,

I am searching my Cisco ASA logs to count where an IP originates from by country.

It looks like this:

eventtype= | iplocation src_ip | stats count by Country

It works well to give me a count of all the countries, but I can't get it to give me the top 20 only. I have tried multiple combinations of the 'top' and 'head'

I don't want to just choose 20 results per page as I need to generate reports for this.

Can anyone help me out?

0 Karma
1 Solution

renjith_nair
SplunkTrust
SplunkTrust

Try

eventtype= | iplocation src_ip | stats count by Country|sort 20 - count
Happy Splunking!

View solution in original post

renjith_nair
SplunkTrust
SplunkTrust

Try

eventtype= | iplocation src_ip | stats count by Country|sort 20 - count
Happy Splunking!

madstylex
New Member

This worked, thanks

0 Karma

javiergn
SplunkTrust
SplunkTrust

You can try this instead:

eventtype= | iplocation src_ip | top limit=20 Country
0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...