Lofstrand · Solutions Architect · ✭✭✭✭✭

Hi, I would definitely recommend that you open a support ticket on this one, they will assist you with the upgrade issues. Looks like now, that the primary server is excluded. Might something have failed in the validation in the step before this?. Don't think anything is happening.

Take a look in this log file: C:\ProgramData\SolarWinds\Logs\Orion\ActionsExecutionReport.log Might give you some insights. But I sounds like there is an issue with the account that runs the report:

Hi In SQL there is no table called Orion.Nodes, but in SWQL there is one. In SQL there is a VIEW called Nodes that reflects the information in the SWQL table Orion.Nodes. Suggest you do a normal SQL backup of the databases before upgrading. Snapshot of the application server can also be a good idea. Then run the upgrade…

Hi @"arnabmk" As @"mesverrum" said, you can always create your own custom variables for any data available in the database, if not a prebuilt variable exist. Try below custom variable: ${N=SWQL;M=SELECT D.name FROM Orion.DPA.DatabaseInstance AS D WHERE D.DatabaseInstanceID=${N=SwisEntity;M=DatabaseInstanceID}}

Got 2025.4.0 in my lab and there is no index for currentValue there either. What is trying to use that index? Or is it just SQL saying it want that index?

Hi, All the events are available for you to GET trough the API, but there are no good way to PUSH all the events from Observability. Can you have Elastic to get them for you? Otherwise you will create som script that gets them and pushes them.

@"anish.888222" If you take the calculated hash and search for it on https://www.solarwinds.com/product-checksum you will find that this hash is also 2020.2.6. Apparently there is an may and an august release of that version. You seem to have the august version.

Hmmm, copied your code and it works just fine on my side. What entity type have you based your alert on? I used "Custom Table Poller Current Status"

New version where you don't have to add the name of the UnDP either. This is for SWQL ${N=SWQL;M=SELECT CPS.RowLabel AS Label FROM Orion.NPM.CustomPollerStatusOnNodeTabular AS CPS WHERE CPS.CustomPollerAssignment.CustomPoller.UniqueName='${N=SwisEntity;M=CustomPollerAssignment.CustomPoller.UniqueName}' -- name of the UnDP…

Hi @"trilobite_rex" A couple of things I see is that the AssignmentName is often something like "ifHCOutMulticastPkts on lab-nexus-3000". Not just the UnDP's name. And all the conversions should not be needed. Also worth noting is that simulate alert does not always work. If in doubt, adjust thresholds so you get a "real…

To only include interfaces with a specific custom property, add that property to the where-filter Below is an example where I have added a filter for the interface custom property "Carriername" should be equal to "xx". Just adjust this to your need. WHERE E1.NetObjectType = 'I' AND E1.EventType = 10 -- Interface Down AND…

Try this one: SELECT N.Caption ,N.ObjectSubType AS PollingMethod ,Count(P_CPU.PollerID) AS CPU_Pollers ,Count(P_Mem.PollerID) AS MEM_Pollers ,ISNULL(I2.qty,0) AS Interfaces FROM Orion.Nodes AS N LEFT OUTER JOIN Orion.Pollers AS P_CPU ON N.nodeid=P_CPU.NetObjectID AND P_CPU.NetObjectType='N' AND P_CPU.PollerType LIKE…

No, I don't think you need to delete the old before adding the new. 

Sorry, it's a bit to easy :-) Just add the license, SOMETIMES it want a restart of solarwinds services but most times that is not necessary. Could take a few minutes before all new features are fully started in the backend. But normally, just add the license and take a coffee - then enjoy the new possibilities 

Hi Go to license manager, on the settings page. Add the HCO/Observability license (I'm almost 100% sure all other licenses will be automatically removed then). That's it!

Everything in the first box is the "variable". So the part that starts with ${SQL:... , add that to wherever you want that information to be. The second picture is an example of how it looks like if you add the variable in the alert Like this:

There doesn't seem to be any prebuilt, but we can always build one ourselves with "Custom variables". Here we write our own SWQL or SQL code to get the data we want. The issue here is that a variable can't include several rows. So a normal query would here give us one row per member and that's not allowed. We need to merge…

Hi @"ojoj" How about using the variable "Group Stautus Root Cause", ${N=OrionGroup;M=GroupStatusRootCause}. That will give you a list of all group members that is "causing" the group status.

Hi, It might be both in db and file. Background maps will be stored on disk and the map config will be stored in database. If you look in MS SQL, not SWQL, you have the tables dbo.maps_*. Yes, it's several tables. dbo.maps_projects is the main one. Other tables might have data depending on what features your map has. In…

No, I haven't heard about that before. Suggest you log a case with support so they can have a look and potentially create a fix

It's as @"bobmarley" wrote. There you have all the syslogs and traps. To know what devices are sending log you can start with below query that shows how many messages that are sent per device. (Remove "TOP 20" to see all devices) -- Traps and syslogs per node SELECT TOP 20 COUNT(L.LogEntryID) AS NrOfMessages…

Have you tested to create an alert rule like this:

If you give a person administrator rights within SolarWinds Observability – Self Hosted, or NPM, that is the required permission to be able to adjust accounts, that person can change all accounts. Including their own. You can't filter what accounts that person can adjust. 

Here you go @"naveensingh43" (+) Mute interface due to Neighbor down and unmanaged - Scripts - The SolarWinds Platform - THWACK

I have a script that Mutes an interface if it's connected to a device that is muted - and Solarwinds topology knows about the connection. If that is what you are after I'll upload it here on thwack.

Hi, controls if the node should be in the vulnerability calculations found on this page: If you change the value, that change will be reflected upon the next CVE Node matching run (once a day by default)

If I need to have groups, many times I build the dynamic membership queries on the Custom Properties, CP, values. To handle the Custom Properties values automatically I use scripts, as you said (and didn't like) but I also sometimes create alert rules that sets my values. I call the alert rule something like "System -…

Ok, you need to first create some monitoring on failovers. So that SolarWinds know a failover has happened. I see two simple ways here: Create a Windows Event Log Montor - documentation.solarwinds.com/.../sam-windows-event-log-monitor-sw3329.htm Create SQL Component monitor…

Ok, the next step is to see if the monitoring of the SQL failover is working. How are you monitoring that SQL has done a failover? Did monitoring see the failover? What kind of SQL HA is this? WFC or AG? When we know that we can continue troubleshooting.

Hi, I have no idea on how GovNotify works but I would start to look in the alert logs. If the alert triggers when the failover occurs, then the actions should trigger at the same time. See these logs for issues C:\ProgramData\SolarWinds\Logs\Orion\ActionsExecutionAlert.log…