Re: [otrs] How to delete CI's

sorry, there right db schema is in http://doc.otrs.org/itsm/1.3/en/html/c427.html On Wed, Jan 20, 2010 at 11:00 AM, Marco Vannini wrote:

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 ... )

MV

On Wed, Jan 20, 2010 at 8:46 AM, Arpit2 G 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." From: Marco Vannini Sent by: otrs-bounces@otrs.org Date: 01/20/2010 01:09PM Subject: Re: [otrs] How to delete CI's

if 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 from

http://doc.otrs.org/2.4/en/html/x531.html

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/