Dashboards & Visualizations

Help/Suggestions on creating a heat map/cholopleth map using XFF (x-forwarded-for) data from IIS logs

mariog2000
Explorer

I'm very new to Splunk and this seems pretty easy in Kibana but in Splunk I'm really having a hard time finding anyone that has done this yet. Initially I'd like to pull x-forwarded-for (XFF) data from my IIS logs. I was hoping I could somehow use the query below or something similar to pull the XFF IP's for the geo-location, and create one heat map for values showing how many connections are coming from that geo-location, and possible create another heat map that could use XFF IP's and the time_taken fields to show me where users with slow connections are popping.

Here's an example of a query to get me started which I can graph, but clearly just changing the graph type to "Cluster Map" or "Choropleth Map"

index=web host=J00Podyp* status=200 | stats values(time_taken) as time_taken by x_forwarded_for UserID | where time_taken > 2000

I've read through a lot of other suggestions but none seem to be using it the way I've discussed, and all have been way over my head so if anyone has any suggestion, please type slowly and provide steps as if you're explaining it to someone at the bar, as this may be where my problem brings me.

One last thing I guess, we do have ITSI and that's definitely an option but I'd rather use what's easiest assuming this is even possible. Thanks in advance for any thoughts or ideas...

Tags (1)
0 Karma

mariog2000
Explorer

Not sure if anyone has interest in this but if anyone is trying to setup something similar I've got a working model for some of this I can share. I'm still working through the details but can share what I've got so far if it can help anyone else. Thanks.

0 Karma
Get Updates on the Splunk Community!

2024 Splunk Career Impact Survey | Earn a $20 gift card for participating!

Hear ye, hear ye! The time has come again for Splunk's annual Career Impact Survey!  We need your help by ...

Optimize Cloud Monitoring

  TECH TALKS Optimize Cloud Monitoring Tuesday, August 13, 2024  |  11:00AM–12:00PM PST   Register to ...

What's New in Splunk Cloud Platform 9.2.2403?

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