From OpenDCIM Wiki
Jump to: navigation, search
(Created page with "== Devices == === Database Information === Device data is stored in the fac_Device table. === Field Information === * '''DeviceID''' - An auto increment field within MySQL tha...")
 
(Devices)
Line 1: Line 1:
 
== Devices ==
 
== 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 ===
 
=== Database Information ===

Revision as of 14:33, 1 January 2013

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.