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, 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 Sent: Wednesday, December 17, 2008 6:10 AM To: arslist@ARSLIST.ORG Subject: 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
Re: Starting Request ID at a higher number
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
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 Sent: Wednesday, December 17, 2008 6:10 AM To: arslist@ARSLIST.ORG Subject: 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
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'*; Susan On Wed, Dec 17, 2008 at 8:10 AM, Timothy Rondeau timothy.rond...@phaseforward.com wrote: 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
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 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 Sent: Wednesday, December 17, 2008 6:10 AM To: arslist@ARSLIST.ORG Subject: 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
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