This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

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
Parents
  • The issue was with my connection string! Since I'm using a default DB instance on a CLUSTER, not a "named" instance on a physical server, I had to set my connection string up like this: oConn = New System.Data.SQLClient.SQLConnection ("server=SQLSERVER; initial catalog=YOURDATABASE;uid=DATABASEUSER;pwd=DATABASEUSERPASSWORD")  instead of the SQLSERVER\INSTANCE format which was originally specified.

Reply
  • The issue was with my connection string! Since I'm using a default DB instance on a CLUSTER, not a "named" instance on a physical server, I had to set my connection string up like this: oConn = New System.Data.SQLClient.SQLConnection ("server=SQLSERVER; initial catalog=YOURDATABASE;uid=DATABASEUSER;pwd=DATABASEUSERPASSWORD")  instead of the SQLSERVER\INSTANCE format which was originally specified.

Children
No Data