The only module we have is NPM, running 2020.2 HF 1
This code:
SELECT
n.caption as Node
, n.DetailsUrl AS [_LinkFor_Node]
, '/Orion/images/StatusIcons/Small-' + n.StatusLED AS [_IconFor_Node]
, n.customproperties.system
, n.Contact
, n.location
FROM Orion.Nodes n
left join Orion.ContainerMembers c on c.MemberPrimaryID = n.NodeID
where c.MemberPrimaryID is NULL
... should return the Node Caption of any Node that is NOT a member of ANY groups. However I keep getting the error:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Orion.Nodes'.
...does anyone have an idea why? (This was done with the SWSQL tool, not with MSSQL Query)