How to change the starting request ID number in ManageEngine SupportCenter Plus. For ServiceDesk Plus MSP, see ManageEngine ServiceDesk Plus MSP.
In the ManageEngine installation directory, I’ll assume C:\ManageEngine\SupportCenter
For MySQL
- C:\ManageEngine\SupportCenter\mysql\bin\mysql.exe -u root -P 33356 supportcenter
- mysql> insert into workorder (WORKORDERID,REQUESTERID,DEPARTMENTID) values (4999,2,1);
Where request ID is 4999, Requesterid is 2 and Department ID is 1 - Restart SupportCenter service
For MSSQL
- insert into workorder (WORKORDERID,REQUESTERID,CREATEDTIME,DUEBYTIME,DEPARTMENTID) values (4999,2,0,0,1);
- Restart SupportCenter service
For Postgres
- C:\ManageEngine\SupportCenter\pgsql\bin\psql.exe -U postgres -p 65432 -d supportcenter
- postgres# insert into workorder (WORKORDERID,REQUESTERID,CREATEDTIME,DUEBYTIME,DEPARTMENTID) values (4999,2,0,0,1);
- Restart SupportCenter service