Google Maps in Orion NPM - How to Video

I've made some changes to the original Google Maps that I introduced about this time last year. This version provides a status icon on the map for each unique latitude and longitude value in the database. I'm leaving the old one up as it is better for environments where a large number of sites exist, and would simply be too cluttered with a status icon at each site.

Prerequisites:

1) Obtain Google API Key for Maps v3

2) Create and populate Custom Properties:

  • Country
  • City
  • Latitude
  • Longitude

Installation:

Copy files to the c:\inetpub\SolarWinds\Orion\GoogleMap\

Update your connection string and API key

Create a view in NPM using the Custom HTML resource, configure iFrame

See the movie (how to install the mod):

2013-07-25_10-43-25 - YouTube

Read the book (asp files, readme, notes on GitHub):

https://gist.github.com/BarefootAtomic/a396a12541ff97a2ce1f

map.png

Enjoy!

Andrew LaGrone, SCP#1368

GoogleMap1.4.zip
  • Great post,and great addition to our network!!

    I added this a few days ago and noticed that the "GoogleMap.aspx" file was giving me a syntax error when trying to load.

    After looking in the file I saw that

    Line 33 is using "\\" to comment out the line,  Response.Write("Gifs['" & oDR.Item("City") & "'] = '" & oDR.Item("Site_Class") & "-" & oDR.Item("StatusLED") & "';


    That is code for HTML, I switched it to the VB comment ' and fixed my issue, just wanted to let everyone know in case they were having the same issue.

  • First of all let me say this is great and just what I have been looking for however I seem to be having 2 problems that I can't quite figure out.

    1. My Custom HTML Resource window only displays a third of the map and I can't figure out how to make it cover the entire resource like in your screen shots.

    2. when I click on one of my Cities on the map to zoom to street level it zooms all the way out.

    any ideas would be greatly appreciated.

  • Absolutely phenomenal!  Great work and thanks so much for doing it!  I had all of our sites built out in this, broken down by state, and in a rotating dashboard via Chrome in just a few hours.  Great instructions and I cant tell you how much time it saved me.  Thanks!

  • This is pretty cool, I plan on implementing this tomorrow in our environment at work thanks for this post!

  • One thing I suggest is to limit your SQL query portion to only return values that are not NULL for latitude and longitude.

  • Hi lag

    Thanks for this tool, I've got it working per state (actually via postcode in the UK), but as we have large numbers of sites in individual areas I would like to show all of them rather than break it down via state...  How do I sho all the sites via Lat and Long individiually, I am struggling to get this to work..

  • There's a bit of a trick to it, but you basically take the second map page, and start with that instead.

  • Thanks for the response lag, and I have done just that emoticons_wink.png...

    I'm using the second map page, but it still only returns values that are associated with states....  I just want to simplify it and return the sites alone even if there are lots of them, but I still end up with sites getting grouped under their State (in my case PostalCode)...  I've tried all sorts of combinations to get it to work, but either end up with a blank page or a scripting error...  Any pointers would be gratefully received....

  • Hi all,

    I need Help for Database, i've nothing when i execute query ! emoticons_sad.png

  • It is likely that you are not getting your SQL Sever or credentials correct if you are returning a blank screen...

    Make sure you have the correct details below

    oConn = New System.Data.SQLClient.SQLConnection ("server=yoursqlserver; initial catalog=yourdbname;uid=yourdbuser;pwd=yourdbuserpassword")