Monitoring, Management & Location Tracking

Exporting a list of devices (with credentials) from an AirWave database to an AirWave importable CSV

Aruba Employee

Usage Case:

An AirWave administrator needs to move a large number of devices (i.e. controllers/switches/etc.) from one AirWave server to another (or the same server later) and doesn't want to re-add all the devices by hand.

We can dump the data directly to a CSV format quickly from the CLI and re-import into AirWave.

The following command will dump all the relevant information to a text file in proper CSV format for devices based on the Group ID (ap_group_id=XXX) in AirWave:

# (echo "IP Address,SNMP Community String,Name,Type,Auth Password,SNMPv3 Auth Protocol,Privacy Password,SNMPv3 Privacy Protocol,SNMPv3 Username,Telnet Username,Telnet Password,Enable Password,SNMP Port" && dbc "COPY (SELECT apparent_ip, snmp_secret, name, type, auth_password, auth_protocol, priv_password, priv_protocol, snmpv3_username, username, password, enable_password, snmp_port from ap where ap_group_id = XXX) TO stdout WITH CSV;") > /tmp/dump.csv


You may simply open the file with your favorite text editor and remove the first line and replace it (see example below)

Example:

The file contents need to look like this instead:

[root@garrison amp_diag]# cat /tmp/dump.csv
IP Address,SNMP Community String,Name,Type,Auth Password,SNMPv3 Auth Protocol,Privacy Password,SNMPv3 Privacy Protocol,SNMPv3 Username,Telnet Username,Telnet Password,Enable Password,SNMP Port
10.162.105.34,public,Support650-Local1,293,"",sha,"",des,"",admin,password,enable,161

Version history
Revision #:
1 of 1
Last update:
‎06-29-2014 09:33 AM
Updated by:
 
Labels (1)
Contributors
Search Airheads
cancel
Showing results for 
Search instead for 
Did you mean: