From OpenDCIM Wiki
Devices
Initiating entry of new devices may be done in several ways:
- By pressing the Add Device button on the Cabinet form.
- By pressing the Add Device button in the Chassis Contents box of a chassis.
- By pressing the Move to Rack button on a Rack Request.
Database Information
Device data is stored in the fac_Device table.
Field Information
- DeviceID - An auto increment field within MySQL that guarantees a unique ID. It is referenced as a foreign key in the fac_DeviceTags, fac_PowerConnection, fac_SwitchConnection and fac_VMInventory tables.
- Label - The name assigned to the device.
- SerialNo - The serial number of the device.
- AssetTag - The asset tag of the device.
- PrimaryIP - The primary IP address for an ESX server. This address will be used to obtain virtual machine information from the ESX server.
- SNMPCommunity - The SNMP communityname to use when requesting information from the ESX server.
- ESX - A flag that indicates if the device is an ESX server.
- Owner - A foreign key reference to the departmental owner of the device, as defined in fac_Department.
- EscalationTimeID - A foreign key reference to the escalation time period, as defined in fac_EscalationTimes.
- EscalationID - A foreign key reference to the escalation details, as defined in fac_Escalations.
- PrimaryContact - A foreign key reference to the primary contact for the device, as defined in fac_Contact.
- Cabinet - A foreign key reference to the cabinet where the device is installed, as defined in fac-Cabinet.
- Position - The position in RU where the device is installed in the cabinet.
- Height - The height, in Rack Units (RU), which is roughly 1.75" per RU.
- Ports - The number of data ports provided by the device.
- TemplateID - A foreign key reference to a device template, as defined in fac_DeviceTemplate.
- NominalWatts - The nominal amount of power used by the device in watts.
- PowerSupplyCount - The number of power supplies in the device.
- DeviceType - The type of device. Certain device types will cause the application to behave differently. For instance, if a device is a switch, openDCIM will display a table to allow you to manage the connections. If the device is a chassis, it will allow you to enter child devices within the slots. The current device types are:
- Server
- Appliance
- Storage Array
- Switch
- Chassis
- Patch Panel
- Physical Infrastructure
- ChassisSlots - The number of front slots in a chassis.
- RearChassisSlots - The number of rear slots in a chassis.
- ParentDevice - For a device installed in a chassis, a key reference to the DeviceID of the chassis.
- MfgDate - The manufacture date for the device.
- InstallDate - The installation date for the device.
- WarrantyCo - The company providing the device warranty.
- WarrantyExpire - The date the warranty expires.
- Notes - Notes about the device.
- Reservation - A flag that indicates this is a space reservation.