I need some help whit this SQL script i have used in the Report. Need to get the Status of the interface if its up or down and whit LED icon. Can anyone help whit this?
Interfaces.nodeID AS NodeID,
Nodes.Caption AS NodeName
interfaces.caption AS InterfaceName,
Right join nodes on (nodes.nodeID = interfaces.NodeID)
Left join NodeIPAddresses on (NodeIPAddresses.nodeid = interfaces.nodeid AND NodeIPAddresses.InterfaceIndex = interfaces.interfaceindex)
WHERE (NodeIPAddresses.IPAddress IS NOT NULL AND Nodes.Caption like 'SB1-%')
ORDER BY Nodes.Caption, interfaces.caption
Solved! Go to Solution.
you can try something like
select interfaces.nodeid as [nodeid], nodes.caption as [node name], interfaces.caption as [interface name],interfaces.interfaceindex as [interface index],interfaces.status as [status id],statusinfo.statusname as [status],
join nodes on nodes.nodeid = interfaces.nodeid
join statusinfo on statusinfo.statusid = interfaces.status
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.