Hello, I have lookup file uploaded and now I want to see the data, I am not able to see it on map , I can see the details in table tough , this is the query and this is the sample of output . Map is blank
| inputlookup geolocation.csv
| eval lat=tonumber(trim(latitude)), lon=tonumber(trim(longitude))
| where isnotnull(lat) AND isnotnull(lon)
| table cluster_name lat lon avg_cpu_load avg_mem_load
---------------------------------
This is the output I get
cluster_name | lat | lon | avg_cpu_load | avg_mem_load |
ab.com | 63.3441204 | -8.2673368 | 96.88 | 78.55 |
bc.com | 48.9401 | 62.8346587 | 55.49 | 95.49 |
fg.com | 31.5669826 | 129.9782352 | 11 | 19.86 |
i @rishabhpatel20 ,
see the usage of geostats (https://help.splunk.com/en/splunk-enterprise/search/spl-search-reference/9.4/search-commands/geostat...) to display in a map your data.
Ciao.
Giuseppe
I see, but with this I am not able to see the data as I want, Iike I want to see the hostname on map and when point out on host it shows average CPU and memory utlization