Thank you for your response..
After I delete the main incident cases and update the nextId of the main
form HPD:Help Desk in the arschema table, how do I know which other
tables in the arschema table I need to reset the nextId to 1 ?..
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Schon, Stuart
Sent: Wednesday, April 01, 2009 6:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: Deleting Test Data for the ITSM 7.x Suite of Applications
and Resetting Ticket IDs -
**
Hi
The ITSM suite handles cascading deletes quite well, removing all
related items when you delete the main incident case. We use it all the
time to remove test cases from the production system when we introduce
new customers.
Stuart Schon
Team Leader
Delivery Services | Advanced Support | Remedy Solutions | KAZ Group
Pty Ltd
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Jorge Polo
Sent: Thursday, 2 April 2009 5:03 AM
To: arslist@ARSLIST.ORG
Subject: Deleting Test Data for the ITSM 7.x Suite of Applications and
Resetting Ticket IDs -
**
Hello everyone,
Could anyone give me an idea how difficult is to reset ticket id's in
the Incident Management application version 7.1 ?I know that after
deleting the records in the main form I need to update the arschema
table with the number I want to start. My problem is finding the cascade
deletion for all the related tables how can I get all the tables
related to HPD:Help desk form or the list of tables I need to
update?
We have a Microsoft Server environment and Microsoft SQL server
database. AR System 7.1
Thank you.
Portions of this message may be confidential under an exemption to
Ohio's public records law or under a legal privilege. If you have
received this message in error or due to an unauthorized transmission or
interception, please delete all copies from your system without
disclosing, copying, or transmitting this message.
__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__
__Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
html___
__Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
html___
Portions of this message may be confidential under an exemption to Ohio's
public records law or under a legal privilege. If you have received this
message in error or due to an unauthorized transmission or interception, please
delete all copies from your system without disclosing, copying, or transmitting
this message.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are