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