Re: Created 15,000 tickets

[Kemes, Lisa]

** You're nextID would be 7001 though.... From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Wednesday, September 06, 2006 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Created 15,000 tickets ** Here's the SQL that we use to reset the request id:  update ARAdmin.arschema set nextId = 1763 where name = 'FormName'; From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris Sent: Wednesday, September 06, 2006 3:11 PM To: arslist@ARSLIST.ORG Subject: Created 15,000 tickets ** Hi all,   Because some workflow had the wrong qualification from a previous developer, 15,000 tickets were generated.  We left off at 7,000 and now we are at 22,000.  Isn't there a way thru SQL to reset the value of the HPD to 7,000 so Remedy goes to set the next ID, it will think the last ID is 7,000.  We also want to rename the HPD tickets created today with a 7,000 value within the database.    Our case ID is C1, I can find out the t table, I am just not sure which command I would enter to modify the rows in the database.  And if this will present problems later.  I know the users will be referencing the wrong ticket number.  We definitely do not want to be at 22,000.     __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___