1 of 1 people found this helpful
And so it is: I think I am learning how to fish ....
SELECT E.MACAddress, E.IpAddresses.IPAddress, E.Ports.Port.Node.DNS, E.Ports.Port.Name, E.Ports.ConnectionType
From Orion.UDT.Endpoint E
where E.MACAddress = 'XXXXXXXXXXXX' and E.Ports.ConnectionType = '2'
as well as using a join:
SELECT C.SerialNumber as serial_number ,C.Node.DisplayName as name, C.n_site_id as u_ans_site_code, C.Node.IPAddress as ip_address, C.Node.MachineType as model_number, N.SysObjectID as u_oid, N.NodeDescription as u_description, N.MachineType as short_description, C.Node.IOSVersion as firmware_version, N.LastSync as last_discovered, N.NodeID as NodeID
FROM Orion.NodesCustomProperties C
Inner Join `Orion`.`Nodes` as N
On (`C`.`NodeID` = `N`.`NodeID`)
where C.Node.DisplayName like '%nodename%';
This helped me out a lot!