Can I specify the incident start value?

Q:
Charles wrote, "We are planning on going live with Helpdesk Solution in two weeks and want to have the beginning incident number set to 300000 to avoid conflicts with our older tracking software. Is there a way to set the incident number to start at 300000?"

A:
Yes, Charles, you can easily modify the incident start value by going into your Altiris_Incidents database and changing the value in the workitem_next_number table to 300000. If you prefer, you may also use the following code to accomplish this task. The first three lines of this code will show you the current status and the last three lines will change it to 300000.

use altiris_incidents
select next_number as before
from workitem_next_number

update workitem_next_number set next_number=300000
select next_number as after
from workitem_next_number