Yes Ctrl + D with Demo user (there are some Delete restrictions) and if you enter Worklog you should delete info for the following forms
XXX:Worklog XXX:CFG Ticket Num Generator XXX:(Process Name) where XXX is HPD, PBM and CHG Also to return ID for all the form you need to reset the "nextID" value to 1 for the specific "name" in the arschema table. Ask DBA guys. Pedro MX On 7/26/07, Oza, Veeral <[EMAIL PROTECTED]> wrote:
** Hi All, I need to clean up the existing test data from the server. What would be the best way to do it? The foundation data should remain as it is. We need to clean up Incident, change and problem tickets. Ctrl + D on these 3 forms??? or do we need to take care of other forms as well? If anyone has done this before or has any thoughts on this, please reply. Environment: ITSM 7 (Patch 1) Oracle Database on Solaris Regards, Veeral Oza, Application Developer, Column Technologies, Cell: 224-587-0765 Desk: 847-632-3327 Regards, Veeral Oza, Application Developer, Column Technologies, Cell: 224-587-0765 Desk: 847-632-3327 ------------------------------ *From:* Oza, Veeral *Sent:* Thu 7/26/2007 12:43 PM *To:* arslist@arslist.org *Subject:* Data Cleanup Hi All, I need to clean up the existing test data from the server. What would be the best way to do it? The foundation data should remain as it is. We need to clean up Incident, change and problem tickets. Ctrl + D on these 3 forms??? or do we need to take care of other forms as well? If anyone has done this before or has any thoughts on this, please reply. Regards, Veeral Oza, Application Developer, Column Technologies, Cell: 224-587-0765 Desk: 847-632-3327 __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"