The below KB is applicable for all editions & from version 12.6.262 and above. Please follow this on Support team request.
Question: How to connect to OpManager PgSQL Database via command prompt?
Solution:
Please follow the below steps to connect the standalone DB executor in OpManager.
1. Stop the ManageEngine OpManager service.
2. Open an admin command prompt and navigate to OpManager<HOME>\bin directory.
3. Execute StandaloneDBQueryExecutor.bat (.sh file for Linux)
4. This will prompt for Super Admin credential. Provide the OpManager UI login default user "admin" credential.
5. Select Option 2 to execute "Select" query.
Note: Kindly do not execute any other queries like "insert, update, delete" without Support team assistance or confirmation as this may lead to data loss.
6. Execute the Select query and save the output to a text file.
7. Finally, enter the option 3 to exit the DB connection.
8. Close the command prompt and start the ManageEngine OpManager service for continuous monitoring.