maciej.sandecki · IT Consultant · ✭✭✭✭✭

Try using SWQL custom variable in your action like this: ${N=SWQL;M=SELECT n.CustomPollerAssignmentOnNode.CurrentValue FROM Orion.Nodes n WHERE n.NodeID = ${N=SwisEntity;M=NodeID} AND n.CustomPollerAssignmentOnNode.CustomPollerName = 'your_custom_poller_name'} Replace 'your_custom_poller_name' with the name of your custom…

Try referencing ${NodeID} for node and ${InterfaceID} for interface.

Have you tried this?: * change N=SQL to N=SWQL (you are using SWQL syntax, so keeping SQL will cause errors because entities like Orion.NPM.CustomPollerStatusOnNode are not known) * make it one-liner (remove all new lines, tabs, keep only spaces) and remove comments * remove the trailing ; (before closing } ), not sure if…

You can try disabling this setting in Advanced Configuration (/Orion/Admin/AdvancedConfiguration/Global.aspx): HTMLResourceSanitizationEnabled (and maybe also this one: EnableHtmlLinkSanitization).

Since you mentioned your servers are not joined to the AD then I don't see how you could use Integrated Security (with Kerberos Delegation) at all. Same is mentioned in the first link you sent - all servers need to be in the same domain. I guess you should use SQL Authentication instead.

This reply was written using ChatGPT and the query has multiple bugs (e.g. there is no DATEDIFF function in SWQL, AlertHistory entity doesn't have ResetTime column and AlertObjects doesn't have EntityID column).

Please note these points: * Warning status may not always mean an alert was triggered (unless you have alerts configured based on status only) * You may want to add Critical (14) status to the conditions * In my environment I see strange behavior where the Orion.NetObjectDowntime table reports Warning status for node that…

See if this gives you what you need SELECT n.AlertObjects.AlertHistory.TimeStamp, n.Caption, n.IPAddress, n.AlertObjects.AlertHistory.Message FROM Orion.Nodes n WHERE n.AlertObjects.AlertHistory.TimeStamp >= ADDDAY(-30, GETUTCDATE()) AND n.AlertObjects.AlertHistory.EventType = 0 ORDER BY n.Caption,…

This doesn't look to be editable via API / SWIS.

As SNMP statistics for the interfaces are refreshed every 9 minutes, you would need to check the last (newest) value for an interface in Orion.NPM.InterfaceErrors entity. I believe you will need to build a custom SWQL trigger condition for this.

I believe there is not much else we can do here in the forum. You already know the way to test different pollers and if you believe none provides you with the correct data, I suggest opening a support case with Solarwinds and checking some of the examples you have more in depth. BTW. In my environment I also see many Cisco…

What command are you using on the switch to check CPU load? Is it 'show process cpu'? Which metric is showing 6% (5 seconds, 1 minute, 5 minutes)? Note that Solarwinds by default polls this data every 9 minutes and it appears to be using 5 minutes value from SNMP (OID 1.3.6.1.4.1.9.9.109.1.1.1.1.8). But it looks like the…

How would you like to have the alert history presented in the same query / report? Could you draft the report layout (columns, data types), so that the query could be adjusted to match your needs?

Hi williammy, Give this a try and let me know. SELECT n.Caption, n.IPAddress, SUM(n.NodeDowntimeHistory.TotalDurationMin) AS TotalWarningOrDown, COUNT(n.NodeDowntimeHistory.TotalDurationMin) AS NumberOfWarningOrDown FROM Orion.Nodes n WHERE (n.NodeDowntimeHistory.State = 2 OR n.NodeDowntimeHistory.State = 3) AND…

Since the only changing value here is AlertsPer and the alert triggers when AlertsPer >=1, then it should automatically reset when AlertsPer goes to 0 (so the node URI is no longer returned in the set). So isn't the 'Reset this alert when trigger condition is no longer true' working in this case?

Hi geo1 I have C9300 on IOS 17.6.5 and CPU/MEM pollers are working well. Please check by logging in to the main polling engine and running SolarWinds.PollerChecker.Gui.exe from the Solarwinds installation folder. Then find your device on the list (you can paste name in the Filter field), select it, select Cpu and Memory in…

I don't think this is how NPM works. You need to select the resource first (in List Resources), NPM then assigns a poller and starts polling the data into respective table. Some resources don't have a simple status (e.g. L2 Topology, VLANs). What you still could try is compiling a list of different data polled for a node,…

Could you provide more information on way agents are installed? Agent or server initiated mode? Could you send a screenshot from Settings -> Manage Agents? By 'not checking in with the server' do you mean the agents are not registering with the server or that they appear Down after registration? Are you able to edit…

Were you checking with netstat? Version 2025.1.1 definitely uses 17774 and it should be running automatically, no special configuration needed, unless for some reason you have REST endpoint on 17774 disabled in Advanced Configuration (/Orion/Admin/AdvancedConfiguration/Global.aspx, DisableSwisRestEndpointOnPort17774)

I think this should be in C:\ProgramData\SolarWinds\InformationService\v3.0\Orion.InformationService.log, but you may need to increase the logging level, as with default Info I don't see it there.

Depending on how the agents are installed (agent initiated or server initiated polling), you may need to check on the server logs or the agent logs. You may try increasing the logging level on server and agent to see if you get additional clues from the logs. Also, were there no changes in any firewalls between the server…

Port 17778 is deprecated in the latest versions of Solarwinds for API access. Use port 17774 instead. I have this integration working in my environment, using a local Solarwinds user with limited rights. If you get certificate errors (untrusted certificate), you may need to skip certificate checking in ServiceNOW…

We noticed the same issue after upgrade to 2024.4.1. Which version are you at?

Check here on how you could create the entry in NodeSettings if it didn't exist via script: thwack.solarwinds.com/.../how-to-update-settingvalue-in-nodesettings-table. Or here for CRUD: solarwinds.github.io/.../

I may be wrong, but I suspect there is no value in the database for the checkbox alone. I suspect that when these entries are in the database, the checkbox gets ticked automatically. Could you try to test this theory by manually creating an entry using Database Manager and checking if the checkbox is ticked?

After the inventory job finished today I again had CDP data in NCM.CiscoCdp that could be correctly linked to NCM.Nodes.

Great! I wonder if this is fixed in 2024.1. Would you mind sharing the SQL files?

Hi, I'm on 2023.4.2 since Dec 2023 and it was working okay until now. Today I noticed the NodeID in NCM.CiscoCdp does not reference correct nodes in NCM.Nodes and consequently cannot be linked to Orion.Nodes. I also noticed that my NCM Inventory job completed with an error below, not sure though if this could be the reason…

That's the trick here, only ssh-ed25519 and ecdsa-sha2-nistp256 are supported by this switch.

The implementation of SSH used by Solarwinds does not have support for some new algorithms, so this needs to be fixed by Solarwinds. Recently we came across another switch (Cisco CBS220) that supports only ssh-ed25519 and ecdsa-sha2-nistp256 for server host key algorithms and these two are not supported by Solarwinds at…