Child pages
  • How to import devices using a spreadsheet
Skip to end of metadata
Go to start of metadata

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. All devices have a corresponding icon. If you have a specific device type you would like catered for, please let us know via the forums. Below are the valid device types in the form of database attribute value = human readable value. You should use the database attribute value in your spreadsheet. Valid types of items in the Open-AudIT database are:

access point = Access Point
access server = Access Server
access token = Access Token
adsl modem = ADSL Modem
alarm = Alarm
bdsl modem = BDSL Modem
bridge = Bridge
broadband router = Broadband Router
building management = Building Management
cable modem = Cable Modem
cell phone = Cell Phone
cisco module = Cisco Module
computer = Computer
chassis = Chassis
dsl modem = DSL Modem
dslam = DSLAM
environment monitor = Environment Monitor
firewall = Firewall
game console = Game Console
gateway = Gateway
general purpose = General Purpose
hub = Hub
ip phone = IP Phone
kvm = KVM (Keyboard, Video, Mouse switch)


load balancer = Load Balancer
media device = Media Device
mobile modem = Mobile Modem
nas = NAS (Network Attached Storage)
network device = Network Device
network ids = Network IDS (Intrusion Detection)
network printer = Network Printer
network scanner = Network Scanner
pbx = PBX
pda = PDA
pdu = Power Distribution Unit
phone = Phone
point of sale = Point of Sale
power device = Power Device
printer = Printer
print server = Print Server
projector = Projector
proxy = Proxy
proxy server = Proxy Server
remote access controller = Remote Access Controller (ILO / RSA)
remote management = Remote Management
router = Router
san = SAN (Storage Area Network)
satellite phone = Satellite Phone
satellite receiver = Satellite Receiver

scanner = Scanner
security camera = Security Camera
security misc = Security Misc
serial to ethernet = Serial to Ethernet Adapter
smart phone = Smart Phone
specialized = Specialized
storage misc = Storage Misc
switch = Switch
tablet = Tablet
tape library = Tape Library
telecom misc = Telecom Misc
terminal = Terminal
terminal server = Terminal Server
ups = UPS (Uninterruptible Power Supply)
video conference = Video Conference
voip adapter = VoIP Adapter
voip gateway = VoIP Gateway
voip phone = VoIP Phone
vpn terminator = VPN Terminator
wan accelerator = WAN Accelerator
wap = WAP (Wireless Access Point)
wdm = WDM (Wavelength Division Multiplexer)
web cache = Web Cache
webcam = Web Camera
wireless router = Wireless Router


  • No labels