DB Schema - component tables
Open-AudIT links device components of a device to the "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.
Every component table contains five standard columns. These are explained on the page for Matching and Storing Device Attributes.
Name | Type | Default | Max Length | Valid Values |
---|---|---|---|---|
id | int | 10 | ||
system_id | int | 10 | ||
current | enum | y | ('y', 'n') | |
last_seen | datetime | 2000-01-01 00:00:00 | ||
first_seen | datetime | 2000-01-01 00:00:00 |
Other attributes are also stored, depending on the component in question.
The following are the tables for the relevant attributes - attachment, bios, disk, dns, file, ip, log, memory, module, monitor, motherboard, netstat, network, nmap, optical, pagefile, partition, print_queue, processor, route, san, scsi, server, server_item, service, share, software, software_key, sound, task, user, user_group, variable, video, vm, windows.
The schema for these tables can be view in the application if you have the admin role. Go to menu -> Admin -> Database -> List Tables and then click the View button for any table.