Count the total of MMS sent and received per day

Count the total of MMS sent and received per day SearchSearch

SMS & MMS Technical Forum » NowSMS Support - SMS Issues (Product Support Only) » Archive through August 22, 2012 » Count the total of MMS sent and received per day « Previous || Next »
Author Message
Ruth Stephanie Barthelemy
New member
Username: Nowparole

Post Number: 1
Registered: 08-2012
Posted on Thursday, August 09, 2012 - 07:25 pm:   

Dear support,

Please let me know in the MMSLOGS.txt file , how I can count the number of successful MMS Sent and received per day.The main issue i have in the logs is there are many lines for MMSIN for a same number, i can't know which line to consider as a successful one , also , i need to know what does MMSOUT mean,if you could help me identify the successful transaction for both (MMS Sent and MMS Received) it will be good.
Finally, i really need to know also if there 's a way to create a Crontab job on the server in order to retreive those information daily (Successful MMS Sent and Successful MMS Received).

Thanks in advance for your help.

Regards
Ruth Stephanie Barthelemy
New member
Username: Nowparole

Post Number: 2
Registered: 08-2012
Posted on Friday, August 10, 2012 - 12:42 pm:   

Dear Support,
PLease give me a feedback on the above cause it is a high priority .

Thanks,
Ruth Stephanie Barthelemy
New member
Username: Nowparole

Post Number: 3
Registered: 08-2012
Posted on Friday, August 10, 2012 - 01:46 pm:   

Message Format MM4 (SMTP)
Des - NowSMS Support
Board Administrator
Username: Desosms

Post Number: 4065
Registered: 08-2008
Posted on Friday, August 10, 2012 - 06:05 pm:   

Hi,

Are you looking for MM4 stats, or a general overall sent/received report?

Unfortunately, I am not aware of any utilities that would provide that information. I've discussed this with one of my colleagues, and we may try to write something simple ... I just can't commit to a timeframe.

The following post has good info on the MMSC log file format: http://support.nowsms.com/discus/messages/1/24228.html


quote:

The main issue i have in the logs is there are many lines for MMSIN for a same number, i can't know which line to consider as a successful one




That has always bothered me as well. In my opinion it was a bad early design choice on our part. The problem with changing it is that we exercise extreme caution in format changes to any of this information, because it can have unexpected impact on existing customers who might already be processing this information.

My advice, when processing an MMSIN record, ignore the record if the message queue ID contains "-2.req". This will skip the 2nd SMS part of an MMS notification.

Also regarding MMSIN processing, refer back to the log format article I referenced above. The 2nd parameter after MMSIN will tell you whether the message originated locally or remote.


quote:

also , i need to know what does MMSOUT mean




It means the MMS was dispatched to an external MMSC connection.

MMSRETRIEVE indicates a local MMS retrieval. (There is an issue that communication problems may cause duplicate MMSRETRIEVE entries for a single message.)

--
Des
NowSMS Support
Des - NowSMS Support
Board Administrator
Username: Desosms

Post Number: 4066
Registered: 08-2008
Posted on Friday, August 10, 2012 - 08:44 pm:   

Follow-up ...

I ended up spending a little time on this today. But unfortunately nothing that is ready to be sent out yet.

I'm curious what information you'd like to extract. My work in progress processes MMSIN, MMSOUT and MMSRETRIEVE records in one or more logs to report:


quote:

Local MMSC Activity:
MMS Sent - ######
MMS Retrieved - ######

External MMSC Inbound Messages:
Name1 - #####
Name2 - #####
etc

External MMSC Outbound Messages:
Name1 - #####
Name2 - #####
etc




My thought is to read data from the log files and insert the information into an SQLite database for further analysis beyond those summary stats.

I'll follow up with more information next week.

--
Des
NowSMS Support
Ruth Stephanie Barthelemy
New member
Username: Nowparole

Post Number: 4
Registered: 08-2012
Posted on Monday, August 13, 2012 - 02:18 pm:   

i am looking for MM4 stats, right, my concern is each time i found that the line for MMSin +Public IP is duplicated, i should divide by 2 to find the corect value but the issue is sometimes the number of all MMSIN + Public IPis not always even , how is it possible ? in fact, i need to deliver a weekly report to give all MMS Sent and received successfuly per day , how is it possible to retreive those information in the log file ?

Thanks for your assistance,
Des - NowSMS Support
Board Administrator
Username: Desosms

Post Number: 4067
Registered: 08-2008
Posted on Monday, August 13, 2012 - 03:30 pm:   

Let me draw attention back to my previous recommendation:


quote:

My advice, when processing an MMSIN record, ignore the record if the message queue ID contains "-2.req". This will skip the 2nd SMS part of an MMS notification.




There may be MMS notifications that fit into a single MMS, so you can't count on the number of entries being double.

In the meantime, I've uploaded a simple utility that reads MMSC log files and produces a summary report similar to what I outlined above.

This can be downloaded at http://www.nowsms.com/download/mmsreport.zip

------
MMSREPORT.EXE is a command line utility that can be used to parse statistics from NowSMS MMSC log files.

Usage:

MMSREPORT MMSC-yyyymmdd.LOG [MMSC-yyyymmdd.LOG] [MMSC-yyyymm*.LOG]


Where MMSC-yyyymmdd.LOG is the name of a NowSMS MMSC log file to be analysed (example: MMSC-20120815.LOG). Multiple log file names can be specified in the command line to allow multiple log files to be analysed in combination. Also, wildcards are permitted for specifying log files. Full path names may be required (use quote characters if the full path name contains spaces - example: MMSREPORT "c:\program files\nowsms\mmsc-20120815.log").

MMSREPORT.EXE will produce a summary count of MMS processing for the specified log files, in a format similar to the following:

Local MMSC Activity:
MMS Sent - ######
MMS Retrieved - ######

External MMSC Inbound Messages:
Name1 - #####
Name2 - #####
etc

External MMSC Outbound Messages:
Name1 - #####
Name2 - #####
etc
------


--
Des
NowSMS Support
Ruth Stephanie Barthelemy
New member
Username: Nowparole

Post Number: 5
Registered: 08-2012
Posted on Monday, August 13, 2012 - 04:39 pm:   

Dear Support,

i run the MMSREPORT.exe, i got this error message:

ErrorMessage, is there anything i should do before run the application, i already had all my mmslog files for the past days.

Thanks,
Des - NowSMS Support
Board Administrator
Username: Desosms

Post Number: 4068
Registered: 08-2008
Posted on Monday, August 13, 2012 - 04:42 pm:   

SQLITE3.dll is included in the ZIP file. Did you extract it and MMSREPORT.exe to the same directory?
Ruth Stephanie Barthelemy
New member
Username: Nowparole

Post Number: 6
Registered: 08-2012
Posted on Monday, August 13, 2012 - 06:05 pm:   

yes, i do, i extract both to the same directory ,
Ruth Stephanie Barthelemy
New member
Username: Nowparole

Post Number: 7
Registered: 08-2012
Posted on Monday, August 13, 2012 - 06:11 pm:   

for now , i am able to run mmsreport.exe but the command prompt window appears briefly and in less that one second it disappears. Even if proceed again, the same result.
Ruth Stephanie Barthelemy
New member
Username: Nowparole

Post Number: 8
Registered: 08-2012
Posted on Monday, August 13, 2012 - 06:36 pm:   

Dear Support,

I found the issue, i am able to use it normally and i found the answer as described above. Good News, just one more thing, what do you mean by External MMSC Inbound Messages: ? is it mms received on my network from International, just to be clear.

Thank you so much for your great support.
Des - NowSMS Support
Board Administrator
Username: Desosms

Post Number: 4069
Registered: 08-2008
Posted on Monday, August 13, 2012 - 08:42 pm:   

"External MMSC Inbound Messages" refers to messages received from an External MMSC connection, which includes any connections listed on the "MMSC VASP" page. Each listed name refers to an "MMSC VASP" account.

"External MMSC Outbound Messages" refers to messages sent out to an External MMSC connection, which includes any connections listed on the "MMSC Routing" page. Each listed name refers to an "MMSC Routing" account.


--
Des
NowSMS Support
Ruth Stephanie Barthelemy
New member
Username: Nowparole

Post Number: 9
Registered: 08-2012
Posted on Tuesday, August 14, 2012 - 12:46 pm:   

Dear Support,

Thanks again for your quick assistance, one last thing, the list received from MMSREPORT.exe includes only successful MMS sent or received or all of them failed and successful, please do let me know asap.

Thanks,
Des - NowSMS Support
Board Administrator
Username: Desosms

Post Number: 4075
Registered: 08-2008
Posted on Tuesday, August 21, 2012 - 11:18 pm:   

Sorry for the delay in response.

Anything listed by MMSREPORT should be successfully processed.

We did find some issues with MMS that were converted to SMS where MMSREPORT was not counting correctly.

The previous URL (http://www.nowsms.com/download/mmsreport.zip) has been updated with a newer version.

--
Des
NowSMS Support

Login Login / Register Logout Logout Search Last 30 Days Topics Topics