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

sorry for the late respons.
I think that the first time i installed i-doit, inodb was disabled.
I changed MYISAM to INODB in the mysqldump file, and do a i-doit db update.
everything was fine now

Mels

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

Mels

Still one little question:
Why is one mandator database MYISAM and the other INODB?

Mels

no bug, I had imported a old database file in the new database.

problem solved
thanks
Mels

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.

Mels

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

Hi all,

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?

Mels

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.

Hi,

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?

Thanks
Mels Kooijman.