DB Schema - system table
The system table contains the main piece of information for every device. If a device is in Open-AudIT, it has an entry in the system table.
The table below shows the columns contained in the table, along with the type, default value, maximum length (for VARCHAR columns), vaild values (for ENUM columns) and what it is initially set by when a device is created.
All columns can have their value manually set by a user except the ID column.
Some values should not be edited such as the UUID or DBUS_IDENTIFIER except under rare circumstances.
Editable columns will appear on the Bulk Edit Devices page inside Open-AudIT.
Where a column has a set by of "audit" it means the value from the discovery source (WMI, SSH, SNMP, Nmap) is used.
Where a column has a set by of "calculated" it means the other attributes from the discovery source (WMI, SSH, SNMP, Nmap) are used to determine this value.
Where a column has a set by of "manual" it means the other attribute is set manually by the Open-AudIT user.
Where a column has a set by of "imported" it means the other attribute is set by NMIS.
Name | Type | Default | Max Length | Valid Values | Set By |
|---|---|---|---|---|---|
| id | int | 10 | 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 |