2014-06-09 17:46 GMT+04:00 ha...@aeon.pk <ha...@aeon.pk>: > 'Grep' the date, message status (Sent) and then SMSC id in the access.log > file from Linux command prompt. > > Alternatively, you can run MySQL query over sentsms table if you are using > sqlbox (which is the best way). > > > On Sun, Jun 1, 2014 at 1:22 PM, Ali Kashif <syedalikas...@gmail.com> > wrote: > >> Dear Users, >> >> I have multiple SMSCs connected, and Kannel is doing some prefix based >> routing of messages, >> >> At end of month i need to count how many messages has been sent from each >> SMSc, >> >> I can see the access.log for kannel and there is >> >> 2014-06-01 08:04:59 Sent SMS [SMSC:nahsms] >> >> i was thinking if i can add a mysql query in place where the above log is >> being writen, >> which just update number in mysql table against SMSC, >> >> >> Can anyone me tell me which file i should look and modify. >> >> >> and Will that be a good idea, considering that i am sending 100,000 SMS >> per day. >> > Check sqlbox it might suit all your needs if you tweak it a bit.
> >> >> Thanks >> Ali >> > >