topic IP address to Location in Prisma Cloud Discussions

IP address to Location

PFabian — Wed, 02 Sep 2020 18:10:04 GMT

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?

Re: IP address to Location

kiwi — Tue, 05 Nov 2019 08:47:43 GMT

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.

Re: IP address to Location

PFabian — Tue, 05 Nov 2019 09:00:24 GMT

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

Re: IP address to Location

ebeuerlein — Tue, 05 Nov 2019 14:08:35 GMT

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?

Re: IP address to Location

PFabian — Tue, 05 Nov 2019 17:40:18 GMT

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.

Re: IP address to Location

lpingali — Tue, 05 Nov 2019 20:25:45 GMT

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.

Re: IP address to Location

PFabian — Tue, 05 Nov 2019 21:28:43 GMT

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

Re: IP address to Location

lpingali — Wed, 06 Nov 2019 18:57:50 GMT

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.

Re: IP address to Location

PFabian — Wed, 06 Nov 2019 19:12:54 GMT

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

Re: IP address to Location

lpingali — Tue, 12 Nov 2019 18:57:45 GMT

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.