mesverrum · Observability Architect · ✭✭✭✭✭

I'd pick one of them, check the database before you do the save and then check it after to see if anything changes. I have noticed from past experience that it is extremely particular about case sensitivity and white spaces so I suspect that what happens is that the script you have is making something that is ALMOST right.…

I don't recall any way for it to automatically pick up the relationships yet, I've never had to work with a very large or dynamic installation of WPM so I haven't had a client need me to really test anything out to that end yet.

The SEARCH_STRING happens to be one of the few places in Orion that is case sensitive.

So the way the macros work is they mostly only allow you to filter against the data on the database table for whatever type of object you are looking at. So if you are on a node details view, if you open up the orion database and look at the nodes view then that is the master list of macros for node details pages.…

Recordcount has to do with the aggregation that Orion does on older data. Under default settings you would hold detailed stats from every polling cycle for 30 days, so for data in that period the record count is always 1 per poll cycle and availability will always be either 0/100. After 30 days Orion will take all of the…

The group priority is the same as the group order you see in the GUI, you want the most privileged groups at the top of the list/lowest priority number

No, it counts the number of alert actions that were recorded

Yep, for me learning SQL was an important stepping stone toward the API stuff. Since ultimately I still needed to know how to do SQL/SWQL to get anything significant done there. For anyone who does go the API route this is a sanitized example of a script to set node custom properties based on the attributes of a CI record…

Solarwinds already has their documented rest api here - https://github.com/solarwinds/OrionSDK It's a pretty unusual format for an api but there's no need for you to build anything unless you REALLY wanted to create your own layer in front of that for some reason.

This is always the first thing I trained people on when I was consulting. You cannot use groups for almost anything useful that you think you would use them for in Orion. Don't even try. Start from custom properties, tag the objects with whatever attributes you think you would need later for all of your sorting,…

Have you pulled the local agent logs from any of the monitored nodes? Any chance that someone turned on a firewall or routing rule that is jamming up those pollers?

I haven't experimented with removing specific old files one by one because after having seen people removing the folder interfere with upgrades and such for clients I did not have an appetite for experimenting with finding the limits of exactly which files are vital and which aren't. Especially painful if I get rid of…

Yes, https://support.solarwinds.com/SuccessCenter/s/article/Excluding-ESX-hosts-from-VMAN-monitoring-to-decrease-used-sockets

Any chance you are using snmpv3? Could be something weird with the view assigned to your user that isn't providing access to the OID for interface status.

I've got no useful experience with the SNOW integration, at my work there are a few other tools that events pass through before we raise an INC so we don't have the built in integration enabled and I just use custom SQL/REST. All I can suggest is to check the logs on your server and see if you find any clues about what…

Most often I've seen that process, just adding an action to every alert where it http posts certain variables and that's not too far from how the built in service now integration works under the covers.

When I took it I just rolled through the topics outlined here https://support.solarwinds.com/SuccessCenter/s/scp-npm-exam-guide But I do monitoring consulting for a living for 5 years now, so I have maybe an unusual amount of exposure to this stuff, hard for me to remember what I learned from the admin guides and what I…

I don't believe its in the database, built into the application code somewhere. Might be risky to open it up and try making changes, but that's what test environments are for right ?

For any node has been polled with SNMP in the past you can enable some UNDP pollers to check the array info, along with the other sensors that aren't available via the Dell OMSA tool using WMI Disk: OID = ARRAYDISKNUMBER 1.3.6.1.4.1.674.10893.1.20.130.4.1.1 OID = arrayDiskName 1.3.6.1.4.1.674.10893.1.20.130.4.1.2 OID =…

The only scenario I can think of where those nodes would not have corresponding down events might be if they have been down longer than your event retention period. You can check how long yours is set to by going to settings > Polling Settings. My lab is set to 30 days, but I can't recall if that's the default value, I…

I no longer have access to those scripts as they were built at my former work for a client.

There's a verb under orion.reporting called executesql that does let you just execute whatever raw sql you want directly into the db, but keep in mind that you would want to build the query for all that using ssms or the database manager not SWQL studio.

Solarwinds doesn't really have a direct way of "batching" the alert actions and delaying them until a specific time. The easiest way to address this would probably be to generate a report that shows all alerts that are active each morning and email that out to your team to catch them up on anything they may have missed.…

This will get a breakdown of how many row are associated with each poller and what their interval is set to. I ran into similar problems in the past and in almost all cases when I brought it up to the owners of those systems i get answers like "Oh we didn't even realize SW was collecting that, we had trouble with it like 5…

I would say the direction I would take this is to not send the users to NPM directly at all, build a report/dashboard whatever in SQL SSRS using the data from the SW database and don't embed any links or extra features inside of it. You could fairly easily make that into a fully read only interface and have full control of…

Just query the Orion.CustomPropertyValues, if the value is not already an exact match (case sensitive) for an item in the list you could reject it? SELECT Table, Field, Value FROM Orion.CustomPropertyValues

Nope, I'm 5'6" and the head room is a few inches above that. The idea wouldn't have been viable if my wife and I were taller people.

The "response" would be the performance of the query, the "statistic" would be the result of the query. It collects them both.

Unfortunately I'm not working with that environment anymore and don't have any of the code handy, I mostly brought it up as an example that if you try to get into the weeds with it you can do a lot with IPAM in SQL and with the API. https://solarwinds.github.io/OrionSDK/schema/index.html…

Unfortunately my script is heavily tailored to the conditions of my environment so it's not a great example, but the basic logic is first we group up our APE's based on which ones can be treated as a pool (for example DMZ ape's should not be interchanged with regular ape's and we have some pollers in dedicated networks for…