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] >