...
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.