misc

oau edited this page Nov 4, 2012 · 1 revision
Clone this wiki locally

Here is a good query to find numbers that are getting a lot of errors:

select sum(status='SendingError'),sum(status!='SendingError'),DestinationNumber from sentitems
where sendingDateTime > datetime('now', '-1 months')
group by DestinationNumber
order by sum(status='SendingError');