I recently had to create over 40 email accounts for a client. Obviously i did not want to add them one by one.
Here is a little bash script I found that made the entire process a 30sec event.
If you need to list all of the MySQL databases managed by Plesk along with their corresponding domains and login credentials, you can use this handy query.
You will now a full list of all the databases, user names and passwords.
I recently had a request to retrive all the ftp passwords for a domain that had a number of different FTP accounts configured in PLESK.
Here's a query i used to retrieve all the FTP account information from the Plesk internal database.
It will show you every username and password of all accounts that have been created via the Plesk panel.
I recently noticed that about 255 domains hosted on one of my Plesk 11.5 servers that had Horde set as the default webmail client. I personally dont like Horde and prefer that all domains use Roundcube.
Instead of manually updating each domain, this is what I did to do it all in one shot.