brianbooher · Network Engineer III · ✭✭✭✭✭

Thank you NVSteven and cnorborg. I had changed the retention period to 59 days about 2 months ago and have not noticed an appreciable performance impact and my solarwinds db hasn't increased all that much. But, once I get my import script from Solarwinds db to Prometheus working, i would revert my data retention time back…

So I have a new query, based on yours, that does what I want and includes the Reason for muting or unmanaging: SELECT n.Caption AS [Node],'/Orion/images/StatusIcons/Small-' + n.statusIcon as [_IconFor_Node], n.detailsurl as [_LinkFor_Node], CASE when s.ScheduleTask.AccountID is NULL then '' ELSE s.ScheduleTask.AccountID…

Let me check that out. I had separate custom queries, one for muted and one for unmanaged. While it's possible to both "unmange" and "mute" nodes, if you unmanaged a node it is also muted. I like how your query combined both into a single table and I plan to implement that in the single custom query rather than the two I…

Thanks for the input. This Custom Query lives on my main dashboard which isn't yet a "Modern Dashboard" so I must use a Custom Query object and put a SWQL query into it. I'll try and extract the SWQL from the text file you shared. For the 2nd report, you. didn't include the Reason, which I believe is new as of 2025.4.1 (at…

Here's the custom query I use to show all the nodes that have been muted (we would mute and forget to unmute so we were missing alerts) SELECT T2.Caption AS [Node],'/Orion/images/StatusIcons/Small-' + T2.statusIcon as [_IconFor_Node], T2.detailsurl as [_LinkFor_Node], T2.IPAddress, CASE WHEN t1.SuppressUntil IS NULL THEN…

I'm kinda stumped. I do a daily report showing what nodes are muted or management is disabled and I'd like to include the contents of this "Reason" column. But I cannot for the life of me figure out how to link this value back to the node.

Thanks so much. I found it. Now to figure out how to associate that table with the node to which it applies. -Brian

I agree with this feature request. I'd like the ability to add notes to groups as well as individual nodes.

Yes, this would be quite useful. Please add this feature.

Why thanks for the reminder. I put both my alerts into the Content Exchange, Solarwinds Platform,Alerts. Enjoy!!!

There are two values in Solarwinds that I wish to have persist if the device were to go down. They are Service Tag, which is always the device Serial Number and Model which is more reliable and accurate than Solarwinds "Machine Type". I created a custom property for each of those and have a weekly Alert that scans all my…

yes, you were right, adding the fields in my query to the "group by" did not do what I wanted it to do. However the query you created does EXACTLY what I want it to do. Thanks so much. 

I figured it out. I used a wrapper around the function I use to tell Solarwinds to scan nodes. What used to take days now takes less than an hour. Wrapper is to run Netmiko commands on a bunch of devices but you can use the same syntax and substitute your own SWQL function for the Netmiko one: import asyncio from netmiko…

anyone? anyone from Solarwinds care to comment?

Yes. Solarwinds is SO CLOSE to being decent with monitoring Thin AP's off of a controller - but no cigar.

Won't work. We have some AP's that are down but we want to track and eventually bring back up and some AP's that we've swapped out. The setting I could change would delete ALL down AP's. Not good. We have thousands of AP's.

I don't want them to age out. With Cisco WLC's, you are required to have Cisco Prime to manage your WLC's as the WLC "forgets" about a thin AP soon after the AP goes down. We need to make sure we are tracking them so we can bring them back up. Rather than using Cisco Prime, I wanted to use Solarwinds to track AP's even…

Thanks bobmarley. Unfortunately the wireless thin AP's aren't "nodes" and are in their own table, which SWQL won't allow deletes from. I've seen other posts about using SQL which I guess I'll have to do but won't script. Fortunately I only occasionally need to delete thin AP's.

Because they were replaced. I now have the new AP and the old AP listed in Solarwinds but the old one is showing as "down". 

Thanks so much. That would be the issue.

That was it. I had inherited my Solarwinds installation and the account we used for SWQL was limited to access only a single group. There was a lot in that group so I hadn't really noticed how much it was missing until now. Thanks to all for your assistance in this. -Brian

Nope, using the same account when I log into SWQL Studio as I do when I log into Orion and create the all Nodes report or view all nodes in the Manage Nodes page.

I created an All Nodes report and it returned 5310 rows. I ran the query you provided and it returned only 7 rows.