Re: Starting Request ID at a higher number

I have one form that requires a reset frequently. This utility is great. I just installed it, so much easier that sql logging into the database, so much easier that typing the commands, so quick. Thanks! Susan On Wed, Dec 17, 2008 at 9:23 AM, Gidd g...@buoyantsolutions.net wrote: Tim,

Re: Starting Request ID at a higher number

, 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

Re: Starting Request ID at a higher number

Tim, Take a look at this Reset Id Utility from David Sanders: http://www.westoverconsulting.co.uk/utilities.html Look for adminNextID HTH Regards...Gidd -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Timothy Rondeau

Re: Starting Request ID at a higher number

This is for oracle but must be similar for sql *Type this statement to update the id* update aradmin.arschema set nextId = *011848* where name = *'CHG:Change*'; commit; *Type this statement to find next ID* select name, nextId from aradmin.arschema where name = *'CHG:Change'*;

Re: Starting Request ID at a higher number

Thanks this works great. Tim -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Gidd Sent: Wednesday, December 17, 2008 10:23 AM To: arslist@ARSLIST.ORG Subject: Re: Starting Request ID at a higher number Tim, Take a look

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