I am trying to find node details by searching with serial number of switch stack members entity of a node. Is this issue due to SolarWinds Upgrade to 2026.2.2 ? or something else ?
Sorry, can't tell exactly what you are doing here? Are you doing an SWQL query? Or doing a search from somewhere else?
I am referring to the SolarWinds Search functionality in the Web Console, not an SWQL query.
I am trying to locate a node by entering the serial number of a switch stack member that belongs to the node. The serial number is visible in reports and inventory information, but when I use the same serial number in Global Search, no results are returned.
My question is whether this behavior is expected because the serial number is stored as a Switch Stack Member inventory entity rather than a searchable Node property, or if there is a known issue/change after upgrading to SolarWinds Platform 2026.2.2.
To validate the data exists, I can retrieve the serial number through reports and/or in Node Details. The issue is specifically that Global Search is not returning the associated node when searching by the switch stack member serial number. Could you confirm whether Global Search is expected to index and search switch stack member serial numbers?
Saikiran can you please confirm..
If all of these are correct, the issue is not with SolarWinds but rather with Cisco. Cisco will only supply the serial # of the parent switch, which is what SolarWinds picks up and runs with. However there's a different OID that supplies the serial #'s of the children stack members and this is what the stack switch report reports on.
The serial number for the parent stack switch and the children stack switch(s) are contain in 2 different DB tables in SW, which makes it a challenge to have a nice report or dashboard view. Which is why I created a modern dashboard view and a classic widget that supplies all the serial #'s for a stacked device.
Both of them are in the content exchange, but if you want I can post them here as well.
Hi, Global Search is not looking at devices serial numbers. If that is needed, a custom query table widget can be created that includes serial numbers.
Hi @Saikiran1 , I don't think you can do that on default search view. SolarWinds always pull the service tag (serial number) of Primary member when it's a switch stack. SolarWinds does show all serial number on stack view but that's only available on the node details page. When you do a search on default search view it only checks for primary member serial. I could be wrong and I am not sure how does it work in the lattest version, if you could add some additional context it would be helpful to figure out what exactly you are looking for.
Global Search does not search device serial numbers. To support serial number lookups, a Custom Query Table widget can be created to display device details along with their serial numbers.
Yes, if you add a resource to a page of type "Custom Query", you can easily accomplish this. Here is how I do it, I'll put the search query below.
Full query
SELECT Replace(N.DisplayName, '.domain.com', '') AS Node, N.IPAddress , N.HardwareHealthInfos.ServiceTag AS [Master Serial], SS.SwitchStackMember.SerialNumber AS [Stack Serial], SS.SwitchStackMember.SwitchNumber AS [#] , N.HardwareHealthInfos.Model , '/NetPerfMon/Images/Vendors/' + N.VendorIcon AS [_IconFor_Master Serial] , '/Orion/images/StatusIcons/Small-' + N.StatusLED AS [_IconFor_Node] , N.DetailsURL AS [_LinkFor_Node] FROM Orion.Nodes N JOIN Orion.HardwareHealth.HardwareInfo HI ON (HI.NodeID = N.NodeID) LEFT OUTER JOIN Orion.NPM.SwitchStack SS ON (HI.NodeID = SS.NodeID) WHERE (SS.SwitchStackMember.SerialNumber LIKE '%${SEARCH_STRING}%') OR (N.HardwareHealthInfos.ServiceTag LIKE '%${SEARCH_STRING}%') OR (N.DisplayName LIKE '%${SEARCH_STRING}%')
ORDER BY NodeID, SS.SwitchStackMember.SwitchNumber
I trim the domain name off the nodes, which is the "Replace()" part early on. Just put in your domain name to have it removed.
This ends up looking like this on whatever page you put it on.
If your comfortable with creating a modern dashboard here's a SWQL query I have that our Networking Team and Asset Management team uses to find serial numbers for stacked and non-stacked nodes.
SELECT DISTINCT n.DisplayName AS [System Name] , n.IPAddress as [IP Address] , n.Status , n.StatusDescription , n.DetailsUrl , n.vendor , n.VendorIcon , n.ModernIcon , n.Category , n.MachineType , CASE when n.SwitchStack.SwitchStackMember.Model is NOT NULL then n.SwitchStack.SwitchStackMember.Model ELSE n.MachineType END as [Stack Machine Type] , n.VendorInfo.Icon AS [System Vendor Icon] , CASE when n.HardwareHealthInfos.servicetag is NOT NULL and n.SwitchStack.SwitchStackMember.SwitchNumber is null then n.HardwareHealthInfos.servicetag when n.HardwareHealthInfos.servicetag is NOT NULL and n.SwitchStack.SwitchStackMember.SwitchNumber is not null then n.SwitchStack.SwitchStackMember.SerialNumber when n.F5Devices.F5Servers.Device.SerialNumber is not NULL then n.F5Devices.F5Servers.Device.SerialNumber when n.CustomPollerAssignmentOnNode.CustomPollerStatus.AssignmentName like'APC_UPS_Serial_Number%' then n.CustomPollerAssignmentOnNode.CustomPollerStatus.Status END as [Chassis Serial] , CASE when n.SwitchStack.SwitchStackMember.SwitchNumber is not null then n.SwitchStack.SwitchStackMember.SwitchNumber Else '1' End as [Switch Stack] , CASE when n.SwitchStack.SwitchStackMember.Role = 1 then 'Leader' when n.SwitchStack.SwitchStackMember.Role = 2 then 'Member' when n.SwitchStack.SwitchStackMember.Role = 4 then 'Standby' ELSE 'Leader' END AS [Stack Role] , CONCAT ('/Orion/SSH/Terminal.aspx?NodeId=' , n.NodeID) AS [SSH] FROM Orion.Nodes n ORDER by '[System Name]','[Switch Stack]' ASC
If you enable the search field you can search for any serial number, see the node type, its position in the stack and if it's the leader or a stack member.
