Lofstrand · Solutions Architect · ✭✭✭✭✭

Great suggestion @tphelps01 , please put it under Server & Application Monitor (SAM) Feature Requests - THWACK so that it's more visible.

That sounds a bit strange. I did a test here, added another IP address on an Interface. Did a rediscover in Solarwinds and the new IP address was there. Then I removed the address from the device and did a new rediscover and the IP address was removed from the device and the NodeIPAddresses table. Right away. If you press…

Those tables should only show current values. Can it be that the interface actually have two addresses? Check with SELECT TOP 1000 NodeID, IPAddress, IPAddressN, IPAddressType, InterfaceIndex, SubnetMask FROM Orion.NodeIPAddresses where IPAddressType='IPv4' and nodeid=860

See https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions for all available functions in SWQL

Hi @kumarsw DateAdd is not working in SWQL. Here you can use "AddHour" instead. But, if you are interested in converting the UTC time zone into your local time zone, it's easier to use "ToLocal()" SELECT TOP 10 ADDHOUR(-6, E.EventTime) AS [Time of Event], ToLocal(E.EventTime) AS [Local Time of Event],…

Looks like the html format allows for html code to be added. Color, not sure about. Think this is new in 2026.1. New is also that you can add your own color mapping, in for example a Pie chart. @chad.every, do you have more info around this?

That index looks like it belongs to the VNQM module. I have had situations before where indexes interfered with upgrades. I'm on 2026.1 but I don't even have that index. Have you or your dba created it? In case of self created indexes they do can interfere with the upgrade scripts (But can also be that the index is removed…

The account does not have to be domain admin, but normally it has to be local admin on the server to be monitored with WMI WMI requirements for SolarWinds accounts You can also use gMSA to not be needing to change the passwords every now and then. Or use an agent.

Can be that the mib db file is locked by other applications. Check this article: MIBs database installer fails to complete successfully in SolarWinds Platform 2025.2, 2025.4 and 2026.1

There is a difference between SQL and SWQL. I would recommend that you use SWQL - SolarWinds Query Language. That does not work in SSMS, instead you can download the free SWQL Studio here : https://github.com/solarwinds/OrionSDK/releases

Hmm, ok. What type of integration are you using? For CMDB data I have mainly worked with a SNOW MID server and there you write the SQL query towards SolarWinds yourself.

I have never used that MP but I guess this can be because the API port changed in version 2024.2. If you somehow can make the MP call solarwinds api on the new port there might be a chance to get it working.

If you click on the active alert, you should get to the "Active Alert Details" page. There you have a widget called "history…." There you can see if the actions for the alert have been triggered: There is also a log for the alert actions on the solarwinds server, C:\programdata\solarwinds\logs\orion\alertactions.log…

Hi @sivananda - We are talking about the SQL high availability here, not the SolarWinds High availability. SQL HA does not HAVE TO be disabled, but in this case it seems that it was a safer choice. But you are right that SolarWinds HA must be disabled during the upgrade as of now.

Currently there are no good way of adding more categories. I suggest you create some other field for ServiceNow integration. Either dynamically in the integration or with a Custom Property.

Looks like you got a AG failover during the upgrade. The odds of that happening are low. But to be sure, yes, you can switch to async or just disable auto failover during the upgrade.

Hi @knightyomega Great you found a solution. But I had to try another approach :-D I don't have any VM's in my lab so it's not fully tested but hope it will work. I have here excluded all VM's that have a NodeID, as they are counted as Nodes. So we don't count some devices two times. SELECT Count(N.NodeID) +…

Hi @mato1964 This will be about optimizing any MS SQL database, utilizing SolarWinds Plan Explorer Plan Explorer is the community-favorite free tool designed to make query tuning intuitive. In this webinar, we’ll show you how to: - Visualize plan diagrams more clearly than ever. - Identify the most "expensive" operators at…

You could use the built in monitoring, AppInsight for Active Directory (I guess that is what you are using). When there is a replication issue, have an alert trigger that powershell script of yours. Then have a second action to notify you in the alert that triggers 10-20 minutes after the first powershell action IF the…

As that version has been End-of-Life for almost two years, there is a big chance support can't provide that file to you. But that is your best option. End-of-life means that: "SolarWinds will no longer provide technical support" Same goes with your Windows and SQL environment, they are EOL from Microsoft.

Sending you a PM

Hi @lloyd267 , I suggest you check with support on this one. So they can get a deeper look into all the moving parts here.

As Vinay.By says, that version is not available anymore and not supported. If you are under an active support contract you could reach out to support to either get a download link or discuss what versions that you might be able to upgrade to.

The only certificate that you can do anything about in the config wizard is the certificate for the website. And the APE does not have a website. SolarWinds do have certificates for internal communication, but those you should never need to adjust. Then there might be that you have a certificate on the SQL server, can it…

Hi @vandu Not sure I understand exactly what you mean. I guess you can use the query as a base if you want to calculate errors in relation to bandwidth also.

Not sure if this is new in 2026.1, but here you can set your own colors of the "blocks" in the donat bar. I have for the "Color mapping" field, a hex value for the color I want. I get them here from color column in Orion.StatusInfo

Hi Not sure it will look that good if you add trigger- and reset condition. They are in xml. A simple node down trigger looks like this: (Added field is "ac.trigger") <ArrayOfAlertConditionShelve xmlns="http://schemas.datacontract.org/2004/07/SolarWinds.Orion.Core.Models.Alerting"…

The account SolarWinds platform is using to connect to it's own databases, only need to be db_owner on the solarwinds databases.

Hi The variables depends on what you alert on. On below examples I have assumed that your trigger condition is set on "Hardware sensor (node)". IP-address - ${N=SwisEntity;M=HardwareInfo.Node.IP_Address} Node name - ${N=SwisEntity;M=HardwareInfo.Node.Caption} Manufacturer - ${N=SwisEntity;M=HardwareInfo.Manufacturer} Model…

Number of logs are easy (as I already had that query….) Below shows number of logs per day, per type. Use it as a baseline: SELECT COUNT(L.LogEntryID) AS NrOfMessages ,DATETRUNC('day',L.DateTime) as Day ,l.LogType.DisplayName FROM Orion.OLM.LogEntry AS L GROUP BY DATETRUNC('day',L.DateTime),l.LogType.DisplayName ORDER BY…