Including Node Custom Property in Interface report with SWQL

routermonkey

I have a quick report I wrote for someone, but they'd like some information added that is a node custom property.  How would I include that in this query?

SELECT
i.FullName
,i.Status
,i.DetailsUrl
,i.MAC
,i.IPAddress.IPAddress
FROM Orion.NPM.Interfaces AS i
WHERE FullName like '%rts%' AND FullName like '%INET CKT%' AND i.IPAddress.IPAddress IS NOT NULL

bobmarley

Here is my go to query for pulling up some of the tables that are already joined in SWQL.    Uncomment the custom props field and fill it in with the name that matches yours. 

SELECT 
--       [Nodes].NodeID
--     , [Nodes].Caption
--     , [Nodes].DNS    
--     , [Nodes].IPAddress
--     , [Nodes].Vendor
--     , [Nodes].VendorIcon
--     , [Nodes].VendorInfo.Icon
--     , [Nodes].NodeDescription
--     , [Nodes].MachineType
--     , [Nodes].ObjectSubType
       [Nodes].Interfaces.Fullname
       , [Nodes].Interfaces.Status
       , [Nodes].Interfaces.MAC
       , [Nodes].Interfaces.IPAddress.IPAddress
--     , [Nodes].EngineID
--     , [Nodes].CustomProperties._PUTYOURSHERE
--     , [Nodes].CustomProperties._PUTYOURSHERE

--     , [Nodes].WorldMapPoint.Latitude AS [Latitude]
--     , [Nodes].WorldMapPoint.Longitude AS [Longitude]

FROM Orion.Nodes AS [Nodes]

--WHERE FullName like '%rts%' AND FullName like '%INET CKT%' AND i.IPAddress.IPAddress IS NOT NULL