Finding List of Database used by a SharePoint farm using SQL Query in Configuration Database

There are times when we ignore the clean up process of any database server which are used by various SharePoint farm. So when we remove a farm with out bothering about the Database used then its becomes very difficult to identify the Databases used. At the same time we do not have the SP farm with us to check using Central Admin for PowerShell command. So if you came across this kind of scenario don't worry we have the solutions here.Using following query we can find out the Database names...Step 1: Run the below query in Configuration Database 

===================== Query 1===============================
SELECT Id
    ,BaseClassId
    ,FullName
 FROM Classes
WHERE FullName LIKE 'Microsoft.SharePoint.Administration.SPDatabase,%'
========================================================

This will give a GUID.

Now using that ID execute the below query.

===================== Query 2===============================
DECLARE @returnValue int,
                @RequestGuid uniqueidentifier

EXEC @returnValue = [dbo].[proc_getObjectsByBaseClass]
         @BaseClassId = 'USE THE ID GOT IN ABOVE QUERY',
         @ParentId = NULL,
         @RequestGuid = @RequestGuid OUTPUT

SELECT @RequestGuid as N'@RequestGuid'
SELECT 'Return Value' = @returnValue

This will list out the ID (GUID) assigned for each Database.

===================== Query 3===============================
Using one by one you can get the all the database names in the column named 'Name'

DECLARE @returnValue int,
                @RequestGuid uniqueidentifier

EXEC @returnValue = [dbo].[proc_getObject]
         @Id = 'ID of Last Result',
         @RequestGuid = @RequestGuid OUTPUT

SELECT @RequestGuid as N'@RequestGuid'
SELECT 'Return Value' = @returnValue