Query Executor Tool for PostGres
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.
New to ADSelfService Plus?
Related Articles
Remote read only access to database for Postgres customers
Frequently customers want to connect some reporting / dashboard application like PowerBI or Tableau with our Postgres database server. By default, the bundled Postgres is configured to only listen to the local machine. We can configure to allow ...Query to retrieve worklog details
Tested in: 14610 (Postgres) Query: SELECT wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", sdo.NAME AS "Site", ti.FIRST_NAME AS "Request Technician" ,au1.FIRST_NAME AS "Worklog Technician", TO_CHAR(((sum(ct.TIMESPENT))/1000 || ' ...How to Connect External Postgres
Install a External Postgres such that the version of that postgres is currently in the series of inbuilt postgres of our Application. Say for example, In Servicedeskplus Application version 14010, which has postgres version 10.21, then you should ...Query to retrieve the aging days details of requests
Tested in: 14610 (Postgres) Query: SELECT wo.WORKORDERID AS "Request ID", req.FIRST_NAME AS "Requester", LONGTODATE(wo.CREATEDTIME) AS "Created Date", LONGTODATE(wo.RESOLVEDTIME) AS "Resolved Date", (FLOOR(wo.TIMESPENTONREQ / (1000 * 60 * 60 * ...Upgrade failure when migrating privileges for removed functions
LOG Trace : 03.08.2023 12:50:36 [com.zoho.postgres.migrate.DumpMigration] [SCHWERWIEGEND] : Problem during upgrade.com.zoho.postgres.exception.MigrationFailureException: Restoration failed for PRE_DATA at ...