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 |