DB Schema - system table

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.


NameTypeDefaultMax LengthPrimary KeyValid Values
idint
101
uuidvarchar
100

namevarchar
200

ipvarchar
45

hostnamevarchar
100

dns_hostnamevarchar
100

domainvarchar
100

dns_domainvarchar
100

dbus_identifiervarchar
255

fqdntext



dns_fqdntext



descriptiontext



typevarcharunknown50

commentstext



iconvarchar
50

os_groupvarchar
50

os_familyvarchar
50

os_namevarchar
100

os_versionvarchar
200

attached_system_idint
10

manufacturervarchar
100

manufacturer_codevarchar
200

modelvarchar
200

serialvarchar
200

uptimevarchar
50

form_factorvarchar
50

os_bittinyint
3

os_archvarchar
50

memory_countbigint
20

processor_counttinyint
3

storage_countint
10

os_installation_datedate2000-01-01


printer_port_namevarchar
50

printer_sharedvarchar
50

printer_shared_namevarchar
50

printer_colorenum


('y', 'n', '')
printer_duplexenum


('y', 'n', '')
statusvarcharproduction100

environmentvarcharproduction100

classvarchar
100

functionvarchar
100

ownervarchar
100

org_idint110

location_idint110

location_levelvarchar
100

location_suitevarchar
100

location_roomvarchar
100

location_rackvarchar
100

location_rack_positionvarchar
100

location_rack_sizeint
10

location_latitudefloat0.000000


location_longitudefloat0.000000


asset_numbervarchar
50

asset_tagtext



vm_server_namevarchar
150

vm_system_idint
10

vm_groupvarchar
150

cluster_namevarchar
150

cluster_typevarchar
150

cluster_idint
10

invoice_idint
10

purchase_invoicevarchar
50

purchase_order_numbervarchar
50

purchase_cost_centervarchar
50

purchase_vendorvarchar
100

purchase_datedate2000-01-01


purchase_service_contract_numbervarchar
255

lease_expiry_datedate2000-01-01


purchase_amountvarchar
50

warranty_durationint
5

warranty_expiresdate2000-01-01


warranty_typeenum


('', '24x7x365', '9x5x5', 'Next Business Day')
warranty_statusvarchar
100

maintenance_expiresdate2000-01-01


end_of_lifedate2000-01-01


end_of_servicedate2000-01-01


end_of_productiondate2000-01-01


switch_system_idint
10

switch_portint
10

patch_panelvarchar
45

patch_panel_portint
10

wall_portvarchar
100

contact_namevarchar
50

service_numbervarchar
100

service_providervarchar
100

service_typevarchar
100

service_planvarchar
100

service_networkvarchar
100

unlock_pinvarchar
100

serial_imeivarchar
100

serial_simvarchar
100

nmis_groupvarchar
50

nmis_namevarchar
50

nmis_rolevarchar
50

nmis_manageenumn

('y', 'n')
nmis_notestext



nmis_business_servicevarchar
50

nmis_pollertext



nmis_customervarchar
200

oae_manageenumy

('y', 'n')
snmp_oidtext



sysDescrtext



sysObjectIDvarchar
255

sysUpTimevarchar
255

sysContactvarchar
255

sysNamevarchar
255

sysLocationvarchar
255

snmp_versionvarchar
10

snmp_enterprise_idint
10

snmp_enterprise_namevarchar
255

first_seendatetime2000-01-01 00:00:00


last_seendatetime2000-01-01 00:00:00


last_seen_byvarchar
150

last_uservarchar
150

omk_uuidtext



collector_uuidtext



credentialstext



cloud_idint
10

instance_providervarchar
200

instance_identvarchar
200

instance_typevarchar
200

instance_statevarchar
200

instance_reservation_identvarchar
200

instance_tagstext



instance_optionstext



discovery_idint
10

identificationtext