Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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. 


NameTypeDefaultMax LengthPrimary KeyValid Values
Set By
idint
 

10
 auto
1
uuidvarchar
 

100
 audit


namevarchar
 100 audit

200

ipvarchar
 

45
 audit


hostnamevarchar
 

100
 
audit


dns_hostnamevarchar
 

100
 audit


domainvarchar
 

100
 audit


dns_domainvarchar
 

100
 audit


dbus_identifiervarchar
 

255
 


fqdn
audit
text



dns_fqdntext
   
audit




descriptiontext
   audit




typevarchar
 
unknown50
 calculated


commentstext
 
  manual




iconvarchar
 

50
 calculated


os_groupvarchar
 

50
 audit


os_familyvarchar
 

50
 audit


os_namevarchar
 

100
 audit


os_versionvarchar
 50 audit

200

attached_system_idint
 

10
 calculated


manufacturervarchar
 

100
100


manufacturer_code
 
varchar
audit

200

modelvarchar
 

200
 audit


serialvarchar
 

200
 
audit


uptimevarchar
 

50
 audit


form_factorvarchar
 

50
 audit


os_bittinyint
0

3
3


os_arch
 
varchar
audit

50

memory_count
int010 
bigint
20
audit


processor_counttinyint
0

3
3


storage_count
 
int
audit

10

os_installation_datedate2000-01-01
  audit



printer_port_namevarchar
 

50
 audit


printer_sharedvarchar
 

50
 audit


printer_shared_namevarchar
 

50
 audit


printer_colorenum
  



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



('y', 'n', '')
audit
status
enumaudit
varcharproduction
 ('production', 'deleted', 'lost', 'maintenance', 'retired', 'unallocated')
100

environment
enumclassenum  ('desktop', 'laptop', 'tablet', 'workstation', 'server', 'virtual server', 'virtual desktop', 'hypervisor', '')manual
varcharproduction
 ('production', 'dev', 'dr', 'eval', 'pre-prod', 'test', 'train', 'uat')audit
100

classvarchar
100

functionvarchar
 

100
 manual


ownervarchar
 

100
 manual


org_idint110
 manual


location_idint110
 manual


location_levelvarchar
 

100
 manual


location_suitevarchar
 

100
 manual


location_roomvarchar
 

100
 manual


location_rackvarchar
 

100
 manual


location_rack_positionvarchar
 

100
 manual


location_rack_sizeint
0

10
 manualmanual


location_latitudefloat
   
0.000000


location_longitudefloat
   manual
0.000000


asset_numbervarchar
 

50
 


asset_tag
manual
text



vm_server_namevarchar
 

150
 calculated


vm_system_idint
 

10
 calculated


vm_groupvarchar
 

150
 manual


cluster_namevarchar
 

150
 manual


cluster_typevarchar
 

150
150


cluster_id
 
int
manual

10

invoice_idint
 

10
 manual


purchase_invoicevarchar
 

50
 manual


purchase_order_numbervarchar
 

50
 
manual


purchase_cost_centervarchar
 

50
 
manual


purchase_vendorvarchar
 

100
 manual


purchase_datedate2000-01-01
  manual



purchase_service_contract_numbervarchar
 

255
 manual


lease_expiry_datedate2000-01-01
  manual



purchase_amountvarchar
 

50
 manual


warranty_durationint
0

5
 manual


warranty_expiresdate2000-01-01
  manual



warranty_typeenum
  



('', '24x7x365', '9x5x5', 'Next Business Day')
manual
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
 manual


switch_portint
0

10
 manual


patch_panelvarchar
 

45
 
manual


patch_panel_portint
0

10
 manual


wall_portvarchar
 

100
 manual


contact_namevarchar
 

50
 manual


service_numbervarchar
 

100
 manual


service_providervarchar
 

100
 manual


service_typevarchar
 

100
 manual


service_planvarchar
 

100
 manual


service_networkvarchar
 

100
 manual


unlock_pinvarchar
 

100
 manual


serial_imeivarchar
 

100
 manual


serial_simvarchar
 

100
 
manual


nmis_groupvarchar
 

50
 manual


nmis_namevarchar
 

50
 manual


nmis_rolevarchar
 

50
 manual


nmis_
export
manageenumn
 


('y', 'n')
manual
nmis_notestext



nmis_business_servicevarchar
50

nmis_pollertext



nmis_customervarchar
200

oae_manageenumy
 


('y', 'n')
manual
snmp_oidtext
   audit




sysDescrtext
 
  audit




sysObjectIDvarchar
 

255
 audit


sysUpTimevarchar
 

255
255


sysContact
 
varchar
audit

255
sysContact


sysNamevarchar
 

255
255


sysLocation
 
varchar
audit

255
sysName


snmp_versionvarchar
 255 auditsysLocation

10

snmp_enterprise_idint
10

snmp_enterprise_namevarchar
 

255
 
audit


first_seendatetime2000-01-01 00:00:00
  audit



last_seendatetime2000-01-01 00:00:00
  audit



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
last_seen_byvarchar 150 calculatedlast_uservarchar 150  omk_uuidvarchar   imported