Have you checked the options in Report Writer? I just looked and see that one can find the Interface Speed, both Administrative Status and Operational Status, and Physical Address (MAC). I do not see Duplex, though.
1 of 1 people found this helpful
If you can't do it with a normal report you could try creating a report using a custom table with SWQL as the datasource
SELECT DISTINCT u.Node.Caption As Node, Name As Interface, PortDescription, CASE WHEN Speed <= 100000000 THEN CONCAT(Speed/1000000,'MB') ELSE CONCAT(Speed/1000000000,'GB') END AS Speed, CASE WHEN Duplex = 1 THEN 'Full' ELSE 'Half' END as Duplex, CASE WHEN Trunkmode = 0 then 'Access' WHEN Trunkmode = 1 then 'Trunk' WHEN Trunkmode = 2 then 'Undefined' ElSE concat(TrunkMode) END AS TrunkMode, CASE WHEN u.Endpoints.ConnectionType = 1 THEN 'Direct' WHEN u.Endpoints.ConnectionType = 2 THEN 'InDirect' ELSE concat(u.Endpoints.ConnectionType) END AS ConnectionType, oui.Company AS Vendor, u.Endpoints.Endpoint.MACAddress AS EndPoint_MAC, u.Endpoints.Endpoint.IPAddresses.IPAddress AS EndPoint_IP, u.Endpoints.Endpoint.IPAddresses.DNSNames.DNSName AS EndPoint_DNS FROM Orion.UDT.Port u LEFT JOIN Orion.UDT.OUIReport oui ON u.Endpoints.EndpointID = oui.EndpointID WHERE IsMOnitored = TRUE -- Only display UDT Ports that are being monitored AND OperationalStatus = 1 -- Port Status = UP AND u.Endpoints.ConnectionType = 1 -- 1 = Direct, 2 = Indirect