rmatovich

We already had our Latitude and Longitude coordinates stored as Custom Node attributes. Here's a quick SQL script to rebuild the WorldMapPoints table with all Nodes that have Latitude and Logitude not Null. I just run this each time I need to add nodes to the map. I'm sure a SQL UPDATE command would be better, but my SQL…

Again, my SQL is feeble at best, but this is my understanding of how it works commented below. I have run this script against the database probably 7 times now to update the Map Points and it has worked flawlessly. I wouldn't guarantee that there are no ill effects using this method, but so far my system has not had any…

Oh…sorry. For that, I just set the NOC mode screens to rotate and the weather updates each time the screen rotates around. There’s probably a quick way to do it with JavaScript in the Custom HTML section for non-NOC mode views. Regards, Ryan Matovich ETS & Information Security GCIS Design Engineering Tools Manager St.…

Here’s what I’ve been using. USE NetPerfMon --Tells SQL engine which DB to execute the following commands against DELETE FROM WorldMapPoints; --Clears out all existing rows in the WorldMapPoints table INSERT INTO WorldMapPoints (Instance, InstanceID, Latitude, Longitude) --Selects the destination table and columns for…

If you want to schedule it to run automatically, create a new stored procedure, insert the SQL code into the new procedure and then schedule the procedure to run at whatever interval you choose using the SQL Management Studio Job Scheduler. Regards, Ryan Matovich ETS & Information Security GCIS Design Engineering Tools…

Really nice modification, works perfectly so far. Thanks!