This tool is designed to execute queries in the customer environment by connecting the database by reading the database configuration file. We need to enter the query that we require to execute in queryToExecute.txt file. We can enter multiple queries separated by a new line.
Note :
- This tool is only tested in the Postgres environment.
- This tool is not designed for executing sensitive queries in cx environment.
- Please take a backup of the database before running this tool.
How to use the Tool?
- Download the attached QueryExecutor.zip and extract it on the <servicedeskplus_home> directory. A folder will be created at <servicedeskplus_home>\QueryExecutor.
- Start the ServiceDeskPlus Application service / Database Server.
- Navigate into <servicedeskplus_home>\QueryExecutor folder
- Replace the queryToExecute.txt with the input file that you have provided.
- Execute run.bat or .sh in the same folder, after these steps.
- Stop the application server / Database Server.
Share the queryExecutor.log file generated in the <servicedeskplus_home>\QueryExecutor folder to analyse further.