Lofstrand · Solutions Architect · ✭✭✭✭✭

Like this: WHERE (Caption NOT LIKE '%imbox%' AND Caption NOT LIKE '%atm%')

Not sure I fully understood the question, but here is a new version where we filter to only show nodes where the custom property field "environment" is LIKE "%LAN & WAN%". Hope that at least give you the guidance to adjust according to your need: SELECT ROUND((100.0 * COUNT(N1.NodeID) /( SELECT COUNT(N2.NodeID) AS Nodes…

Hi @KOHLIfied It's as @vinay.by says, to receive traps or syslogs, the basic LV that comes with NPM, for example, is sufficient. It does not require an extra license. If you have any of the Observability licenses, essentials or advanced, then LA is included and LA can handle more log formats and create more action types.

Like this? A KPI widget based on below SWQL query: SELECT ROUND((100.0 * COUNT(N1.NodeID) /( SELECT COUNT(N2.NodeID) AS Nodes FROM Orion.Nodes AS N2 WHERE N2.Status NOT IN (11,9,27) -- Unmanaged, external and disabled ) ),2) AS PercentOK FROM Orion.Nodes AS N1 WHERE N1.Status=1 OR N1.Status=2 -- Up or Warning

Hi @abadshahc Different vendors show VPN login failures in different ways. And different cause of issues might be logged in different ways. So I you have issues from time to time, that give you above error - then it could be a good way of doing it. I would probably use only a part of that string, like SAML Agent:…

Hi @MiltondotCom Network Sonar Discovery is not used for scanning for IP subnets, but for nodes to monitor. Either set up your IP subnets manually, and then, if you want to, let IPAM scan those subnets for used addresses. But you can also use "Discover subnets" in IPAM: There you can scan for example a router that can give…

The function "ToLocal" converts the [Time] to local by the running application. For example if you run it in SWQL studio, it's local to where you run SWQL studio. If you run the query in a widget, it's local to that web browser. (I think the explanation on the SWQL Functions web page is wrong here)

Can it be that your SolarWinds server is not trusting the supplier of that certificate? If you take a web browser on the solarwinds server and go to that url, what does it say then? Does it accept the certificate?

How the architecture should be set up depends on the requirements and the network in where it should be. But all your options are described here: https://documentation.solarwinds.com/en/success_center/orionplatform/content/orion_platform_scalability_engine_guidelines.htm

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