On October 19, 2021, we have enabled single-sign-on for our Plesk Support Center to provide a seamless login/account experience. This implies that you’ll be able to use a single account across any of our web-facing properties.
If you had already registered your account at Plesk 360 (formerly known as My Plesk) please use one for login. Otherwise please re-register it using the same email address as your existing Zendesk login (support account). It’s essential that you use the same email address on our support center to ensure that your tickets stay attached to the same account.

How to get a traffic usage report for a custom period in Plesk?

Follow

Comments

2 comments

  • Avatar
    Nan Dee

    Base on query #2, how can we specify to only display sites with 0 traffic from all cases (http_in, http_out, ftp_in, ftp_out, smtp_in, smtp_out, pop3_impa_in, pop3_imap_out) of a required period?

    0
    Comment actions Permalink
  • Avatar
    Nikita Nikushkin

    Hi @Nan Dee,

    Domains with all 0 stats for the specific period are not present in the "DomainsTraffic" table. If the domain receives any kind of traffic, then after Daily Task execution, the "DomainsTraffic" table is updated with the corresponding traffic type for the required date

    So, to get a list of domains which have no any kind of traffic for the required period, the next request can be used:

    # plesk db "select name from domains where id not in (select distinct dom_id from DomainsTraffic where date>='2017-03-01' AND date<='2019-03-20')"

    Do not forget to change the dates to the correct one

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request