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

    Find nodes not in groups?

    jason.b

      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?
          RichardLetts

          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

          e.g.

          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?
            jason.b

            Perfect! thank you