How to list databases with their subscription/domain/owner using MySQL queries

Follow

Comments

3 comments

  • Avatar
    Sreehari

    Can we have similar Query for MSSQL to list the DBs and their subscription/domain/owner

    0
    Comment actions Permalink
  • Avatar
    Vladimir Chernikov

    Hello @Sreehari,

    The data is gathered from the Plesk database. According to Plesk system requirements only MySQL is used for Plesk database.

    To filter MSSQL databases from Plesk database you may use the following Mysql query:
    select db.name as "Database",d.name as "Subscription",c.pname as "Owner",c.login as "Customer Username",db.type as "Server type" from data_bases db,domains d,clients c where d.cl_id=c.id and db.dom_id=d.id and db.type = 'mssql';

    0
    Comment actions Permalink
  • Avatar
    Sreehari

    Thanks Vladimir,

    I am able to figure out the MSSQL DBs by using the above query from MYSQL.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request