[how-to] delete bunch of SMS

asked 2018-04-19 22:51:11 +0300

JirikL gravatar image

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

edit retag flag offensive close delete