Need Help Regarding SWQL Query

samya

Hello all,... I'm struggling with SWQL... It's been a very long time since I have messed with any SQL statements, and Im getting all my data back from my SELECT statment and my LEFT JOIN... However, I'm trying to grab two more columns from another table... I was hoping someone could give me some feedback...  

EXISTING QUERY

SELECT n.NodeID, IPv6.IPAddressN AS IPv6, m.MAC, m.DATETIME, n.DisplayName, n.IPAddress, n.NodeDescription, n.Description, n.Vendor, n.Location, n.Contact, n.IOSImage, n.IOSVersion, n.CPUCount, n.MemoryAvailable, n.TotalMemory FROM Orion.Nodes n LEFT JOIN Orion ometv.NodeIPAddresses ipv6 ON n.NodeID = IPv6.NodeID JOIN Orion.NodeMACAddresses ON n.NodeID = ON m.MAC, m.DateTime

Thank you in advance.

Regards

Samya

stevenstadel

This uses linked properties for the IPAddresses Table and Nodes table and one join to the NodeMACTable

SELECT TOP 100 IPV6.node.NodeID, IPV6.IPAddressN as IPV6, m.MAC, m.DateTime, IPV6.Node.DisplayName, IPV6.node.IPAddress, IPV6.node.NodeDescription, IPV6.node.Description, IPV6.node.Vendor, IPV6.node.Location, IPV6.node.Contact, IPV6.node.IOSImage, IPV6.node.IOSVersion, IPV6.node.CPUCount, IPV6.node.MemoryAvailable, IPV6.node.TotalMemory
FROM Orion.NodeIPAddresses IPV6
Left join Orion.NodeMacAddresses m on (IPV6.NodeID=m.NodeID)