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
I did a update the i-doit update screen, this wa at home.
In the office i did the same update and inported the database at home. The export was done with mysqldump/
I check tomorro the db in the office for the missing field, this evening i install a clean version at home, so I can compare them.
I let you know.
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.
When I'm edit in maintenance the agreement information and want to save, I get a error:
Unknown column 'isys_cats_maintenance_list__customer_number' in 'field list'
Does this mean that the update to the last version and patch where wrong or is it a bug?
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,
I use i-doit for my own purpose in the office and i like it very mutch. Its better then all the spreadsheet they are using here.
But how can i fil in the patchpanel?
Unther infrastructure is nothig for that.
Any suggestions, how to defien a patchpanel rack in i-doit?