lag ✭✭✭✭✭

I don't recall off-hand, but I think it's just the latitude and longitude that is throwing it off. In the query, you could add something like, "AND City IS NOT NULL AND Latitude IS NOT NULL AND Longitude IS NOT NULL" after the WHERE clause. That would help prevent the map from going wonky for missing/NULL fields.

It's possible that you have a new node without any Lat and Long values. In the version I'm running in production today, I modified the SQL query to ignore Null location values, and also restricted the map inventory to critical devices using a custom property. To trouble shoot, you can either run the query in the ASP…

I've updated a version of this here: http://thwack.solarwinds.com/docs/DOC-171232 The version on the other side of this link allows for individual status icons for each unique location (instead of summarized by state), as well as some minor enhancements. It also includes a short video describing how the mod is installed.

Instead of using the MyHack page, use the second page, which I think is MyStateHack. You'll have to feed some information into the page in your iFrame, and change the query to not restrict by the state. The code isn't designed to work the way you want it to, but you can force it to behave that way with a little effort. Any…

If you want to plug in your API key: In the asp, look for this line: <script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"> </script> And then change it to: <script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?key=[your API key]&sensor=true"> </script>

This is very cool. I'll have to try that out. Wunderground will do a world map for looping weather, but I can't get it to work when integrated in the code. If you just open the link for the overlay configured for the right coords in a browser, it loads just fine, but not in the map for some reason. I think I've also…

Just as a side note to the custom properties. I know how painful it can be to populate values like numerical lat & long for nodes, so I thought I would share this as a possibility to look into. As a solution to this for one client, I developed a trigger that populates all the required properties based on what you choose…

You need Latitude, Longitude, State (2 letter state code), and City (no spaces in your cities in this version). I think this also requires a country, but there are notes in the readme that talk about this. It's been awhile since I've looked at it. On another note, I think I figured out how to use your API key from google,…

The map won't load if it it can't execute the query. The first thing I would do would be to test the query in the database manager to make sure you don't get an error. Also, make sure that your custom properties are completely filled in across all the nodes. Then I would look at the connection string to make sure that it's…

Hah - Me, too. I'm still learning as I go... This is probably the biggest programming project I've taken on to date - Lots of moving parts to wrap my brain around. Stupid question, have you configured the DB connection on all the ASP pages? Each page needs to be configured to talk to the DB. Otherwise, something else in…

I Think that will work for your connection string - I don't have a local SQL express to test against at the moment. in the DB manager, if you expand your DB to list the tables, click on any table and select query table. This will open a query window, and you just place your query there.

Double check your MyStateHack.asp page to make sure you have the Db Connection configured there as well. For the second part: The Database Manager is on the Orion server, in the ../Orion/Advanced tools menu. You can also use SSMS (SQL Server Management Studio), RazorSQL, or otherwise. If you run this query, you should be…

my guess is that the sql query isn't returning any data in the popup menu. Did you add your DB credentials to all the asp pages? Another user pointed out that the canned Lat & Long properties are misspelled, and you'll want to create custom Custom Properties with the correct spelling. To trouble shoot, I would take the…

You can connect SQL MGT Studio to connect to Express - you might have to enable TCP/IP in the connection properties if you're trying to connect remotely. You can also install the express version on Orion, and then use the credentials below in wvansickle's post to connect.

Sounds like you are getting a SQL query error. Are your custom properties all the same as in the instruction txt?

Hi theCougher, This is by design. The first layer map places an icon in the center of the state, and clicking that will provide a list of nodes in that state. Selecting the state link in that menu that pops up will take you to a state map where nodes reside at their lat/long locations as defined in your custom properties.…

D'oh - I need to update my instructions then. I seem to have made some assumptions that aren't entirely in line with actual behavior. But, that makes sense that it is getting run from the browser instead of the Orion server. Thanks for clearing that up.

That's on my to do list - using the proper API. Unfortunately, that list is pretty long today. :O Keep me posted if you get it sorted out.

I'm glad you got it sorted out on your own. And, interesting observation about the canned advanced properties. I haven't looked at that list in awhile, so didn't know they were already in there (and misspelled apparently).

Line 218. It's not the easiest thing to set, so you may have to play around with the values a little. This line sets the bounds using the lat & longs assigned to your nodes, so you can apply a little math to get these where you want to start. Try modifying that line so that it resembles these settings to start: new…

I'm not entirely sure, actually - I haven't had a lot of time to look into it in detail. I'm assuming that there may still be the issue here from where google would be concerned since nowhere in this example do I use the API key. If my assumptions are right, I'll need to introduce the use of the API key into the…

This helps. I've always been curious how much of the primary engine performance would or could impact the AWS response times.

This has been helpful. We have close to 200 users in SolarWinds during the day, and have 13 servers total in our Orion system. I've been using this as a guide to right-size our primary server. One question I have is regarding the additional web console server. Our AWS server is (seems like) a monster, but it's practically…

I updated the monitor. Try the new version, and if you need to add other time zones, just follow the format you see for the existing time zones. Also, keep in mind that I'm taking two measures of time, and subtracting them from the value at the end. I don't know that they are in the ideal spot, so you may have to play…

I wanted to take a moment to comment on clock drift because it's not an easy target due to some timing factors. You have the length of time it takes to get the time server information, to get the server information, and to process the whole thing. Even putting in a stopwatch to remove the estimated values makes this a…

Are you using the Win32 Report Writer or the web based report writer?

Not sure - maybe an issue with Thwack? Here's the content of the file on GitHub: PSFTP_Monitor.ps1 · GitHub

I haven't had to point this to a LINUX box yet. I did have to confirm the certificate against the Win boxes, though. When initially setting up the monitor, I had to edit the script and test it once before I could put it into production. Testing it with the modification created the key, and it worked after switching it…

It would be good functionality to have it, and maybe control wether or not you run the PING test. In my case, I needed to cram the inventory into Orion regardless of wether or not it would respond, then let the field techs or networking deal with the connectivity problem. I have a separate script that pings a list of IP…

That's a good question, and I actually hadn't considered incorporating that as part of the process; I actually wanted to avoid ping testing anything - call me crazy. I have an existing Orion install that will be going away, and I'll be installing an APE at that site to consolidate inventories. I want to get all of the…