This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Report or Widget to Identify any nodes not included in any map

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!