Setting the ticket prefix:
In this example "SD-" will be the prefix introduced
- Login to service desk as a Administrator.
- Click on the Administration tab.
- Click on the Service Desk->sequence numbers.
- Select Requests/Incidents/Problems.
- Click on edit, In the prefix section enter "SD-"- and click on Save.
Adjusting ticket sequence numbering
CA SDM uses the MDB KEY_CONTROL table to assist with ticket numbering.
Following procedure can be followed if there is a need to change the base/starting number used by CA SDM:
- Make sure to take a good back up of the CA SDM MDB
- Run the following command to backup the Key Control table
pdm_extract Key_Control > keyctrl-backup.txt
- Run the following command to extract the specific entries of interest for sequence number in the Key Control table:
pdm_extract -f "Select * from Key_Control where key_name LIKE '%.ctl'" > keyctrl.txt
- Open the keyctrl.txt file with Notepad.
- You will find information as follows:
TABLE Key_Control
id key_name key_value
{ "151" ,"crkey.ctl" ,"20" }
{ "154" ,"chgkey.ctl" ,"14" }
{ "155" ,"isskey.ctl" ,"0" }
crkey.ctl is for Request ticket numbers
chgkey.ctl is for Change Order ticket numbers
isskey.ctl is for Issue ticket numbers
You need to modify the number next to crkey.ctl to the number you want to.
For example { "151" ,"crkey.ctl" ,"1000" }. This change will mean that CA SDM Request ticket types will start numbering from 1000.
- Save the file.
- Run the following command:
pdm_load -f keyctrl.txt
- Restart the CA SDM service