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