• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    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.

List clients through CLI

M

magnusl

Guest
Anobody know of a way to retrieve a list of all client accounts through the Plesk CLI? Seems like a basic functionality, but I just can't find it.

Of course, the information has to be in a MySQL table somewhere, but I'd like to find a way of doing this in a bash script without having to query MySQL directly.
 
Hi,

I did not find such an ability in the Plesk utilities also(client.sh do not have such option).

Looks like you will have to use mysql queries.

For example, clients names can be retrieved thus:
mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa -e"select pname from clients"
 
Well, it was worth a shot. I will do it the way you described, Bender. Thank you.
 
Back
Top