How to change the order of Requestid

we can change the order of the request ID by making an entry in the database.


1.    Connect to mysql database as follows:

            From the command prompt, C:\ > cd ManageEngine\ServiceDesk Plus – MSP\mysql\bin
cmd > mysql.exe -u root -P 33366 service desk
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 


3.    Restart ManageEngine ServiceDesk Plus – MSP service.

Note: Existing request id numbers cannot be changed. The new request id will start from 19001.

If MSSQL database use this:


insert into workorder values (100,3,NULL,1272349158046,0,0,0,0,’test’,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,-1,0,0,0,0,0)



If PGSQL database, use this



insert into workorder values (100,3,NULL,1272349158046,0,0,0,0,’test’,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,’1′,NULL,NULL,’0′,-1,’0′,’0′,’0′,’0′,’0′);

Note: You can change 100 with number required. But it should be only a number but not an alphanumeric value. 



Case 2: reset the requestId to 0

1. Delete all the request in ServiceDesk Plus – MSP

2. Connect to the database and execute the below query.

delete from seqgenstate where seqname like ‘%workord%’

3. Restart ServiceDesk Plus – MSP

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 :
Toll Free : 1-888-720-9500