5 Replies Latest reply on May 27, 2014 1:34 PM by dmshimself

    Query for CI Structures

    Rookie

      Hiya,

       

      I would like to be able to effectively manage the CI Items that I have on CI Structures. To do this I would like a query that shows the Config Items that are not on a structure. Is this possible, if so how?

       

      Thanks,

      Danielle

        • 1. Re: Query for CI Structures
          Specialist

          Depends on your structure i guess..

           

          We have scopes that we use to define our LDAP structure

          We have teams that gives rights on it.

           

          This will make an group in the ldms console for Devices, Queries, packages, task etc

          • 2. Re: Query for CI Structures
            Rookie

            Hi Casper.bons

             

            Thanks for your response, it has confused me slightly so thought that I would explain further what I am looking to achive.

             

            For example I have lots of CI Structure views with Application and Server CI present on them and related to each other. I want to make sure that all of the Server CIs in the database are present on at least 1 structure view. I was hoping that there would be a query that would be able to help me manage this, in service desk.

             

            Thanks,

            Danielle

            • 3. Re: Query for CI Structures
              Specialist

              Ah ok your talking about LANDesk servicedesk. I was talking about managementsuite/softwaredistribution.

               

              I don't use LANDesk servicedesk so can't really give you a how to.

               

              Ci's configuration management i have experienced is in namingconvention as it is the easiest to query on and available on all management systems.

               

              W70000 naming range W7

              W80000 naming range W8

               

              S10000 range for Server 08

              S20000 range for Server 2012

                   or

              S-SQL-2012-0001

               

              Hope it helps, don't know i am searching in the right direction

              • 4. Re: Query for CI Structures
                Rookie

                Hi Casper,

                 

                Thank you for responding, I have now moved the discussion to a more sensible group, hopefully this will help.

                 

                Thanks again,

                Danielle

                • 5. Re: Query for CI Structures
                  ITSMMVPGroup

                  I think you might need to use crystal to do this sort of query

                  1 of 1 people found this helpful