I did like to extract the below fields onto a report, can someone please help me with SWQL query or SQL query ?
The below SWQL query does provide
SELECT U.Duplex, N.Caption, U.MACAddress, U.Name, U.PortDescription, U.PortID, U.PortType, U.Speed, U.StatusDescription FROM Orion.UDT.Port U
INNER JOIN Orion.Nodes N ON U.NodeID=N.NodeID
WHERE N.Caption LIKE '%ABC%'
But this does not provide all fields though - U.Duplex provides a number 0/1, I need to print this as Full Duplex on the report rather than printing it as 1 and I also need VLAN number on this report.