How to Find Nodes Not in an Orion Group

8/13/2020 3:54 PM

8/16/2020 2:52 AM

It is not possible to show the nodes that are not already assigned to some existing Orion group within the web console. This walks the user through the process of reporting on this information. 

Orion Platform

The only way to print the nodes that are unassigned to groups is to query the database directly. You may use Orion reporting, Database Manager, or SQL Server Management Studio.

• Use Database Manager to view the SolarWinds database
• SQL Management Studio Direct Download Link

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

SELECT Caption FROM [NodesData]
WHERE Caption NOT IN (SELECT Name FROM [ContainerMemberSnapshots])