Splunk Search

map visulization with lookup table

moayadalghamdi
Path Finder

Hello Splunkers !

 

i wanted to visualize data on map so i used this command and it worked:

index=myFirewall | stats count by src_ip | iplocation src_ip | geostats count by Country

 

but i want to show countries on map from a predefined list, so have a called "blacklisted.csv" that looks like this:

 blacklisted_countries
1country1
2country2
3country3
4country4
5country5

 

so i wrote a a search to combine the aforementioned search from the lookup table using this command:

 

index=myFirewall [ | inputlookup blacklisted.csv | search blacklisted_countries=srccountry] | stats count by src_ip | iplocation src_ip | geostats count by Country

 

but it didn't give me any results, please help me with it, i want a search the combines visualizing source countries with lookup tables.

 

 

 

Thanks

0 Karma
1 Solution

saravanan90
Contributor

This may help..

index=myFirewall [ | inputlookup blacklisted.csv| fields  blacklisted_countries | rename blacklisted_countries as srccountry] | stats count by src_ip | iplocation src_ip | geostats count by Country

View solution in original post

moayadalghamdi
Path Finder

exactly ! thanks splunker mate ^_^

0 Karma

nyc_jason
Splunk Employee
Splunk Employee

Hello,

Looks like you need to do the iplocation before hand, as the data doesnt yet contain the Country info until you do. This may not be the most efficient, but try this to get started, it worked for me:

index=myFirewall   |  iplocation clientip | lookup blacklisted.csv blacklisted_countries AS Country OUTPUT blacklisted_countries AS Country |  geostats count by Country

I created a lookup called blacklisted.csv with a column called blacklisted_countries which contain the list of countries. Ensure the names are initial caps. so Spain, not spain.

Also, not sure why you were doing the stats count by src_ip first, since the geostats is doing a count by country anyway, and that stats command will be removing all the fields aside from src_ip too.  So I just took it out.

 

0 Karma

saravanan90
Contributor

This may help..

index=myFirewall [ | inputlookup blacklisted.csv| fields  blacklisted_countries | rename blacklisted_countries as srccountry] | stats count by src_ip | iplocation src_ip | geostats count by Country

Get Updates on the Splunk Community!

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, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...