1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

How to calculate the number of domains using a certain template?

Discussion in 'Plesk for Linux - 8.x and Older' started by hc_andy, Oct 22, 2007.

  1. hc_andy

    hc_andy Guest

    For example on plesk expand we have created the following templates:

    ID Template Name
    6 Domain Hosting Only
    5 Premium Extreme 1GB
    4 Premium Advance 500MB
    3 Education VWS
    2 Premium 250MB
    1 Lite 50 MB

    I'd like to get some stats that tells me X number of domains is using the Lite plan, etc...Plesk Expand doesn't seem to generate these stats so I've been trying to get the stats the backend way by querying the psa database on the plesk server, but no luck so far?? I've had a look at the tables in the psa database, but can't seem to find one that talks about the Template ID/Name listed above.

    Any help would be greatly appreciated.