• Halloween is coming! To celebrate the occasion, we dusted off a couple of old skins, and even created a brand new one (Pixel).
    To get into the festive spirit, install the Skins extension.
  • The new Python extension is now available. It allows customers to deploy and manage WSGI-based Python applications on their websites directly from Plesk.
  • The Plesk Mobile apps for iOS and Android and the Plesk Mobile Center extension have been deprecated, and are no longer available for new installations. In Plesk Obsidian 18.0.84, the Plesk Mobile Center extension will be removed from servers during the upgrade, and the Plesk Mobile apps will lose their server management features.
  • The Social Login extension has been deprecated and will be removed in Plesk Obsidian 18.0.84. After that, it will no longer be possible to log in to Plesk with a Google, Facebook, GitHub account, or with a passkey. Plesk usernames and passwords, as well as logging in with a WebPros Account, are not affected.

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

K
Forwarded to devs XML-RPC API disk space usage for subscription/webspace does not include subdomains
Replies
7
Views
6K
Sebahat.hadzhi
Sebahat.hadzhi
T
Input [Feature Request] Add php_handler_id to Plesk Rest API [GET] /domains
Replies
4
Views
5K
Sebahat.hadzhi
Sebahat.hadzhi
Azurel
Not used PHP versions removed, but Plesk reports missing versions
Replies
4
Views
4K
Azurel
Azurel
F
Input Critical security updates need technical details
Replies
17
Views
7K
danim
D
P
Resolved Smart Update fails during "Analyzing the test site before updating it" at 10%
Replies
2
Views
4K
Peter van der Kleij
P
Back
Top