1
2
3
4
5
6
7
8
9
| #!/bin/sh
|
| sqlite3 /work/iot_cfg.db ".headers on " "select d.name as 设备名称,'1.3.6.1.4.1.27116.'||d.type||'.'||d.id||'.'||a.passcode as OID, d.id as 设备ID, d.type as 设备类型, a.passcode as 通道号, a.name as 数据名称,a.note as 备注 from device d left join accuracy a on d.id=a.id where uploadFlag=0" > /tmp/oid_list.csv
| sqlite3 /work/iot_cfg.db "SELECT name as 设备名称, '1.3.6.1.4.1.27116.'||type||'.'||id||'.3' as OID, id as 设备ID, type as 设备类型, 3 as 通道号 , '状态' as 数据名称, '0-正常;1-告警' as 备注 FROM ioDevice ;" >> /tmp/oid_list.csv
|
| sed -i 's/|/,/g' /tmp/oid_list.csv
|
|
| /usr/local/bin/snmp_cfg -f /work/snmp.json /tmp/oid_list.csv
|
|
