Question Question Query for "perfect" overview?

[mexelmets46]

Hello guys!

I've been fiddling around with the webinterface and the "CSV Extension". Unluckily it is nearly impossible to merge multiple CSV sheets, which I extracted from the webinterface, into one big CSV which contains EVERY info about ServicePlan,Subscription,Domain.

I dont see any other way than that. I need to connect per SSH and use "plesk db".

Is anybody here willing to help me make this query? It is very important to me to deliver a good product and this is one step I'm currently struggeling with to achieve this.

For interested readers, I would like to get an output like this:

Domainname, Subscriber, ServicePlan, CreationDateOfDomain, UsedDiskSpace, BookedDiscSpace, UsedTraffic, BookedTraffic

I really tried my best to understand the database scheme but at one point I couldnt see any connections anymore.

Thank you for reading my question. And hopefully there is a way to achieve a solution for my problem!

 

[Kaspar]

You could gather all this data trough the Plesk XML-RCP API. Which (IMHO) would be a more stable methode than querying the PSA database directly. The database structure may change on Plesk updates.

Maybe your objective could be accomplished trough the Plesk CLI as well. But I am not 100% sure on that. Some data might not be available trough the CLI.