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

[hc_andy]

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.

Thanks.