Changing the RequestID to start from a particular number
To change the RequestID to an number of you choice follow steps below.
1. Connect to SupportCenterPluss MySql database
eg)
eg)
C:\\SupportCenter\\mysql\\bin>mysql.exe -u root -P 33356 supportcenter
2. Insert a dummy request with requestid and requesterid
eg)
mysql> insert into workorder (WORKORDERID,REQUESTERID,DEPARTMENTID) values (4999,2,1);
where request ID is 4999, Requesterid is 2 and Department ID is 1
3.Shutdown SupportCenterPlus and restart it.
4.The next new request that you will create will have the requestid 5000.
For MSSQL database
insert into workorder (WORKORDERID,REQUESTERID,CREATEDTIME,DUEBYTIME,DEPARTMENTID) values (4999,2,0,0,1);
For Postgres database:
postgres# insert into workorder (WORKORDERID,REQUESTERID,CREATEDTIME,DUEBYTIME,DEPARTMENTID) values (4999,2,0,0,1);
For MSSQL database
insert into workorder (WORKORDERID,REQUESTERID,CREATEDTIME,DUEBYTIME,DEPARTMENTID) values (4999,2,0,0,1);
For Postgres database:
postgres# insert into workorder (WORKORDERID,REQUESTERID,CREATEDTIME,DUEBYTIME,DEPARTMENTID) values (4999,2,0,0,1);
New to ADSelfService Plus?
Related Articles
Set Request Id to start from a particular number - Version 11.0.
Regarding the First Portal (General), you can use the below steps to change the Request Id to start from 136000. 1.The below Select Query will give the last active ticket ID. Select * from SeqGenState where seqname='WorkOrder.WORKORDERID'; 2.Then, ...Script to Auto close Request when the status is Resolved for a particular number of days
For version 11 and above: -> In version 11, we only have the option to set the request Auto-close for a max of 10 days -> The below script will help you to extend the auto-closure time Execution steps: 1. Go to Reports--> New Query Report and run the ...Phone number need to be mandatory in 8.1 for contacts
Kindly follow the steps below to create the FAFR, 1. Access admin Module 2. Select the request template option and click the edit option the required request template the script needs to be applied on 3. Select the Fields and Forms Rule tab and paste ...How to Change default password on PGSQL database
Please do follow the below steps which would assist you in changing the default Postgres password. 1. Stop the application services. 2. Please take a trimmed backup <OR> take a Snapshot of the Server 3. Open Command Prompt with Admin Privileges ...Trying to start PostgresSQL server failed - While Upgrading
Error Trace. Trying to start PostgresSQL server failed java.net.ConnectException: Trying to start PostgresSQL server failed at com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer.startDBServer(DefaultPostgresDBInitializer.java:177) at ...