How to change the order of Requestid

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

If MYSQL

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 : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500