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