Hello all again, thank you for all of your continued support!
I am now looking to create a report or widget that will report or display all nodes which are not included in any Orion Maps.
So far the only way I have been able to do this is through a very slow and inefficient report. I query every node ID and ask for its membership and then union an additional query. The result of this report is a list of all nodes that are in maps which I then compare to a different report of all my node IDs in the system to identify which node IDs are omitted and therefore not included in any map.
The report looks like below for nodes 2047 and 2048 - just imagine this but 2000 times longer and thats the report as it checks every possible node ID and unions the queries together:
SELECT TOP 100
p.DisplayName
,concat('SW-IP-redacted/.../', p.ProjectID) AS [_LinkFor_DisplayName]
,n.Caption
,n.IP_Address
,n.NodeID
FROM [dbo].[Maps_Projects] AS p
JOIN [dbo].[Nodes] AS n ON 2047 = n.NodeID
WHERE p.Data LIKE '%Nodes_2047/%'
UNION
SELECT TOP 100
p.DisplayName
,concat('http://SW-IP-redacted/ui/maps/viewer/', p.ProjectID) AS [_LinkFor_DisplayName]
,n.Caption
,n.IP_Address
,n.NodeID
FROM [dbo].[Maps_Projects] AS p
JOIN [dbo].[Nodes] AS n ON 2048 = n.NodeID
WHERE p.Data LIKE '%Nodes_2048/%'
I am really hoping that someone will have a better way to more directly report on node IDs that are not included in any Orion Map and display it in a report, or a widget, or preferably both.
Thank you in advance for all of your ideas!