Count the total of MMS sent and received per day | Search |
NowSMS Support Forums ⬆ NowSMS Support - SMS Issues ⬆ Archive through August 22, 2012 ⬆ |
◄ ► |
Author | Message | |||
Ruth Stephanie Barthelemy New member Username: Nowparole Post Number: 1 Registered: 08-2012 |
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 |
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 |
Message Format MM4 (SMTP) | |||
Des - NowSMS Support Board Administrator Username: Desosms Post Number: 4065 Registered: 08-2008 |
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
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.
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 |
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:
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 |
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 |
Let me draw attention back to my previous recommendation:
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 |
Dear Support, i run the MMSREPORT.exe, i got this error message: , 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 |
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 |
yes, i do, i extract both to the same directory , | |||
Ruth Stephanie Barthelemy New member Username: Nowparole Post Number: 7 Registered: 08-2012 |
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 |
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 |
"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 |
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 |
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 |