IP address to Location

Reply
L1 Bithead

IP address to Location

Im running a query in Investigate, like
event where cloud.account = 'XXX ' AND crud = 'login' 
and IP addresses are not converted to locations, the Location and Country columns are displaying Unknown.
am I overlooking something?

Community Team Member

Hi @PFabian ,

 

Were you able to find the answer in the meantime ?

I'm wondering if the IP addresses returned in your query aren't private or another type of reserved address.

 

Cheers !

-Kiwi.

L0 Member

Hi

nope, the issue was not solved, never got any reply.
for sure the IP addresses were public ones..

P

L3 Networker

Looks like at the time this events was ingested, that we were unable to determine the location data for the IPs.  What is the time range for these events?

L1 Bithead

26 and 27 September.

the account already expired as it was a 30 day trial so I cannot show it. Ive some screenshots of the output of the query.

 

L3 Networker

GeoLocation is not determined in some scenarios, such as 

  • Cloud Service Provider's (CSP) internal events OR
  • Originate from a private IP address.

These are determined based on the CSP.  Which account type were you querying on? It is possible that based on the above two points, the location couldn't be determined. 

L1 Bithead

let me quote the query from my original post:
event where cloud.account = 'XXX ' AND crud = 'login' 
aws console login events, I see no reason why the IPs could not be mapped to location..

L3 Networker

Can you please open a support ticket with a screenshot of the query results, so we can debug? We'd need to understand if any of those IPs might be generated from internal events or classified as Private.

L1 Bithead

-it was a 30 days trial so I was not able to open any tickets

-it expired in early October..

Ive screenshots archived so if you work for PaloAlto I can email them to you if it helps.

L3 Networker

I suspect in this case, the event info is captured prior to getting the login info. We have an internal team looking into geo location issues. 

Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!