Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Understanding Geolocation in NPM

Understanding Geolocation in NPM

Table of contents
Created by John Salvani, last modified by Jane Baylon on May 28, 2018

Views: 2,400 Votes: 0 Revisions: 6

Overview

This article discusses how Geolocation is used in NPM.

Environment

NPM 11.5.2 and later

Detail

NPM call out to mapquest API (http://open.mapquestapi.com/) so any format can be used as seen in the example below: 

Format

Example

city (AA5), state (AA3)

Lancaster, PA

city, state, postalCode

Lancaster, PA, 17601

postalCode

17601

street, city, state

300 Granite Run Dr, Lancaster, PA

street, city, state, postalCode

300 Granite Run Dr, Lancaster, PA, 17601

street, postalCode

300 Granite Run Dr, 17601

  • Make sure that http://open.mapquestapi.com/ is allowed on your firewall or proxy rules.
  • Compare the latitude and longitude from database and Map Quest site:
    • Access the WorldMapPoints table and take note of the latitude and longitude.
    • Use the URL below and go to the section “Geocode Options Sample” to manually generate the latitude and longitude: http://open.mapquestapi.com/geocoding/#locations.
  • Use a third-party site to reverse the Geocode by inputting the latitude and longitude, then compare the address generated:  http://www.gps-coordinates.net/.
  • Any issues with Map Quest cannot be resolved by SolarWinds since this is a third-party free service. 
  • You can also use the link below to cross check your node address:  http://www.openstreetmap.org/.
Last modified

Tags

Classifications

Public