Network & Systems Management Solutions Providers

Blog

7 Aug

By Raul Gonzalez

Script - Automatic Geo-location Devices in Worldwide Map

If you are one of the ones that is using the WorldWide map feature in SolarWinds, I’m sure it feels bittersweet for you. Sweet because it is a cool feature that allows you to see geographically where your devices are, but also bitter because it is not so easy to place the devices in the map, and it is still a manual process.

 

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

 

>>>DOWNLOAD SCRIPT - AUTOMATIC GEO-LOCATION DEVICES IN WORLDWIDE MAP<<<

 

Training Courses for SolarWinds Customers

Prosperon Networks are the UK's leading authority on SolarWinds IT Management Solutions. We run training courses that suit a number of roles in your organisation, these courses cater for engineers, helpdesk operators and management personnel who all use monitoring platforms differently. The SolarWinds products retain their simplicity and ease of use, however product training in some form is recommended to get the most out of the tools we use every day.

 

 

 

 

15 Jan5 Day Administrator Course for SolarWinds

Training covers all core Orion products & SCP Exam…

23 April5 Day Administrator Course for SolarWinds

Training covers all core Orion products & SCP Exam…