To find the database connected to your installation, open Command Prompt with elevated permission, navigate to [AE-Home]\bin directory and invoke the batch file 'changeDBServer.bat'. [AE-Home] is Drive:\ManageEngine\AssetExplorer\ directory.
For MSSQL database
Connect to the query analyzer of the SQL server and execute the queries.
For PGSQL database
Open command prompt on the application server and connect to the folder ManageEngine\AssetExplorer\pgsql\bin> and use the command