2 Replies Latest reply on Jan 18, 2016 1:22 PM by jason.b

    Find nodes not in groups?


      Is there a way to find nodes that have not been assigned to Groups? and does Grouping allow Sub Groups? like having a group named [Location]->[Floor 1]-Then list nodes.

        • Re: Find nodes not in groups?

          a) only if you want to write some SQL.

          select *
          from Nodes
          where nodeid not in
               (select entityID 
                    from ContainermemberSnapshots 
                    where EntityType='Orion.Nodes')

          [in the Database Manager]


          you could also use this in a custom report if you want to keep track of this frequently


          b) yes, groups can be in groups.

          I have sector -> Building -> Nodes


          UW -> UW ADS -> switches...


          [from the parent group add the child groups to it]

          1 of 1 people found this helpful
          • Re: Find nodes not in groups?

            Perfect! thank you