Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

eximstats table explaination

Discussion in 'E-mail Discussion' started by slawn, Oct 8, 2014.

  1. slawn

    slawn Member

    Joined:
    Dec 30, 2012
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Is there any documentation available that would explain 4 eximstats tables and their columns. I was searching but cannot find it anywhere. I'm trying to do some stats based on those - but have problems with some of the fields. Thanks
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,895
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    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.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. slawn

    slawn Member

    Joined:
    Dec 30, 2012
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,895
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    I believe you will likely want to use the "eximstats" utility directly. You can run the following command to get more information about each argument:

    Code:
    eximstats  -h
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice