You can also run wc command on your log files
|-----------------------------------------------------------------------------------------------------------------|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
SMS y GPRS online
Visitenos en www.perusms.com
On Mon, Jun 9, 2014 at 9:42 AM, spameden <spame...@gmail.com> wrote:
>
>
>
> 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
>>
>>
>
