Name | Type | Default | Max Length | Primary Key | Valid Values | Set By |
|---|---|---|---|---|---|---|
| id | int | 10 | true | auto | ||
| uuid | varchar | 100 | audit | |||
| name | varchar | 100 | audit | |||
| ip | varchar | 45 | audit | |||
| hostname | varchar | 100 | audit | |||
| dns_hostname | varchar | 100 | audit | |||
| domain | varchar | 100 | audit | |||
| dns_domain | varchar | 100 | audit | |||
| dbus_identifier | varchar | 255 | audit | |||
| fqdn | text | audit | ||||
| description | text | audit | ||||
| type | varchar | 50 | calculated | |||
| comments | text | manual | ||||
| icon | varchar | 50 | calculated | |||
| os_group | varchar | 50 | audit | |||
| os_family | varchar | 50 | audit | |||
| os_name | varchar | 100 | audit | |||
| os_version | varchar | 50 | audit | |||
| attached_system_id | int | 10 | calculated | |||
| manufacturer | varchar | 100 | audit | |||
| model | varchar | 200 | audit | |||
| serial | varchar | 200 | audit | |||
| uptime | varchar | 50 | audit | |||
| form_factor | varchar | 50 | audit | |||
| os_bit | tinyint | 0 | 3 | audit | ||
| memory_count | int | 0 | 10 | audit | ||
| processor_count | tinyint | 0 | 3 | audit | ||
| os_installation_date | date | 2000-01-01 | audit | |||
| printer_port_name | varchar | 50 | audit | |||
| printer_shared | varchar | 50 | audit | |||
| printer_shared_name | varchar | 50 | audit | |||
| printer_color | enum | ('y', 'n', '') | audit | |||
| printer_duplex | enum | ('y', 'n', '') | audit | |||
| status | enum | production | ('production', 'deleted', 'lost', 'maintenance', 'retired', 'unallocated') | audit | ||
| environment | enum | production | ('production', 'dev', 'dr', 'eval', 'pre-prod', 'test', 'train', 'uat') | audit | ||
| class | enum | ('desktop', 'laptop', 'tablet', 'workstation', 'server', 'virtual server', 'virtual desktop', 'hypervisor', '') | manual | |||
| function | varchar | 100 | manual | |||
| owner | varchar | 100 | manual | |||
| org_id | int | 1 | 10 | manual | ||
| location_id | int | 1 | 10 | manual | ||
| location_level | varchar | 100 | manual | |||
| location_suite | varchar | 100 | manual | |||
| location_room | varchar | 100 | manual | |||
| location_rack | varchar | 100 | manual | |||
| location_rack_position | varchar | 100 | manual | |||
| location_rack_size | int | 0 | 10 | manual | ||
| location_latitude | float | manual | ||||
| location_longitude | float | manual | ||||
| asset_number | varchar | 50 | manual | |||
| vm_server_name | varchar | 150 | calculated | |||
| vm_system_id | int | 10 | calculated | |||
| vm_group | varchar | 150 | manual | |||
| cluster_name | varchar | 150 | manual | |||
| cluster_type | varchar | 150 | manual | |||
| invoice_id | int | 10 | manual | |||
| purchase_invoice | varchar | 50 | manual | |||
| purchase_order_number | varchar | 50 | manual | |||
| purchase_cost_center | varchar | 50 | manual | |||
| purchase_vendor | varchar | 100 | manual | |||
| purchase_date | date | 2000-01-01 | manual | |||
| purchase_service_contract_number | varchar | 255 | manual | |||
| lease_expiry_date | date | 2000-01-01 | manual | |||
| purchase_amount | varchar | 50 | manual | |||
| warranty_duration | int | 0 | 5 | manual | ||
| warranty_expires | date | 2000-01-01 | manual | |||
| warranty_type | enum | ('', '24x7x365', '9x5x5', 'Next Business Day') | manual | |||
| switch_system_id | int | 10 | manual | |||
| switch_port | int | 0 | 10 | manual | ||
| patch_panel | varchar | 45 | manual | |||
| patch_panel_port | int | 0 | 10 | manual | ||
| wall_port | varchar | 100 | manual | |||
| contact_name | varchar | 50 | manual | |||
| service_number | varchar | 100 | manual | |||
| service_provider | varchar | 100 | manual | |||
| service_type | varchar | 100 | manual | |||
| service_plan | varchar | 100 | manual | |||
| service_network | varchar | 100 | manual | |||
| unlock_pin | varchar | 100 | manual | |||
| serial_imei | varchar | 100 | manual | |||
| serial_sim | varchar | 100 | manual | |||
| nmis_group | varchar | 50 | manual | |||
| nmis_name | varchar | 50 | manual | |||
| nmis_role | varchar | 50 | manual | |||
| nmis_export | enum | n | ('y', 'n') | manual | ||
| oae_manage | enum | y | ('y', 'n') | manual | ||
| snmp_oid | text | audit | ||||
| sysDescr | text | audit | ||||
| sysObjectID | varchar | 255 | audit | |||
| sysUpTime | varchar | 255 | audit | |||
| sysContact | varchar | 255 | audit | |||
| sysName | varchar | 255 | audit | |||
| sysLocation | varchar | 255 | audit | |||
| first_seen | datetime | 2000-01-01 00:00:00 | audit | |||
| last_seen | datetime | 2000-01-01 00:00:00 | audit | |||
| last_seen_by | varchar | 150 | calculated | |||
| last_user | varchar | 150 | ||||
| omk_uuid | varchar | imported |