bobmarley ✭✭✭✭✭

You could always make your own custom SWQL widget and do the sorting in the query. The query below will look similar to the one that comes out of the box but nodes are ordered by the time they went down. If there are custom properties that you want to include uncomment and edit the Group below. SELECT NodeName AS [Node…

The upgrade completed and so far only a couple minor issues. 

I ran it 

Am I supposed to wait or run it at this point, it is just spinning?

Look on Thwack under Content Exchange - Orion Platform- Custom Queries, or Modern Dashboards, or Reports. There are many examples there. This one is under Custom Queries Unmanaged & Muted Nodes (with a Node Custom Property Filter] - Custom Queries - The Orion Platform - THWACK (solarwinds.com) This is how to use the above…

If you want to get alerted you can use something like this alert trigger 

SELECT TOP 1000 AuditEventID, ToLocal (TimeLoggedUtc) as LocalTime, AccountID, AuditEventMessage FROM Orion.AuditingEvents Where AuditEventMessage LIKE '%unmanaged%' OR AuditEventMessage LIKE '%muted%' AND AuditEventMessage NOT LIKE '%username%'

Thank you, I did save the query as we are upgrading soon and will need to add the new database. Will need to change some of our custom SWQL alerts to read from this one. 

They user would first need to have the powershell plugin installed, then have an account that allowed node management. Since all of the unmanage or mute events are kept in the audit log you could easily set up an alert to notify when it occurred. SELECT TOP 1000 AuditEventID, ToLocal (TimeLoggedUtc) as LocalTime,…

I am seeing it as well

(+) How to mute node with Powershell - Orion SDK - The Orion Platform - THWACK (solarwinds.com)

I didn't get to play with it a lot but this partially works. It will mute nodes from a list of IP's. The Unmute uses a different verb and I wasn't able to figure out how to get that one working at the same time. If you comment/uncomment the mute and unmute lines they both work independently, but not at the same time. At…

Here is how to unmanage, you can change the script to mute instead How To: Powershell - Unmanage Nodes with future unmanage and remanage time/dates - Forum - Network Performance Monitor (NPM) - THWACK (solarwinds.com)

Updated my test system yesterday, had a couple strange errors pop up but the upgrade finished and the system is running fine. Doing my production one in a couple of weeks.

If you dig into the database a bit you will see there are serial numbers collected in a lot of different places. A node such as a UPS can have a serial Number for the web management card, a serial number for the chassis, a serial number for the system board, etc... For the systems I manage I made my own custom property for…

I was supplied with a script that removed everything from support during a system down event. It cleaned up the system so I could do a re-install. It probably isn't something they share out. 

Another thing I run into with the matching criteria is some of my nodes have short names and some have fully qualified names so in general I just match on IP Address and set caption to 'do nothing'. That helps when you may have a mismatch in the caption field from your spreadsheet and what is in Solarwinds. Typically for…

Have you tried running a Network Discovery?

Try contacting Solarwinds Support and ask if they have an uninstall script.

If you are asking about Worldwide Maps click Edit Then use SWQL to filter the map, shown here I'm using Custom Properties, you can use whatever you wish.

(+) SSL certificate monitoring - Forum - Server & Application Monitor (SAM) - THWACK (solarwinds.com) is another one. I used a powershell script to monitoring a URL that @KMSigma posted but I cant find it right now. Here is a similar script that you would need to manually add your URL to where google.com is shown. $site =…

How to Monitor an SSL Certificate and Create an Alert in SAM When There Are X Days Before Expiration (solarwinds.com)

There are several similar posts if you Google 'solarwinds create group powershell' PowerShell Group Creation with Dynamic Query - Forum - Network Performance Monitor (NPM) - THWACK (solarwinds.com)

We have many different models of UPS's from several different vendors. Solarwinds does not natively collect all of the serial numbers for them. We created several custom pollers and gabe them names like APCSerialNumber, EatonSerialNumber, etc. We use an alert action to populate a custom property that we created named…

Nice work! There were a couple typo's in top query but Ctrl +f found those pretty quick.

Disable sending syslogs to the Orion system in the Netscaler and those message should stop. 

Give this a try, it is pulling the Node status and Interface status tables. I don't have any interfaces down to test with at the moment so adjust the query to fit your needs. The Node status should always be a 1 if it is up, then the interface status will be something other than a 1 if the node is up AND an interface is…

Reboots are stored in the Events table, this should get you started SELECT [Nodes].NodeID , [Nodes].IPAddress , [Nodes].Caption , [Nodes].MachineType , [Nodes].Events.Message , [Nodes].Events.EventTime AS EventTimeUTC FROM Orion.Nodes AS [Nodes] Where [Nodes].Events.Message LIKE '%reboot%' AND MachineType LIKE '%Cisco%'…

I haven't done it but it seems possible, have you tried? You could probably just as easily write the whole alert in SWQL?

Solarwinds always points to not directly changing the database. They usually will tell you to use the API to make changes. There are plenty of examples here on Thwack of on Github on how to add nodes in bulk.