| Table of Contents |
|---|
How do we process and store data?
Each system (computer, network device, printer, et al) has an entry in the "system" table. Each system (from the "system" table) has a "system_id" column. This value is unique - it's an auto incrementing id. A system is determined to be unique by a the table below.
...
| computer | network printer | local printer | network device | non-network device | |
| audit script | uuid + hostname | fqdn, ip address | hostname + deviceID | - | - |
| active directory | fqdn, ip address | fqdn, ip address | - | - | - |
| nmap | fqdn, ip address | fqdn, ip address | - | fqdn, ip address | - |
| snmp | fqdn, ip address, type + serial | fqdn, ip address, type + serial | - | fqdn, ip address, type + serial | - |
| spreadsheet | fqdn, ip address, type + serial | fqdn, ip address, type + serial | - | fqdn, ip address, type + serial | type + serial |
| html form | fqdn, ip address, type + serial | fqdn, ip address, type + serial | - | fqdn, ip address, type + serial | type + serial |
How do we match a system key?
The order of preference to match one system against another is as follows: Obviously if we have the system_id, we simply match on that first. If we don't have the system_id, in the model m_system.php is a function called find_system. This will attempt to:
...