https://community.splunk.com/t5/Splunk-Enterprise-Security/Splunk-Enterprise-Security-How-to-filter-geographically/m-p/253574#M1849 <P>| tstats <CODE>summariesonly</CODE> values(Authentication.app) as app, latest(Authentication.user_bunit) as user_bunit from datamodel=Authentication.Authentication by Authentication.user,Authentication.src _time span=1s | <CODE>drop_dm_object_name("Authentication")</CODE> | eventstats dc(src) as src_count by user | search src_count&gt;1 | sort 0 + _time| <CODE>get_asset(src)</CODE> | iplocation src | eval session_lat=if(isnull(src_lat), lat, src_lat) | eval session_lon=if(isnull(src_long), lon, src_long) | eval session_city=if(isnull(src_city), City, src_city) | where isnotnull(session_lat) and isnotnull(session_lon) | sort 0 + _time | streamstats current=t window=2 earliest(session_lat) as prev_lat, earliest(session_lon) as prev_lon, earliest(session_city) as prev_city, earliest(_time) as prev_time, earliest(src) as prev_src, latest(user_bunit) as user_bunit by user | where (src!=prev_src) | <CODE>globedistance(session_lat,session_lon,prev_lat,prev_lon,"m")</CODE> | eval time_diff=if((_time-prev_time)==0, 1, _time - prev_time) | eval speed = round(distance*3600/time_diff,2)| where speed&gt;1</P> Tue, 29 Sep 2020 15:00:33 GMT renjujacob88 2020-09-29T15:00:33Z https://community.splunk.com/t5/Splunk-Enterprise-Security/Splunk-Enterprise-Security-How-to-filter-geographically/m-p/253571#M1846 <P>In Splunk Enterprise Security, the geographically improbable login correlation fires when users on our network transition between ipv4 and ipv6 due to the different latitude fields in the geoip database. Is there a way to filter out results by distance value? </P> Mon, 29 Aug 2016 20:03:46 GMT https://community.splunk.com/t5/Splunk-Enterprise-Security/Splunk-Enterprise-Security-How-to-filter-geographically/m-p/253571#M1846 vanderhoff 2016-08-29T20:03:46Z https://community.splunk.com/t5/Splunk-Enterprise-Security/Splunk-Enterprise-Security-How-to-filter-geographically/m-p/253572#M1847 <P>The rule by default looks for speed of more than 500. However, there is an evaluation of distance as well that is used to calculate speed. You could add a condition for distance being greater than x miles and/or swapping out the speed threshold.</P> Thu, 01 Sep 2016 16:56:38 GMT https://community.splunk.com/t5/Splunk-Enterprise-Security/Splunk-Enterprise-Security-How-to-filter-geographically/m-p/253572#M1847 jstoner_splunk 2016-09-01T16:56:38Z https://community.splunk.com/t5/Splunk-Enterprise-Security/Splunk-Enterprise-Security-How-to-filter-geographically/m-p/253573#M1848 <P>Thanks I didn't realize I could edit the correlation searches, adding a "where distance &gt; 1" did the trick.</P> Thu, 01 Sep 2016 18:34:53 GMT https://community.splunk.com/t5/Splunk-Enterprise-Security/Splunk-Enterprise-Security-How-to-filter-geographically/m-p/253573#M1848 vanderhoff 2016-09-01T18:34:53Z https://community.splunk.com/t5/Splunk-Enterprise-Security/Splunk-Enterprise-Security-How-to-filter-geographically/m-p/253574#M1849 <P>| tstats <CODE>summariesonly</CODE> values(Authentication.app) as app, latest(Authentication.user_bunit) as user_bunit from datamodel=Authentication.Authentication by Authentication.user,Authentication.src _time span=1s | <CODE>drop_dm_object_name("Authentication")</CODE> | eventstats dc(src) as src_count by user | search src_count&gt;1 | sort 0 + _time| <CODE>get_asset(src)</CODE> | iplocation src | eval session_lat=if(isnull(src_lat), lat, src_lat) | eval session_lon=if(isnull(src_long), lon, src_long) | eval session_city=if(isnull(src_city), City, src_city) | where isnotnull(session_lat) and isnotnull(session_lon) | sort 0 + _time | streamstats current=t window=2 earliest(session_lat) as prev_lat, earliest(session_lon) as prev_lon, earliest(session_city) as prev_city, earliest(_time) as prev_time, earliest(src) as prev_src, latest(user_bunit) as user_bunit by user | where (src!=prev_src) | <CODE>globedistance(session_lat,session_lon,prev_lat,prev_lon,"m")</CODE> | eval time_diff=if((_time-prev_time)==0, 1, _time - prev_time) | eval speed = round(distance*3600/time_diff,2)| where speed&gt;1</P> Tue, 29 Sep 2020 15:00:33 GMT https://community.splunk.com/t5/Splunk-Enterprise-Security/Splunk-Enterprise-Security-How-to-filter-geographically/m-p/253574#M1849 renjujacob88 2020-09-29T15:00:33Z