This below query works great for getting IP, Caption/Name, and Comments. How would I add another column of the Device Model, example: 3750, or Nexus 9000. I can't figure out the SWQL syntax. Thanks!
Select IP_Address, Caption, Comments FROM Orion.NodesCustomProperties cp
INNER JOIN Orion.nodes nd on cp.NodeID = nd.NodeID
Where vendor = 'Cisco'