DB Schema - system table
The system table contains the main pieces 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) and vaild values (for ENUM columns).
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.
| Name | Type | Default | Max Length | Primary Key | Valid Values |
Set By | true | auto | | | | audit | | 100 | | | audit | | audit | | | audit | | audit | | | | audit | | audit | | audit | | | | audit | | | | | audit | | | calculated | | | | manual | | calculated | | | | audit | | | audit | | | audit | | 50 | | | audit | | | | calculated | | audit | | audit | | | audit | | audit | | | | audit0 auditint0 | 10 | | | audit | 0 audit
| 10 |
|
|
| os_installation_date | date | 2000-01-01 |
| | | audit | | | | audit | | | audit |
|
|
| printer_shared_name | varchar |
| audit | | | | audit | | | auditenum | | ('production', 'deleted', 'lost', 'maintenance', 'retired', 'unallocated') | audit | environment | enum| class | enum | | | | ('desktop', 'laptop', 'tablet', 'workstation', 'server', 'virtual server', 'virtual desktop', 'hypervisor', '') | manual |
| | ('production', 'dev', 'dr', 'eval', 'pre-prod', 'test', 'train', 'uat') | audit | | | manual | | | | manual | | manual | | | manual | | | manual | manual | | | | manual | | | manual |
|
|
| location_rack_position | varchar |
| | manual | 0 | | manual | | | | | manual | | 0.000000 |
|
|
|
| location_longitude | float |
| | | | manual | | 0.000000 |
|
|
|
| asset_number | varchar |
| | | manual | | | calculated | | | calculated | | | manual | | | manual | | manual | | manual | | | | manual |
|
|
| purchase_order_number | varchar |
| | manual |
|
|
| purchase_cost_center | varchar |
| | | manual | | | manual |
|
|
| purchase_date | date | 2000-01-01 |
| | | manual |
|
|
|
| purchase_service_contract_number | varchar |
| | manual |
|
|
| lease_expiry_date | date | 2000-01-01 |
| | | manual | | | manual0 | | manual |
|
|
| warranty_expires | date | 2000-01-01 |
| | | manual | | |
|
|
| ('', '24x7x365', '9x5x5', 'Next Business Day') |
|
| warranty_status | varchar |
| 100 |
|
|
| maintenance_expires | date | 2000-01-01 |
|
|
|
| end_of_life | date | 2000-01-01 |
|
|
|
| end_of_service | date | 2000-01-01 |
|
|
|
| end_of_production | date | 2000-01-01 |
|
|
|
| switch_system_id | int |
| 10 |
|
|
| switch_port | int |
| 10 |
manual | | switch_system_id | int | | 10 | | | manual |
switch_port | int | 0 | 10 | | | manual | | manual | 0 | | | manual | | | manual | | | | manual | | | | manual | | manual | | | manual | | | manual | | | | manual | | manual | | | | manual | | | | manual | | | manual | | | manual | | | manual | export | manual |
| nmis_notes | text |
|
|
|
|
| nmis_business_service | varchar |
| 50 |
|
|
| nmis_poller | text |
|
|
|
|
| nmis_customer | varchar |
| 200 |
|
|
| oae_manage | enum | y |
| | manual | | | | audit | | | | | audit | | | | audit | auditsysContact | auditsysName| sysLocation | varchar | | 255 | | | audit |
| 255 | | | audit |
| 10 |
|
|
| snmp_enterprise_id | int |
| 10 |
|
|
| snmp_enterprise_name | varchar |
| 255 |
|
|
| first_seen | datetime | 2000-01-01 00:00:00 |
| | audit |
|
|
|
| last_seen | datetime | 2000-01-01 00:00:00 |
| | | audit | | | calculated | | last_user | varchar | | 150 | | | |
omk_uuid | varchar | | | | | imported |
|
|
| omk_uuid | text |
|
|
|
|
| collector_uuid | text |
|
|
|
|
| credentials | text |
|
|
|
|
| cloud_id | int |
| 10 |
|
|
| instance_provider | varchar |
| 200 |
|
|
| instance_ident | varchar |
| 200 |
|
|
| instance_type | varchar |
| 200 |
|
|
| instance_state | varchar |
| 200 |
|
|
| instance_reservation_ident | varchar |
| 200 |
|
|
| instance_tags | text |
|
|
|
|
| instance_options | text |
|
|
|
|
| discovery_id | int |
| 10 |
|
|
| identification | text |
|
|
|
|