mesverrum · Observability Architect · ✭✭✭✭✭

My house is eternally in the midst of a remodel, but I'm not shy about showing the chaos off. Built that loft in our master bedroom so I can do my computer stuff while my wife works in her art studio on the ground level.

You'd just use set-swisobject against the interface URI and change the polling frequency. https://github.com/solarwinds/OrionSDK/wiki/PowerShell

You can change cpu pollers in bulk from settings > manage pollers. Its doable to manipulate the pollers via the api if needed but I'd try the gui first. If that doesn't cut it then via the api just setswisobject enabled = false on uri of the poller you need off and enabled = true on the standard ones you need it switched…

I feel like the network admins I have run into during my days in the wilderness were mostly interested in ease of setup and use. I get all excited about learning SWQL and writing custom scripts and getting way in the weeds. Network admins, as a general rule, were much less excited about any of that stuff. They want to be…

What you have there will actually only be a list of objects that have already triggered that particular alert in the past. Triggering an alert doesn't even reliably say that it could trigger the alert again in the future since the alert rules may be edited or the attributes of the node may change. If i started out with a…

The appinsights are special because under the covers they rely on more complex scripted sets of data than you can normally achieve with the common components. They don't necessarily have a 1 to 1 relationship with any particular standard template but they usually are the most complete kind of template you will have, so you…

You can edit the template to exclude indexes below a certain size, which i usually set to a much higher threshold than they come out of the box because there is not really much performance impact to fragmented small indexes anyway. I find that once you weed out all the ones that arent at least maybe 50mb or more then the…

Unfortunately the dynamic group rules dont allow for nulls or empty rows. The way I worked around this in the past was to write an alert that takes all the nodes that have client site equal to '' or empty and have the alert action set the property to your placeholder. Then you can just set their account restriction to…

Mine is pretty close to the out of the box except this custom SQL widget i made that correlates data between our ticketing system and the on-call notification platform we use, so we know the ticket history and if there was a call made

Snow has and api explorer feature that can be enabled for your account that basically shows you how to query most anything you'd want from them. Once you know what data you need you could probably cook something up with javascript to display the data in a custom html widget. If sql is more your speed then snow also has a…

To your final point that you are using SAM "wrong" that is kind of true. SAM is written with the assumption that it will be the tool scraping all your servers for data and then reporting on them separately. The tool is built around that so doing what you want to do is going to require some kind of work around. If you…

Yes it can be done, I don't think there are samples in the gallery of the whole process as they tend to be very simple things like "add a single node" I've done scripts in the past to just ingest a big spreadsheet of hostnames and run discoveries off them, I've got this sloppy example hanging around in my public…

This looks like it'll do the job SELECT N.Caption as Name, cps.Status, ADDMINUTE(MINUTEDIFF('2000', cps.DateTime) / 5 * 5, '2000') as date FROM Orion.Nodes N INNER JOIN Orion.NPM.CustomPollerAssignment CPA ON N.NodeID=CPA.NodeID FULL JOIN Orion.NPM.CustomPollerStatistics CPS ON…

Yeah this is probably something I would just do with a custom powershell monitor. That way instead of having to poll the data then build an alert in orion to launch a powershell script to try and fix the issue I can just fix it in the same script, something loosely like (untested semi code) Use the fancy new fangled devops…

The relevant requirements are here https://documentation.solarwinds.com/en/success_center/IPAM/Content/IPAM-DHCP-management.htm

I honestly think that series of threads was related to a bug in the application. I could understand maybe having a reputation requirement before uploading a new template to the list, but downloading them it doesn't really make sense. I had my thwack account for like 2 years before I really started to post anything and I…

As a work around I know one of the other MVP's, @"antonis.athanasiou" , mentioned running into a bug that sounds similar. They looked into the AWS logs and saw errors relating to missing schema data in this path c:\Program Files (x86)\SolarWinds\Orion\Information Service\3.0\Schemas Once they saw the files that were…

This seems like it should work a bit easier to get the peaks SELECT MAX([RawStatus]) AS MAX_VPN_USERS FROM [Orion.NPM.CustomPollerStatistics] WHERE [CustomPollerAssignmentID] in…

This will give you the explanations of the status codes, I remember spending wayyyyy too long hunting for them myself. SELECT * FROM [SolarWindsOrion].[dbo].[APM_StatusMetadata]

I've accomplished the scenario you describe with extensive use of REGEX with lookaheads and lookbehinds. I wrote a bit of an article about how to do it for my team when I was consulting, but sadly I don't have access to those files anymore or I'd post it here too.

This query gets the data you are asking for, runs reasonably quickly in my environment (16-20 seconds) but yours may vary. select n.caption, n.CPULoad as CurrentLoad , m0.AvgCpu, m0.MaxCPU , m1.AvgCpu, m1.MaxCPU , m2.AvgCpu, m2.MaxCPU , m3.AvgCpu, m3.MaxCPU from orion.nodes n left join ( select NodeID, max(MaxLoad) as…

To make it searchable you might also try this in the search box of the custom query resource SELECT UserName, IPAddress, ConnectedTime FROM Orion.ASA.RemoteAccessSessions WHERE SessionStatus = 1 and (UserName like '%${SEARCH_STRING}%' or IPAddress like '%${SEARCH_STRING}%')

A good place you could start if you wanted to try to disable some things in bulk is Settings > All Settings > NODE & GROUP MANAGEMENT - Manage Pollers, you should be able to disable the topology pollers and routing pollers and such across many devices there. Keep in mind that turning them off will obviously prevent you…

The article mentions the minimum version for that feature is 2019.4 so you have to upgrade the whole application to at least that version to use the command.

Where are you using this query? If it is inside a custom alert variable then that is working as intended, those are supposed to pull back a single cell of data. There is a trick with custom sql and a command called for xml path where SQL can take a whole table of data and the SW engine will interpret it as a single cell,…

Just as some datapoints for you, we run a load balanced pool of 4 AWS. Nobody really touches the real web console except me. Each web server only has 2cpu/4gb and they tend to run relatively hot, ~75-100% cpu is pretty common but user experiences seem to be generally acceptable. According to another tool I monitor them…

If you are using a custom chart resource a relatively quick and dirty solution would be to write a where condition that only includes values between 0-50. Won't help with the native widgets or perfstack though. Can't think of anything that would solve those short of something like a trigger on the table inserts or a…

Alert definitions is legacy stuff, nothing you have now should come from that table. Alert configurations is where the web based alert stuff lives. The actual alert messages and their details live on orion.actionproperties, but you will need to join through orion.actionassignments to get to them from alertconfigurations. I…

First line will be select top 10 etc

Most people rename the components from the default to something descriptive, like the service name in this case.