Splunk Search
Highlighted

How to edit my search query to display a Map graph?

Builder

We are trying to build the MAP with the query below. I can see some results in the statistics view but nothing is showing in Map (zip, Lat and Long). Can you please review this query and correct me if anything is wrong?

index="abcindex" | stats sum(PrimaryAddressZIP) as geocount by PrimaryAddressZIP | lookup geolookup Zipcode as PrimaryAddressZIP OUTPUT Lat, Long | where Lat not null AND Long not null | eval _geo=Lat+","+Long

Can you please help me on this?

0 Karma
Highlighted

Re: How to edit my search query to display a Map graph?

Builder

Can you please someone help me on this?

0 Karma
Highlighted

Re: How to edit my search query to display a Map graph?

Builder

I am waiting for this answer for long time. Can you please do the needful.

0 Karma
Highlighted

Re: How to edit my search query to display a Map graph?

SplunkTrust
SplunkTrust

Try this

index="abcindex" 
| lookup geolookup Zipcode as Primary_Address_ZIP OUTPUT Lat, Long | where Lat not null AND Long not null 
| geostats latfield=Lat longfield=Long count by Primary_Address_ZIP

View solution in original post

Highlighted

Re: How to edit my search query to display a Map graph?

Builder

thanks a lot.

0 Karma