There is an easier way to change your Request ID values then using SQL commands. You could build a view form to arschema. This will give you what could be valuable information on all of your forms including next ID. You can make the change there.
Of course the gotchas that Candace talks about are still valid. HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Decou, Candace M Sent: Wednesday, December 17, 2008 8:26 AM To: arslist@ARSLIST.ORG Subject: Re: Starting Request ID at a higher number Yes, but also be aware that you will need to deal with the various ticket number generator forms if you are using any of the OOB apps and I believe there is one for each primary form, e.g., one for Change, one for Incident, etc. We have had to do this a number of times after importing large batches of data into the system in order to reset the correct value that will populate the Change ID, etc. This however is the result of having to import data that has very precisely defined Change ID's to begin with (and which are imported) and may not be a problem in your scenario, but just be aware of it. :) Candace -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Wednesday, December 17, 2008 6:11 AM To: arslist@ARSLIST.ORG Subject: AW: Starting Request ID at a higher number Update arschema set nextid = 1000 where name = '<Name of your form>' -----Ursprüngliche Nachricht----- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Timothy Rondeau Gesendet: Mittwoch, 17. Dezember 2008 15:10 An: arslist@ARSLIST.ORG Betreff: Starting Request ID at a higher number Hi, Hoping someone can refresh my memory. I want to start a new form at a higher request ID than 1. So say 1000, I know there is a command to do this. We are on Windows 2003, SQL 2000. ars 7.0.1 Thanks Tim _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"