Reset the IDs of Request, Problem and Change

MSSQL:

 

Connect to SQL studio of your SQL server.

 

Queries for the respective modules:

 

REQUEST:

 

insert into workorder(workorderid,requesterid,createdtime,respondedtime,duebytime,completedtime,timespentonreq,isparent,is_catalog_template,fr_duetime,haschange,hascausedbychange,hasproblem,surveystatus,hasdraft,resolvedtime) values (3000,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0);

 

PROBLEM: 

 

insert into problem (problemid,title,reportedtime,updatedtime,duebytime,closedtime,isread,notespresent) values(1000,’title’,0,0,0,0,0,0);

 

CHANGE: 

 

insert into changedetails (changeid,title,createdtime,scheduledstarttime,scheduledendtime,completedtime,notespresent) values(3000,’title’,0,0,0,0,0);

 

Restart the application service and try creating a new ticket to check the ID series.

 

*************************************************************************************************************************************

PGSQL:

 

C:\ManageEngine\ServiceDeskPlus-MSP\pgsql\bin> psql.exe -p 65432 -U postgres -w servicedesk

 

Queries for the respective modules:

 

REQUEST:

 

insert into workorder(workorderid,requesterid,createdtime,respondedtime,duebytime,completedtime,timespentonreq,isparent,is_catalog_template,fr_duetime,haschange,hascausedbychange,hasproblem,surveystatus,hasdraft,resolvedtime) values (3000,1,0,0,0,0,0,true,false,0,false,false,false,0,false,0);

 

PROBLEM:

 

insert into problem (problemid,title,reportedtime,updatedtime,duebytime,closedtime,isread,notespresent) values(3000,’title’,0,0,0,0,false,false);

 

CHANGE:

 

insert into changedetails (changeid,title,createdtime,scheduledstarttime,scheduledendtime,completedtime,notespresent) values(3000,’title’,0,0,0,0,false);

 

Restart the application service and try creating a new ticket to check the ID series.

 

*************************************************************************************************************************************

 

NOTE:

 

1. Kindly use only the appropriate query for the desired module.

2. On the above queries, please replace 3000 with ID’s you want to start with. This will create a dummy request in the DB and start from the next ID shown in the UI. In this query, it will start 3001 when a request is created.

3. We highly recommend you to take a trimmed backup of the application before executing the query.

4. If you want to reset the Request ID counter to 0, please refer this link.

 

 

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