Exported Script: Automatic Geo-location Devices in Worldwide Map
I know that there is the option to automatic geolocate devices based on the field ‘location’ available in SNMP, with the following KB detailing how to use this, but:
- who is using that field properly?
- what happens with the rest of the devices? Say devices monitored using WMI, Agent or even ICMP
There is also a way to import coordinates within the GUI of Orion, but this is a manual process, which would need to be performed regularly in order to keep objects on the map up to date.
That’s why in Prosperon Networks we have created a SQL script that will set the coordinates of the devices based on the value of a custom property. This script can be scheduled to be run every day, or any other frequency that you might consider in order to place any new device on the map.
There are just a few prerequisites in order to use this script properly:
- Create a custom property named Site
- Assign the correct Site to each device
- Modify the SQL script adding your locations and the coordinates of those locations in Site: Add more locations just by adding more options in each case.
- Create a job in SQL to run this script every day
BONUS INSIGHT
We can use IP addresses instead of the custom property site if you wish. The script would look like
…
Case
When IP_address like ‘192.168.% then 50.813104
When IP_address like ‘172.16.1.% then 41.429853
Custom Script: Automatic Geo-Location Devices In Worldwide Maps

Raul Gonzalez
Technical Manager
Raul Gonzalez is the Technical Manager at Prosperon Networks. As a Senior SolarWinds and NetBrain Engineer for over seven years, Raul has helped hundreds of customers meet their IT monitoring needs with SolarWinds and NetBrain Solutions.
Custom Script: Automatic Geo-Location Devices In Worldwide Maps
Related Insights From The Prosperon Blog
Webinar On-Demand: SolarWinds Next Generation In Data Driven Modern Dashboards
In this webinar, you will discover how to leverage the new dashboards framework in SolarWinds® Orion® 2020.2. This webinar examines how to increase your visibility and...
Webinar On-Demand: SolarWinds Technical Update & Demo – Orion Maps 2020.2
In this webinar, you will discover how to leverage key new features & functionalities within SolarWinds® Orion® Maps. This webinar examines how to enhance visibility...
How to Automate Link to PerfStack in a SolarWinds Alert
PerfStack (Performance Analysis) is a feature introduced into the SolarWinds® Orion platform 2017.1 and despite how fantastic this feature is, we’ve noticed as we work with...