• The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

MySQL and/or RPC API retrieval of Plans, counts, site/subscribers

R

RationalPolymer

Basic Pleskian
I am trying to retrieve Panel information about Plans and their usage count and subscribers using MySQL and RPC API. Unfortunately, there is no single, or simple, query that can return that information and I have not been able to determine the PSA tables required nor the RPC API queries required. I can get some of the information but not all of it. Does anybody know what PSA tables and fields are required? Does anybody know what RPC API queries are required?

Basically what I want to get is:

Plan name
Count of Plan usage
List of subscribers, or sites, using said plan

I would like to use both methods: MySQL and RPC API.
 
You must log in or register to reply here.

Similar threads

intervations-au
Question API - Get a customers service plan
Replies
3
Views
1K
Kaspar@Plesk
Kaspar@Plesk
Giu
Resolved API change Cronjobs with CLI (cli/crontab_shell/call)
Replies
4
Views
1K
Kaspar
K
G
Question Is it possible to initiate WP Integrity Check (verify-checksums) via WP Toolkit API?
Replies
4
Views
5K
robinyutah
R
N
Issue Reconfigurator slow performance when adding DNS records
Replies
0
Views
932
nelteren
N
W
Issue Plesk is a desaster. php-fpm configuration for php8.1fpm is incompatible with the stack
Replies
15
Views
1K
whyisthissuchaBS
W
Back
Top