Splunk Search

Realtime Google map Dashboard

nocostk
Communicator

I'm trying to configure a real-time dashboard using the Google Maps application. I'm able to get the application working with a defined time period but this is taking too long to render the results.

I think I nearly have the required XML but the last problem is the results are never displayed on the map. Any help? Here's the XML.

    <?xml version="1.0"?>
<view template="dashboard.html" refresh="60">
  <label>Geographical Location of Visitors</label>


  <module name="TitleBar" layoutPanel="viewHeader">
    <param name="actionsMenuFilter">dashboard</param>
  </module> 

  <module name="GenericHeader" layoutPanel="panel_row1_col1" autoRun="True">
    <param name="label">Geographical Location</param>
            <module name="HiddenSearch" group="Map View" autoRun="True" layout_panel="panel_row1_col1">
        <param name="search">source=/opt/shoppingsite/work/logs/access_log | geoip</param>
         <param name="earliest">rt-5m</param>
        <param name="latest">rt</param>

         <module name="EnablePreview">
            <param name="enable">true</param>
            <param name="display">false</param>


<module name="GoogleMaps">
        <param name="autoPostProcess">false</param>
        <param name="height">950px</param>
        <param name="mapType">terrain</param>
        <param name="mapTypeControl">on</param>
        <param name="navigationControl">on</param>
        <param name="scaleControl">on</param>
        <param name="scrollwheel">off</param>
        <param name="zoomLevel">3</param>
    </module>



            </module> 
      </module>
  </module>
</view>
0 Karma
1 Solution

ziegfried
Influencer

You could try it with a more efficient search (Assuming there is a clientip field in the source you're querying):

<view template="dashboard.html">
    <label>Geographical Location of Visitors</label>
    <module name="TitleBar" layoutPanel="viewHeader">
        <param name="actionsMenuFilter">dashboard</param>
    </module>
    <module name="GenericHeader" layoutPanel="panel_row1_col1" autoRun="True">
        <param name="label">Geographical Location</param>
        <module name="HiddenSearch" group="Map View" autoRun="True" layout_panel="panel_row1_col1">
            <param name="search">host=tuvok sourcetype=access_combined | fields clientip | geoip clientip | stats count as _geo_count by _lat,_lng</param>
            <param name="earliest">rt-15m</param>
            <param name="latest">rt</param>
            <module name="GoogleMaps">
                <param name="autoPostProcess">false</param>
                <param name="height">950px</param>
                <param name="mapType">terrain</param>
                <param name="mapTypeControl">on</param>
                <param name="navigationControl">on</param>
                <param name="scaleControl">on</param>
                <param name="scrollwheel">off</param>
                <param name="zoomLevel">3</param>
            </module>
        </module>
    </module>
</view>

View solution in original post

ziegfried
Influencer

You could try it with a more efficient search (Assuming there is a clientip field in the source you're querying):

<view template="dashboard.html">
    <label>Geographical Location of Visitors</label>
    <module name="TitleBar" layoutPanel="viewHeader">
        <param name="actionsMenuFilter">dashboard</param>
    </module>
    <module name="GenericHeader" layoutPanel="panel_row1_col1" autoRun="True">
        <param name="label">Geographical Location</param>
        <module name="HiddenSearch" group="Map View" autoRun="True" layout_panel="panel_row1_col1">
            <param name="search">host=tuvok sourcetype=access_combined | fields clientip | geoip clientip | stats count as _geo_count by _lat,_lng</param>
            <param name="earliest">rt-15m</param>
            <param name="latest">rt</param>
            <module name="GoogleMaps">
                <param name="autoPostProcess">false</param>
                <param name="height">950px</param>
                <param name="mapType">terrain</param>
                <param name="mapTypeControl">on</param>
                <param name="navigationControl">on</param>
                <param name="scaleControl">on</param>
                <param name="scrollwheel">off</param>
                <param name="zoomLevel">3</param>
            </module>
        </module>
    </module>
</view>

ziegfried
Influencer

Please accept the answers if it solved your problem

0 Karma

nocostk
Communicator

Well that took my search time from 2:50 to about 20 seconds so that will do nicely. Thanks, ziegfied.

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Take Action Automatically on Splunk Alerts with Red Hat Ansible Automation Platform

 Are you ready to revolutionize your IT operations? As digital transformation accelerates, the demand for ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...

Beyond Detection: How Splunk and Cisco Integrated Security Platforms Transform ...

Financial services organizations face an impossible equation: maintain 99.9% uptime for mission-critical ...