Got a query use to work on Orion platform 2018.2, but getting error on 2019.4. Error reported on SDK v3 :
The query is set to work under below page setup to represent group nodes status for backup, Netflow and Syslogs.
Page setup:
Type of view: Group Details
VIEW LIMITATION :Single Group
--
select n.NodeID, N.Caption AS [Node Name], '/Orion/images/StatusIcons/small-' + ToString(N.StatusIcon) AS [_IconFor_Node Name], '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a'+ToString(N.NodeID) AS [_LinkFor_Node Name], t3.NCMNodeStatus as [Backup],
CASE WHEN t3.NCMNodeStatus = 'OK' THEN '/Orion/images/StatusIcons/Small-Up.gif'
ELSE '/Orion/images/StatusIcons/Small-Critical-Down.gif'
END AS [_Iconfor_Backup],
t4.SyslogStatus as [Syslog],
CASE WHEN t4.SyslogStatus = 'OK' THEN '/Orion/images/StatusIcons/Small-Up.gif'
WHEN t4.SyslogStatus is null THEN ''
ELSE '/Orion/images/StatusIcons/Small-Critical-Down.gif'
END AS [_Iconfor_Syslog],
t5.Netflow as [Netflow],
CASE WHEN t5.Netflow = 'OK' THEN '/Orion/images/StatusIcons/Small-Up.gif'
WHEN t5.Netflow is null THEN ''
ELSE '/Orion/images/StatusIcons/Small-Critical-Down.gif'
END AS [_Iconfor_Netflow]
from orion.nodes n
join Orion.ContainerMembers c on c.memberprimaryid=n.nodeid
left join ( Select CoreNodeId,
CASE
WHEN NCMNoDs.CoreNodeID IS NULL then 'NA'
WHEN NCMNoDs.CoreNodeID IS NOT NULL and np.LoginStatus not like '%Refused%' THEN 'OK'
ELSE 'Down'
END AS NCMNodeStatus
from NCM.Nodes as NCMNoDs
left join NCM.NodeProperties NP on np.CoreNodeId= NCMNoDs.CoreNodeId ) as t3 on n.NodeID=t3.CoreNodeId
left join ( Select sys.NodeID, max(sys.MessageID) as [max],
CASE
WHEN sys.NodeID IS NULL then 'NA'
WHEN sys.NodeID IS NOT NULL THEN 'OK'
ELSE 'Down'
END AS SyslogStatus
from Orion.syslog as sys
GROUP by sys.NodeID
) as t4 on n.NodeID=t4.NodeID
left join (
Select DISTINCT NFS.nodeid,
Case When NFS.LastTime is NULL then 'Issue' else 'OK' end as [Netflow]
FROM Orion.Netflow.Source AS NFS
where nfs.nodeid in
(select NF.nodeid
FROM Orion.Netflow.Source AS NF
GROUP by NF.nodeid)
) as t5 on n.NodeID=t5.NodeID
where MemberEntityType like 'orion.nodes'
and c.containerid like '${id}'
order by n.caption
