Cheers guys on a fantastic application, I've been looking at it for a couple of weeks now and I'm very impressed with it's functionality.
My question is regarding rack management. The organisation I work for are looking for a CMDB very much like I-doit, but they also need a more visual representation of racks, specifically server location. At the moment it's possible to populate an enclosure with servers/KVM/Power/etc, so you can see what is in the rack, but not where in the rack. For example if I create a 42u enclosure and populate it with a bunch of servers, I would like to know where in the rack they are and what free space is available. Can you tell me if there are any plans to add this kind of functionality in the future?
If not then could you point me at the particular set of tables within the DB that would potentially need modifying to include rack location data? I've generated a DB diagram within MySQLWorkbench, but with 346 tables within the _data DB it's VERY difficult to reverse engineer.
for the rack itself we have the table 'isys_cats_enclosure_list'. That is connected to the table 'isys_cats_distributor' which has also a connection to 'isys_obj__id'.
So a server would have an object ID and is connected to the rack with the tables I just listed. Values according to the rack have to be stored in the first table I mentioned.
I think to store information about the location of an object within the rack we could use another table which is connected to the rack which includes every height unit. Think about a server inside the rack. That would be connected to HU 1 and 2. HU 3 could be 'NULL', and so on.
Do you need something else?
Thanks for your prompt reply
Your idea of a new table linked to the 'isys_cats_enclosure_list' looks like a good solution. It could be called something like 'isys_cats_enclosure_pos' and would require the following fields:
Btw there is 1 other table linked to 'isys_cats_enclosure_list' called 'isys_pos_gps', could you tell me what is the purpose of this table?
'isys_pos_gps' is for future references to a GPS position (GPS like in Global Positioning System). We don't really use it for now.