Importing Devices
Devices of all types can be imported using an Excel spreadsheet. Different device types will need different attributes in the spreadsheet. Sample spreadsheets are provided in the open-audit/other/imports folder. Inside the spreadsheets, columns in red are mandatory. Every row must have an attribute from this column set. Columns that are blue must have at least one of these set per row. In the case of green, this substitutes for a blue column but must have both columns set for a given row.
Complete the spreadsheet and upload it to the web interface via Admin -> Devices -> Add Multiple Devices (using a spreadsheet).
Any items that have SNMP credentials provided via the spreadsheet will be automatically scanned.
Naturally the more columns you can complete, the better your datastore will be.
These items (once imported) can be queried and changed via the web interface. You can also export them via a Query.
Device Types per supplied spreadsheets are:
- import_phones.xls - 3g modem, cell phone, ip phone, mobile modem, phone, satellite phone, smart phone.
- import_access_tokens.xls - Access tokens like RSA hardware keys.
- import_computers.xls - Computers.
- import_networked_devices - Generic devices on your network, usually containing a hostname &/or ip address.
We are adding more device types all the time. If you have a specific device type you would like catered for, please let us know via the forums. Valid types of items in the Open-AudIT database are:
- access point
- access server
- access token
- adsl modem
- alarm
- bdsl modem
- building management
- cable modem
- cell phone
- cisco module
- computer
- chassis
- dsl modem
- firewall
- game console
- gateway
- ip phone
- kvm
- load balancer
- mobile modem
- nas
- network device
- network ids
- network printer
- network scanner
- phone
- point of sale
- printer
- projector
- remote access controller
- router
- san
- satellite phone
- scanner
- security camera
- smart phone
- switch
- tablet
- ups
- voip_adapter
- voip gateway
- voip phone
- vpn_terminator
- wan accelerator
- wap
- web cache
- webcam
- wireless router