SWQL executing in SWQL studio but not in GUI report

SELECT N.Caption AS Node,
N.IPAddress AS Node_IP,
I.Name AS Node_Int,
NCE.DeviceId AS AP_Name,
NCE.IpAddress AS AP_IP,
NCE.DevicePort AS AP_Int
FROM Orion.NodeCdpEntry NCE
INNER JOIN Orion.Nodes N ON N.NodeID = NCE.NodeID
INNER JOIN Orion.NPM.Interfaces I ON I.NodeID = NCE.NodeID AND I.Index = NCE.IfIndex
WHERE AP_Name like '%AP%'

This SWQL is working in SWQL studio but not in GUI getting invalid in GUI. we are running 2023.2 SDK 3.1.0.343 anyone have the solution

Find more posts tagged with

query

SWQL

npm

Accepted answers

All comments

marcrobinson

Query worked in my swql studio and I tested it in a modern dashboard table widget (2023.2 Platform). It worked there too. Nice little report too - I might keep this one.

Double check the copy and paste in the webpage widget. I have seen this happen before. Also try simplifying it - it may be choking on one of the joins/related data. Then build it out/fix whatever the webgui is mad about. Good luck, and post any good or bad results.

Seashore

Tried this also in 2023.1.0 and 2023.2.0, works in both installations as a "Custom query widget".

I would though change the WHERE part to:

WHERE NCE.DeviceId like '%AP%'

Named columns could be an issue there.

monitoringlife

Same, worked for me (2023.x)

Also throwing it in my pile of queries