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 R&D 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: [email protected] 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 R&D > 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. ************************************************************************************
