SWQL query to pull node name, device IP, device mac, and switchport

Like the title says I would like to have a little table at the top of my node detail page in NPM that shows the node name, ip address, mac address, switch and switch port. Is such a thing possible? So far I've been able to get the node name and IP to show but when I try to add the PhysicalAddress to the query it fails. Here's what I have that works so far and what I tried that failed.

Working- SELECT Caption AS NodeName, IPAddress FROM Orion.Nodes WHERE NodeID = ${NodeID}

Not Working - SELECT Caption AS NodeName, IPAddress, PhysicalAddress FROM Orion.Nodes WHERE NodeID = ${NodeID}

Find more posts tagged with

Accepted answers

natetech

SELECT N.Caption AS NodeName, N.IPAddress, N.Interfaces.PhysicalAddress FROM Orion.Nodes N WHERE N.NodeID = ${NodeID}

All comments

devrajs

benny32 you can only use properties present in the swql schema for Orion.Nodes provided at below link.

SolarWinds Information Service v3.0 Schema Documentation

benny32

Ok, when I tried to add MACAddressInfo, which is in that list I still get an error processing. Am I formatting this wrong?

SELECT Caption AS NodeName, IPAddress, MACAddressInfo FROM Orion.Nodes WHERE NodeID = ${NodeID}

natetech

SELECT N.Caption AS NodeName, N.IPAddress, N.Interfaces.PhysicalAddress FROM Orion.Nodes N WHERE N.NodeID = ${NodeID}

benny32

Thanks, that worked great for the IP and MAC! Is there no way to pull the switchport from UDT as well?

devrajs

please use this query to get the output

SELECT N.NodeName, N.IPAddress, M.MAC from Orion.Nodes N left outer join Orion.NodeMACAddresses M ON N.NodeID=M.NodeID