Resolved List domains and plans on Windows

[AlexFlores]

Hey guys
Is there any way to get a list of domains with the plan associated?

I have seen some commands like
"%plesk_bin%\dbclient.exe" --direct-sql --sql="select status,name from domains;"

But i havent seen any way to get the plan associated to the website.

Any help?

 

[IgorG]

SQL query is a more complicated here. Try to use something like that:

SELECT dom.id as domain_id, dom.name as domain, ps.plan_id, t.name as plan_name from domains dom LEFT JOIN Subscriptions s ON (dom.id=s.object_id AND s.object_type='domain') LEFT JOIN PlansSubscriptions ps ON ps.subscription_id=s.id LEFT JOIN Templates t ON t.id=ps.plan_id;

 

[AlexFlores]

it worked great!! Thanks!!!