AlexSoul · The Magician! · ✭✭✭✭✭

Ah, ok. Then I strongly suggest you simply log this with SW support. Based on the article I have an impression that this is some kind of supported way of populating nodes on map with custom properties. Let us know here of an outcome please

By the way, if you decided to go Custom Property route - you do not need all that fancy scripting. Please refer here: Place objects into the map using custom properties

which Orion version you are using? Send me copy-paste of the footer on any SolarWinds page with products and versions

would you please elaborate where you will hold coordinates

I guess you have used it as a dynamic rule in one (or more) of your groups. Check all Group settings

The idea of SiteID field is that it must be unique across all your sites, which will then allow to uniquely map this to database entry, where you would have corresponding unique coordinates. Having over 500 sites would mean that your dropdown list would have 500 options AND your database would have same amount of site…

Lol... Here we go... You are learning my friend

ok, I have seen your post: Custom Tables So, we will track this issue there...

This is very odd ... can you tell me how did you name it? I have few custom tables (Orion Platform 2014.2.1, SAM 6.1.1, QoE 1.0, NCM 7.3.2, NPM 11.0.1) sitting there with no problems. What is your SW version? Are there any backup/restore jobs in place? SQL jobs?

It is possible indeed and you are right - there is a bit SQLing involved, but principle is exactly same as in above script - you take a bunch of records > you compare them to another table > you update/insert/delete as required. It is basically sync between two tables, which is being accomplished with MERGE SQL function.…

Hi Guys, in my latest deployment I started to create tables right within SlarWinds database. The main idea for using separate AUX database was to segregate custom setup from what comes out-of-the-box. This way I was pretty confident that my custom tables will not be wiped-out upon the next upgrade. However, in light of the…

This is incredible improvement. I have updated script above to add this. I have used [Description] field to populate StreetAddress. Could have used [Address] field, but I don't want too much clutter in those popups, so, description looks like perfect candidate. Besides, sometimes I would want just a short name, "Texas DC1"…

... oh, pardon me, Location Field I believe Do you have SAM 6.2?

... based on which field?

Hi Johnny, thank you for your reply. How many different sites do you have? The truth is - you only need to do this once per site. Yes, it is pain at the beginning to gather information about all sites, but think about it as about "mini audit". You not only looking up coordinates, but you also at the same time ensure that…

Be careful with default reset statement logic. I found that the below structure will work for almost all my custom SQL alerts: ALERT: WHERE <SQL TRIGGER> RESET: WHERE NodeID NOT IN ( SELECT DISTINCT NodeID FROM Nodes WHERE <SQL TRIGGER> )

Thanks danielgilbey for your feedback - you made my morning ... possibly the whole day I have improved it since then and have combined both checks together - availability of CPU readings as well as Last Poll Time. I found that it gives more accurate results that way. Here it is: SELECT Nodes.NodeID AS NetObjectID,…

Mike, do you mean "LastSystemUpTimeUtc"? What exactly are you checking?

Leon, what is the reason for filtering out all that < 120 minutes?

lol, that's a story about Steve's MAC ... Steve Jobs' 2005 Stanford Commencement Address - YouTube

syncopix you have inspired me to improve this alert. The slight issue I had with your version is that if some nodes are specifically configured to be polled every 2 hours or more - this will trigger an alert. This is rare case, but is still possible. Instead, I have combined yours one and my one together - if there were no…

Two of them have had string changed indeed. The other one (with "Microsoft Windows Embedded Standard" OS) just doesn't return CPU or Memory. Now, why I do not have CPU/Memory on this box for more than 2 month is a separate issue, but your SQL did a great job digging it out Thank you

Interesting... I have picked up 3 nodes with this SQL, which was not picked up by the one I used earlier (above). Thank you for sharing

Cool, thanks, I didn't know that. Always learning... Here it is: SELECT DISTINCT Nodes.NodeID AS NetObjectID, Nodes.Caption AS Name FROM Nodes WHERE ( ( (Nodes.Status <> '9') AND (Nodes.Status <> '11')) AND (DATEDIFF(ss, Nodes.LastSync, getdate())/Nodes.PollInterval > 5) AND (Nodes.ObjectSubType = 'SNMP') )

Hey, awesome work buddy, thanks for sharing. Just one question - why do you use vendor filter in sql script? I guess if you were to remove this line then it will work for all vendors by default. Am I missing something here?

Nice one! Well done! I usually end-up same route - something really annoys me, then I roll my sleeves and find a workaround Feels good. Also, this has trained my mind that everything is possible. If solution is not supported officially - I call it "hack". I have loads of these "hacks" hang around

just got back from a short break. Are you able to sketch basic diagram to make it bit more clear about the line-of-sight between SolarWinds poller and nodes from the wan perspective, including those two DCs

nice one, good spot. Ye, I didn't get a chance to migrate this one to V12 yet and your input is highly appreciated

That's great, I am really happy to hear that. However, my above comment was a bit of an extra mile from just creating raw tables in SQL. I was envisioning this as a feature, pretty much like you create Custom Properties in GUI, without the need to dig into SQL and create actual columns in Nodes table to represent them.…

By the way, it has always been on my mind to request a feature similar to Custom Properties, but only for Custom Tables I never published it though as I could not work out based way of explaining it to community. I have so many custom tables that I use and it has became pretty much my standard setup now. Would be great to…