SWQL to SQL

edondurguti

Hi, was hoping someone could help with SWQL to SQL syntax/table, I generate a report with nodeid, ipaddress, serial number etc, below is the swql query and it works great:

SELECT OrionNodes.Caption, OrionNodes.IP_Address, NcmEntityPhysical.EntityDescription, NcmEntityPhysical.Serial, NcmEntityPhysical.Model, OrionNodes.SysName

FROM NCM.NodeProperties AS NcmNodeProperties

INNER JOIN Orion.Nodes AS OrionNodes ON NcmNodeProperties.CoreNodeID=OrionNodes.NodeID

LEFT JOIN NCM.EntityPhysical AS NcmEntityPhysical ON NcmEntityPhysical.NodeID=NcmNodeProperties.NodeID AND NcmEntityPhysical.EntityClass=3

WHERE OrionNodes.Vendor='Cisco'

I am looking for SQL query for some external tools, anyone can point me to the right direction here?

Thank you.

j_a_catlin

This should work for you:

select N.caption, N.ip_address, NEP.Description, NEP.Serial, NEP.Model, N.sysname from NCM_NodeProperties NP

inner join nodes N on NP.CoreNodeID=n.NodeID

left join NCM_Entity_Physical NEP on NEP.NODEID=NP.nodeid

where n.vendor='Cisco'