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 Enjoy! Andrew LaGrone, SCP#1368

This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Google Maps in Orion NPM - How to Video

lag over 11 years ago

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

Enjoy!

Andrew LaGrone, SCP#1368

GoogleMap1.4.zip

Top Replies

0 ryanjearl over 11 years ago

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.
Cancel
Vote Up +6 Vote Down

Cancel
0 Arbee over 11 years ago

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.
Cancel
Vote Up 0 Vote Down

Cancel
0 nwtaylor over 10 years ago

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!
Cancel
Vote Up 0 Vote Down

Cancel
0 aschmitt over 10 years ago

This is pretty cool, I plan on implementing this tomorrow in our environment at work thanks for this post!
Cancel
Vote Up 0 Vote Down

Cancel
0 lag over 10 years ago

One thing I suggest is to limit your SQL query portion to only return values that are not NULL for latitude and longitude.
Cancel
Vote Up 0 Vote Down

Cancel
0 jonnyroyale over 10 years ago

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..
Cancel
Vote Up 0 Vote Down

Cancel
0 lag over 10 years ago

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

Cancel
0 jonnyroyale over 10 years ago

Thanks for the response lag, and I have done just that ...
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....
Cancel
Vote Up 0 Vote Down

Cancel
0 fabi over 10 years ago

Hi all,
I need Help for Database, i've nothing when i execute query !
Cancel
Vote Up 0 Vote Down

Cancel
0 jonnyroyale over 10 years ago

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")
Cancel
Vote Up 0 Vote Down

Cancel