Re: Deleting Test Data for the ITSM 7.x Suite of Applications and Resetting Ticket IDs -

2009-04-02 Thread Jorge Polo
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


Re: Deleting Test Data for the ITSM 7.x Suite of Applications and Resetting Ticket IDs -

2009-04-01 Thread Schon, Stuart
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___ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are