Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    Reporting question : isys_obj table

    Scheduled Pinned Locked Moved Operating
    2 Posts 2 Posters 1.9k Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • P Offline
      pdcict
      last edited by

      Hi all,

      I'm trying to get a query that results all assigned objects to a specific person.
      The isys_obj table has al the objects and column isys_obj__isys_obj_type__id has value 60 (this is object type LC__CMDB__OBJTYPE__RELATION).

      The description of objects of type 60 are in this format " <object>uses <person>", which tables (and which columns) do I have to join to get the corresponding person and object record?

      Thanks.
      Henk Tompot</person></object>

      1 Reply Last reply Reply Quote 0
      • LFischerL Offline
        LFischer
        last edited by

        Hello Henk,

        you'll need to query "isys_catg_relation_list" (this is the "relation" category) and inside that table you'll need to select the rows where the field "isys_catg_relation_list__isys_relation_type__id" reference to the isys_relation_type rows with the types "C__RELATION_TYPE__USER" or "C__RELATION_TYPE__ADMIN".

        It should look something like this:

        SELECT *
        
        FROM isys_obj AS obj_main 
        LEFT JOIN isys_catg_relation_list AS j4 ON j4.isys_catg_relation_list__isys_obj__id = obj_main.isys_obj__id 
        LEFT JOIN isys_relation_type AS jn3 ON jn3.isys_relation_type__id = j4.isys_catg_relation_list__isys_relation_type__id 
        
        WHERE jn3.isys_relation_type__const = 'C__RELATION_TYPE__ADMIN' 
        OR jn3.isys_relation_type__const = 'C__RELATION_TYPE__USER';
        

        Greetings,
        Leo

        1 Reply Last reply Reply Quote 0
        • First post
          Last post