Can I specify the incident start value?
Filed under:
Helpdesk Solution
Submitted by Juicemaster on 12 July, 2006 - 04:52.
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
(6 votes)
- Login or register to post comments
- 2797 reads
- Printer-friendly version
In the same process is it
In the same process is it possible to clean-up the dummy inc incident?
Dom
Restart
Hello,
We have almost finished our testing for the 20 Helpdesk environments, we have about 2,400 incidents done in test.
Is it possible to start over from # 1?
Dom
yes you can
if you are wanting to start over, you can delete your existing incidents. then go to the incidents db and find the table next_number. from there set the value to 1. next, test it by creating a new incident.
Hello, I could delete all
Hello,
I could delete all incidents from the table workitem or you mean from the delete multiple incident?
1. from workitem the links will remain and the wcu tables might causes issues for the history and the links to the contact and asset will still be stored...
2. the delete multiple does not work on incident with linked incident, this means I would have to inactivate all validation rules to run the process... am I right?
Thanks,
Dom
You can reset back to 1 by
http://juice.altiris.com/node/1770
James "Scott" Hardie
Vice President of Technology Services
shardie@xcendgroup.com
http://www.xcendgroup.com