Canned report 90/95/99th Percentile Traffic Rate - adding one SWQL select

Question

I wanted to filter down my selection of devices in this report based on a Custom Property.  Seeing it is SWQL, I looked at the help docs and took an example right out of it.  I get invalid query.  Is it placement, syntax or something else?

I am trying to add the following to the query below

NodesCustomProperties.CustomProperties.HEADENDCIRCUIT = 'True'

any ideas?

SELECT
 I.InterfaceID,
 N.NodeID,
 N.Caption AS NodeName,
 N.DetailsUrl AS NDetailsUrl,
 N.VendorIcon AS Vendor,
 I.Caption AS Interface_Caption,
 I.InterfaceIcon AS Interface_Icon,
 I.DetailsUrl AS IDetailsUrl,
 AverageInboundBps90th,
 AverageOutboundBps90th,
 AverageInboundBps95th,
 AverageOutboundBps95th,
 AverageInboundBps99th,
 AverageOutboundBps99th
FROM
(
 SELECT 
 InterfaceID,
 AverageInboundBps90th,
 AverageOutboundBps90th,
 AverageInboundBps95th,
 AverageOutboundBps95th,
 AverageInboundBps99th,
 AverageOutboundBps99th
 FROM Orion.NPM.InterfacePercentiles
 WHERE [DATETIME] BETWEEN AddMonth(-1,DateTrunc('month', GETUTCDATE())) AND DateTrunc('month', GETUTCDATE())
) AS IP
JOIN Orion.NPM.Interfaces I ON I.InterfaceID = IP.InterfaceID
JOIN Orion.Nodes N ON I.NodeID = N.NodeID

ecmel · Accepted Answer

I think your filter is in SQL format which is not valid for SWQL. You can refer to node custom properties using link from "Orion.Nodes" object.

So I would suggest adding this part at the end of your query:

AND N.CustomProperties.HEADENDCIRCUIT = 'True'