2 Replies Latest reply on Feb 7, 2012 12:45 AM by siganevich

    Child nodes

    siganevich

      Hi,

       

      Could someone please provide a SQL query that lists child nodes by parent id?

      I can't find the right table to do this on my own, has anybody done it?

        • Re: Child nodes
          mavturner

          What exactly are you trying to do? Knowing the tables probably won't allow you to accomplish what you are looking for.

          You can find the groups in the Containers table and the definition of the children in the ContainerMemberDefinition table.

          Mav

            • Re: Child nodes
              siganevich

              I am trying to achieve the following:

              When a whole geographical site goes down, I want to send and alert saying the site is down and the list of affected devices (its easy when its a whole site) but what can I do when its only a branch on a sites map?