Could you elaborate on the exact type of information that you are attempting to extract from this database? What problem are you having? You can browse the tables to get a better idea of the type of information stored.
Thanks for coming back to me.
What I'm trying to achieve is to run a cron every minute on eximstats database and feed the info about deliveries to our email marketing system - to know when the message was actually delivered successfully.
Few questions I have:
1. What is the difference between SENDS and SMTP tables?
2. What do the statuses mean in SENDS and SMTP tables - for the processed column (I think the possible statuses are 0,1,2,3)
3. What is the countedtime, countedhour and counteddomain fields mean in the SMTP table
4. Which table will give me info about the messages that was delivered successfully.
Thanks for your help