mesverrum · Observability Architect · ✭✭✭✭✭

This also reminds me of an old sql dashboard I remember being on here that assigned various weights to different kinds of bad conditions and then made a table of nodes sorted by how unhappy they were. Something like node down would be 1000 points, high cpu might be 200. I've also built swql dashboard for ops teams that had…

I had this exact same issue and the work around we did was just to create an external script running as a 10m scheduled task that polls our Meraki api and sets a custom property on the port 1 and 2 interfaces. Values like Meraki Wan failed, Meraki Wan ready, Meraki Wan disconnected. I threw those all into a dashboard and…

Can't do that with the way limitations work in Orion. What I've seen some people do is set all the privileges and limitations on the admin accounts and then people get read only to everything using their daily driver accounts.

So I do a lot of work with linked databases in my instance. One way you could make this work is to run a sql query as an agent job every so often reaching to the other DB getting a list of all the nodes that are entering or exiting a change window and use that output to set a custom property in Orion. Then just add that…

The most common bottleneck is disk performance, so keep an eye on your disk queue length and latency. An ideal sql server splits the logs and data and tempdb to separate drives with separate queues. If the queue gets long then users are waiting, but ultimately it can only do what your storage is set up to do and that…

The database doesn't scale horizontally, so you don't plan on adding extra servers, just increase the capacity of the server you have. For reference I have 10000 nodes, 200000 interfaces and run it on a sql server with 8 cpu and 200 gb ram. We had more ram before but I experimented for a while and found this was enough to…

I actually did a specific example of this as part of a thwack camp presentation. Its the bottom video on this page thwack.solarwinds.com/.../optimize-all-the-things

There are two parts, inside the section where you create individual users/AD/SAML groups there is a limitations button. Hit that and it will give you a list of attributes you can restrict users with, such as device names and vendors and such. So you could do something like restrict users to only seeing/interacting with…

I have to say if you are doing green field app development you COULD do SNMP, but most people might consider a REST API with a Json output to be more typical of modern software. Under the covers it's going to basically end up being almost the same result, but SNMP is a bit more rigid than JSON.

This is correct, Orion doesn't offer a tool to do web server load balancing because many other tools to do that are readily available. We use GCP cloud internal load balancers at my current job. 

A quick solution that I imagine would work is doing the reset via a swql query that correlates audit events to the regular events table. I'm not at my computer but I am pretty sure they both reference the netobjectid that they are associated with

Just adding I also was not a fan of this change so I switched all my html reports to pdf. Instead of spamming out 5 MB html attachments it's a 40kb pdf. I hate how I had to wait such a long time just to display my reports when they were bloated like that. 

I have a big script that scrapes the snow api each day and has a bunch of cascading logic that helps sift through the various CI classes and objects and picks the one I think is "most correct" and ultimately sets a cmdb_id custom property. So the majority of my environment already knows which CI they are. I also have some…

To me the main limitation to that thing is it only supports unmanage, muting is not available. Also it means that any changes to the schedule have to be done by someone with admin permission on the core application server, I run a pretty large environment and push self-service capabilities as much as possible. I don't want…

At former clients I've done exactly what you describe with the custom undp and swql. I don't have the exact code handy any more but it's doable to correlate the interface index to the port channel object and alert when there is a problem on one of the children. I added a custom property that tagged them so it was easier to…

Responding to why it's not an ootb option, I've been pushing the idea with SW for years that there would be a use case for a lot more calendar based capabilities, but so far it hasn't made it up the priorities list. So the muting and unmanage functions currently rely on a table that is designed to only ever have a single…

Custom properties clean up is incredibly vague. Do you intend to delete properties that are no longer in use, update properties that are incorrect, create new properties to more effectively organize what you have? Could take an afternoon or a month depending on the goals and the quality of data you have available to…

The short answer is yes, it is a lot of admin work to manage this. Orion isn't natively particularly well dialed in to multi time zone situations to begin with, but even as bad as it is just within the platform it really has no idea what the time zone is for your monitored systems so you have to come up with a way to tell…

With the way groups are handled in the tool you always want to just skip over them and focus on properties themselves as the root of your organizational scheme. So you could create an alert that triggers on the same conditions as your group, and have the action be to set the custom property. Then once properties are all…

Not all of the values are listed as being fully crud enabled directly with SWQL, but there is a trick where you can leverage SWQL to make edits to the DB directly if you are feeling brave. The verb is under orion.reporting, you have to be an admin to use it, executeSQL. Keep in mind that the table structure of SWQL is not…

https://documentation.solarwinds.com/en/success_center/orionplatform/content/migrate_solarwinds_to_a_new_server_with_a_new_ip_and_hostname.htm My current company did something similar about 3 years ago towards GCP. Built new VM's, shut down the old stuff, installed the modules, a few SQL adjustments and run the…

So on the back end there is no entity to track for a "rename" of a value. It is just a table of strings with no unique identifier or anything so when you rename it there is really no relationship to previous instances of that string. It would likely require a total rework of the way that custom property values are treated…

Are the alerts actually firing and no change is being made or are the alerts never triggering in the first place? Can you post screenshots of the alert trigger conditions page and the trigger actions. I use many alerts like this and the biggest obstacles i tend to run into are unmanaged or muted objects, and once in a…

Response/latency in npm are interchangeable terms for NPM. They are the round trip time for an up/down check on that node from the polling engine it is associated with. Easiest place to grab it is a view SELECT top 1000 * FROM [SolarWindsOrion].[dbo].[ResponseTime] Keep in mind that for data that has not been rolled up (<…

So the step that lots of people miss is that you need to log into your primary server and run the account limitation builder. Its a little app that lets you pick your custom properties from a drop down, set the type of filter you want to use (i almost always just use check box) and then as soon as you hit okay those…

The UK time is a challenge for me on PST, otherwise I'd be game to lead a couple sessions. I taught the L1 courses on advanced scripting/ database/ reporting many times when I worked for them. If your company has some training budget to burn L1 still does that course and has UK team. It's very hands on and can take someone…

I do something like this with my alert integrations for some tools. I use my script to process to response and then post it back to Orion as alert notes, AUTOSNOW INC1234567 or AUTOJIRA CASE-12345, etc. Then I just added logic to my custom alert widget to left join those kinds of notes as another column. 

Not built in, but everywhere I've been we just rely on AD integration and don't allow local Orion accounts except for special cases like scripting service accounts and such. That way user admin is effectively just synced with whatever you are doing in AD. If you really want to set something up then you could set something…

I'm glad you guys got here to be polite before me because I was in a pretty sarcastic mood. "Why would my enterprise monitoring tool use the protocol that Microsoft developed to allow you to talk to servers on one of my Microsoft servers?" "Because it is ..monitoring.. the server, how else would you expect such a thing to…

This should work, basically when you have a table with multiple rows that you want to turn into multiple columns the easiest way is to filter your column to one kind of row, then left join in the same data with a different filter for the next set of rows, and you can just keep doing that for as many columns as you want to…