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?
select
Interfaces.nodeID AS NodeID,
Nodes.Caption AS NodeName
interfaces.caption AS InterfaceName,
interfaces.interfaceIndex,
NodeIPAddresses.IPAddress,
NodeIPAddresses.InterfaceIndex
from
Interfaces
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