...
The system table contains the main piece 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) 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 attribute is set manually by the Open-AudIT user.
Where a column has a set by of "imported" it means the attribute is set by NMIS.
Name | Type | Default | Max Length | Primary Key | Valid Values |
Set By | | | auto | | audit | 100 | | audit | | audit | audit | | audit | audit | audit | | audit | | audit | | | | audit | calculated | | manual | | | calculated | audit | | audit | audit | 50 | | audit | | calculated | 100 audit | audit | audit | | | audit | | audit | 03 auditauditint | 0 | 10 | | bigint |
| 20 |
|
|
processor_count | tinyint |
03 audit
| 10 |
|
|
os_installation_date | date | 2000-01-01 |
| | audit | | audit | audit |
|
|
printer_shared_name | varchar |
| audit | | audit | | auditenumaudit | ('production', 'deleted', 'lost', 'maintenance', 'retired', 'unallocated') | enumclass | enum | | | ('desktop', 'laptop', 'tablet', 'workstation', 'server', 'virtual server', 'virtual desktop', 'hypervisor', '') | manual |
| ('production', 'dev', 'dr', 'eval', 'pre-prod', 'test', 'train', 'uat') | audit | 100 |
|
|
class | varchar |
| 100 |
|
|
function | varchar |
| | manual | | manual | | manual | manual | | manual | manual | manual | | manual |
|
|
location_rack_position | varchar |
| manual0 | | manual | manual | | | 0.000000 |
|
|
|
location_longitude | float |
| | | manual | 0.000000 |
|
|
|
asset_number | varchar |
manualtext |
|
|
|
|
vm_server_name | varchar |
| calculated | calculated | manual | | | manual | 150 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 | | manual | 0 | manual |
|
|
warranty_expires | date | 2000-01-01 |
| | manual | |
|
|
| ('', '24x7x365', '9x5x5', 'Next Business Day') |
manualwarranty_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 |
| manual0 | 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 255 auditsysContact 255 auditsysName | 255 | | audit | sysLocation
| 10 |
|
|
snmp_enterprise_id | int |
| 10 |
|
|
snmp_enterprise_name | varchar |
| audit |
|
|
first_seen | datetime | 2000-01-01 00:00:00 |
| | auditlast_seen_by | varchar | | 150 | | calculated |
last_user | varchar | | 150 | | |
omk_uuid | varchar | | | | imported |
|
|
|
last_seen | datetime | 2000-01-01 00:00:00 |
| | audit | last_seen_by | varchar |
| 150 |
|
|
last_user | varchar |
| 150 |
|
|
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 |
|
|
|
|