Little report



  • Hello,

    I'm using i-doit for my own in the office for 1 year now, and very happy with it.
    But my manager knows it and want to use some data.
    I espected in the document isys_component_database.txt some info about the used tables, but the document is empty.
    So i wanna ask you if it is possyble to ell witch tables I must query for the next data:
    Server 'General' information and the maintenance agreement indormation?
    I found some peaces, but not all.
    Can you help?

    Thanks in advange,
    Mels Kooijman.



  • What exactly do you want to do? Generate a report with an SQL statement?



  • correct, I take data from the isys_catg_global_list table for the servers and tables isys_catg_maintenance_list and isys_cats_maintenance_list
    for the maintenance data. I have to combine this with the "General servers" and "maintenance agreement" information.
    But a sort on field isys_catg_global_list__isys_purpose__id gives me the servers but also for example the entry name "service contract"
    What is the right way or table for selecting only the servers in a sql query?
    If you can tell me, then I have the report.

    Mels



  • Connect your query with the object type (isys_obj_type__const = 'C__OBJTYPE__SERVER') with the connection isys_obj_type_2_isysgui_catg
    Try that or post your whole query so that I can see what is missing.



  • I'm on a short holliday now, I let you know the result when I'm back.

    Mels



  • sorry for the late response.

    With the object type (isys_obj_type__const = 'C__OBJTYPE__SERVER') with the connection isys_obj_type_2_isysgui_catg I get the information.

    every body happy 🙂

    Thanks for the help
    Mels


Log in to reply
 


Datenschutz / Privacy Policy