RE: audit sent and queued messages to DB
You could get all these informations from the sent_sms table in sqlbox. Hope that helps. -Original Message- From: Knaan Ratosh [mailto:[EMAIL PROTECTED] Sent: dimanche 11 novembre 2007 02:28 To: seik Cc: users@kannel.org Subject: RE: audit sent and queued messages to DB The problem is that I need to audit also success messages, and as I know the dlr stores a message in the DB and then deletes it when it's delivered successfully. Knaan Ratosh Acting VP RD AxisMobile Ltd. Consumer Mobile Email Tel: Int +972-3-7685529 Mobile: Int +972-54-3138460 [EMAIL PROTECTED] -Original Message- From: seik [mailto:[EMAIL PROTECTED] Sent: Friday, November 09, 2007 2:54 PM To: Knaan Ratosh Cc: users@kannel.org Subject: Re: audit sent and queued messages to DB well in case with queued you mean accepted by the SMSC and still not delivered to the recipient, you may just use DLR reporting data inserted into db each SMS should be sent with unique dlr smsid and proper value of the expiration timeout. from here you will deal with the sql queries i belive. -Original Message- From: Knaan Ratosh [EMAIL PROTECTED] Sent: 09 Ноември 2007 г. To: seik Subject:audit sent and queued messages to DB Hi, I need to store in an audit database information regarding messages that were sent successfully, and ones that are queued. I need this because I need to perform some reporting on the results - for example, report that counts the number of queued messages that were sent to a certain user within a range of dates. Does anyone have any idea how to do that? Knaan Ratosh Acting VP RD AxisMobile Ltd. Consumer Mobile Email Tel: Int +972-3-7685529 Mobile: Int +972-54-3138460 [EMAIL PROTECTED] This footnote confirms that this email message has been scanned by PineApp Mail-SeCure for the presence of malicious code, vandals computer viruses. _ Antivirus avast! http://www.avast.com : message Sortant sain. Base de donnees virale (VPS) : 07-1, 11/11/2007 Analyse le : 11/11/2007 23:59:42 avast! - copyright (c) 1988-2007 ALWIL Software.
RE: audit sent and queued messages to DB
The problem is that I need to audit also success messages, and as I know the dlr stores a message in the DB and then deletes it when it's delivered successfully. Knaan Ratosh Acting VP RD AxisMobile Ltd. Consumer Mobile Email Tel: Int +972-3-7685529 Mobile: Int +972-54-3138460 [EMAIL PROTECTED] -Original Message- From: seik [mailto:[EMAIL PROTECTED] Sent: Friday, November 09, 2007 2:54 PM To: Knaan Ratosh Cc: users@kannel.org Subject: Re: audit sent and queued messages to DB well in case with queued you mean accepted by the SMSC and still not delivered to the recipient, you may just use DLR reporting data inserted into db each SMS should be sent with unique dlr smsid and proper value of the expiration timeout. from here you will deal with the sql queries i belive. -Original Message- From: Knaan Ratosh [EMAIL PROTECTED] Sent: 09 Ноември 2007 г. To: seik Subject:audit sent and queued messages to DB Hi, I need to store in an audit database information regarding messages that were sent successfully, and ones that are queued. I need this because I need to perform some reporting on the results - for example, report that counts the number of queued messages that were sent to a certain user within a range of dates. Does anyone have any idea how to do that? Knaan Ratosh Acting VP RD AxisMobile Ltd. Consumer Mobile Email Tel: Int +972-3-7685529 Mobile: Int +972-54-3138460 [EMAIL PROTECTED] This footnote confirms that this email message has been scanned by PineApp Mail-SeCure for the presence of malicious code, vandals computer viruses.
Re: audit sent and queued messages to DB
well in case with queued you mean accepted by the SMSC and still not delivered to the recipient, you may just use DLR reporting data inserted into db each SMS should be sent with unique dlr smsid and proper value of the expiration timeout. from here you will deal with the sql queries i belive. -Original Message- From: Knaan Ratosh [EMAIL PROTECTED] Sent: 09 Ноември 2007 г. To: seik Subject:audit sent and queued messages to DB Hi, I need to store in an audit database information regarding messages that were sent successfully, and ones that are queued. I need this because I need to perform some reporting on the results – for example, report that counts the number of queued messages that were sent to a certain user within a range of dates. Does anyone have any idea how to do that? Knaan Ratosh Acting VP RD AxisMobile Ltd. Consumer Mobile Email Tel: Int +972-3-7685529 Mobile: Int +972-54-3138460 [EMAIL PROTECTED]