[how-to] delete bunch of SMS
asked 2018-04-19 22:51:11 +0200
Hi, I have lot of SMS generated by remote systems. So I want delete bunch of them. But I don't know if is a good idea erase it directly over sql delete in sqlite3 utility. I discover a commhistory-tool that can only delete one or all messages. So I joined sqlite3 and commhistory-tool. I thought it would be slow, but it erased 300 SMS for a few seconds.
sqlite3 -list ~/.local/share/commhistory/commhistory.db 'select "commhistory-tool deletegroup "||groupId from events where type = 2 and freetext LIKE "nagios@example.com:Monitor is %";' >delete.sh
sh delete.sh