5 Replies Latest reply on May 10, 2019 7:18 AM by Edison Santos

    Discovery Query - Select Infrastructure details associated by Modeled Applications

    Edison Santos
      Share This:

      Hi Guys!

       

      Does anybody have a QUERY to extract all infrastructure of HOSTS e Databases associated with its respective Modeled Applications.

       

      When I run a SEARCH on "ModelDefinition" class, I would like that every detail should be listed in one by row, with its respective data aligned by columns.

       

      for example:

       

      • For HOSTS:

      COL  1, COL 2,     COL 3     ,           COL4           ,       COL5

      APPL A, HOST1, OS HOST1 , SPACE DISK Host1, CPU HOST1

      APPL A, HOST2, OS HOST2 , SPACE DISK Host2, CPU HOST2

      APPL B, HOST3, OS HOST3 , SPACE DISK Host3, CPU HOST3

       

      • For Databases:

      COL  1, COL 2,     COL 3   ,    COL4      ,    COL5

      APPL A, DB1    , Size DB1   , Name DB1 ,  Type DB1

      APPL A, DB2    , Size DB2   , Name DB2 ,  Type DB2

      APPL B, DB3    , Size DB3   , Name DB3 ,  Type DB3

       

      I've tried all possibilities that a know and I couldn't extract the data in this format.

       

      Could anybody help me?

       

      Regards,

      ES