'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. > > > Thanks > Ali >
