It is not so easy I think, depending if you have defined linkage between items too...BTW, deleting all records in configitem* tables should be enough but then, as told before, there should be still records in links* tables.ftp://ftp.otrs.org/pub/otrs/misc/otrs-2.4-database.png could you give an idea on what is where... ;)
(don't forget to do a backup before any activity ... )MVOn Wed, Jan 20, 2010 at 8:46 AM, Arpit2 G <arpit2.g@tcs.com> wrote:
Hello Marco,
I do not want to delete my Agent data, Queue details etc.. Is there any method by which i can only delete the CI's and tickets.
Thanks & Regards
Arpit Gupta
-----otrs-bounces@otrs.org wrote: -----To: "User questions and discussions about OTRS." <otrs@otrs.org>
From: Marco Vannini <marco.vannini@gmail.com>
Sent by: otrs-bounces@otrs.org
Date: 01/20/2010 01:09PM
Subject: Re: [otrs] How to delete CI'sif CI and ticket are not the only thing that have to be deleted....drop database otrs from mysql;and proceed with steps---------------------------------------------------------------------3.2.4.2. Installing the OTRS database manually
On Tue, Jan 19, 2010 at 1:59 PM, Arpit2 G < arpit2.g@tcs.com > wrote:
Hello Everyone,
I have completed the testing of OTRS in my environment, now i want to
delete the CI's and Tickets from System. for tickets i guess we can delete
them by Generic Agent, Please guide me how to delete the CI's.
Regards
A G
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/=====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/