I want all requests in my application to start from Request Id 19001 instead of default request Ids assigned by ServiceDesk Plus – MSP. How do I change the Request id number?

Follow the instructions given below to change the request id number,

  1. Connect to mysql database as follows:
    From the command prompt, C:\ > cd ManageEngine\ServiceDesk-MSP\mysql\bin
    mysql.exe -u root -P 33366 servicedesk
    Note: For MS SQL connect to the Query analyzer of the SQL server
  2. Create a dummy workorder as follows:
    mysql> insert into workorder (WORKORDERID, REQUESTERID) values (19000,2);
    [ 19000 is the dummy workorder id number to start the requestid from 19001. 2 is a valid requester id. You may have to check the AaaUser for a valid requester id. Rest of the values can be the same as shown above ]

  For MSSQL, please use the below query to change the request ID number, 

insert into WorkOrder(WORKORDERID,REQUESTERID,CREATEDTIME,DUEBYTIME) values (19000,2,0,0);

For Postgres

To connect to the PostGreSQL database 

 
C:\ManageEngine\ServiceDeskPlus-MSP\pgsql\bin> psql.exe -p 65432 -U postgres -w servicedesk 
 
To start the request id from a random number by following the below instructions.
 
Create a dummy workorder as follows:
servicedesk# insert into workorder (WORKORDERID, REQUESTERID,createdtime,duebytime) values (19000,2,0,0);
3.  Restart ManageEngine ServiceDesk Plus – MSP service.
Note: Existing request id numbers cannot be changed. The new request id will start from 19001.

 

 

 

 

 

 

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500