1 Reply Latest reply on Oct 1, 2007 3:27 PM by sb r

    cmdb 2.0.0.1 - cmdbdriver - CMDBGraphQuery

    Johann Groenewald
      Share This:

      Hello Listers



      I hope someone on the forum can assist me in my quest to perform a basic graph query from within the cmdbdriver utility.

      My main problem I think is the fact that I'm strugling with populating the various parameters with the correct data.

      Any basic examples will be greatly appreciated.

      Kind regards,
      Johann Groenewald

        • 1. Re: cmdb 2.0.0.1 - cmdbdriver - CMDBGraphQuery


          The following is an example to query 5 levels of graph from a starting CI (assuming its id is 100001). You have to do "init" and "log" before typing command "grq". The result of the query is very hard to read unless there are only a few CIs and relations returned. I found a CMDB model visualization tool (called CMDB Analyzer) recently from www.bluelineG.com. All I have to do is to export CI model using cmdbdriver command "xexpdt" and "xexpdf", and then explore CI model using the tool. Hope this will help.

          Command: grq
          GRAPH QUERY
          Starting Node Instance
             Instance id (): 100001
          Starting Node Class Name
             Namespace (): BMC.CORE
             Class name (): BMC_BaseElement
             Dataset ID (): BMC.ASSET
          Get Mask
             none/current only (0-1) (0):
          Starting Node Extension Name ():
          Query Graph Info
             Number of nodes (including starting node) (1):
             Node info 1 of 1:
                Class Name
                   Namespace (): BMC.CORE
                   Class name (): BMC_BaseElement
                Extension Name ():
                Number of adjacent nodes (0): 1
                Adjacent node info 1 of 1:
                   Relationship Class Name
                      Namespace (): BMC.CORE
                      Class name (): BMC_BaseRelationship
                   Enter the type of qualification: (none\string\struct, 0-2) (0):
                   Type of attribute retrieval:
                      none/custom/nonhidden/all (0-3) (0):
                   Object Class Name
                      Namespace (): BMC.CORE
                      Class name (): BMC_BaseElement
                   Object Extension Name ():
                   Enter the type of qualification: (none\string\struct, 0-2) (0):
                   Type of attribute retrieval:
                      none/custom/nonhidden/all (0-3) (0):
          Number of levels (1): 5
          Direction
             out/in (0-1) (0):
          On no match proceed? (F):
          On match proceed? (T):