yanivk1984
7/16/2019 - 9:47 AM

sqlite3

# open as csv
sqlite3 -csv CPViewDB.dat "select * from UM_STAT_UM_CPU_UM_CPU_TABLE"
sqlite3 -csv /var/log/CPView_history/CPViewDB.dat "select datetime(Timestamp, 'unixepoch', 'localtime') as ts, if_name, if_rx_bits_throughput from UM_STAT_UM_HW_UM_IF_RX_STATISTICS_TABLE where if_name='eth1'";