How to change the port on which MySQL runs
The following are the instructions to change the port for the MySQL database.
1. Edit the ManageEngine\ServiceDesk\Bin\StartDb.bat file and change "33366" to the port on which the default MySQL runs.
2. Edit the ManageEngine\ServiceDesk\Bin\stopdb.bat file and change "33366" to the port on which the default MySQL runs.
3. Edit the ManageEngine\ServiceDesk\Bin\server\default\deploy\mysql-ds.xml file and change "33366" to the port on which the default MySQL runs. ( Change "localhost" to the IP address or hostname of the server on which MySQL runs, if you want to change the host ).
Port Occupied / Application Layer Starting
If the port is already occupied (as in the screenshot), prompt as in below screenshot will appear. Find application that uses the port by following the steps below, Execute, netstat -oan (This command will display list of processes and the ports ...
How to change the database from MySQL/PostgreSQL to MSSQL
The steps mentioned below are applicable only if you migrate the DB from PgSQL to MSSQL. This means that the application server is going to remain the same. The data alone is going to be transferred to MSSQL DB from the existing PgSQL DB. For ...
SELECT chdt.changeid "Change ID", chdt.title "Title", orgaaa.first_name "Change Requester", ownaaa.first_name "Change Owner", ...
SELECT chdt.CHANGEID AS "Change ID", chdt.TITLE AS "Title", orgaaa.FIRST_NAME AS "Change Requester", qd.QUEUENAME AS "Group", ownaaa.FIRST_NAME AS "Change Owner", catadef.CATEGORYNAME AS "Category", priodef1.PRIORITYNAME AS "Priority", ...
SELECT chdt.changeid "Change ID", chdt.title "Title", Longtodate(chdt.createdtime) "Created Time", Longtodate(chdt.scheduledstarttime) "Scheduled Start Time", ...