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/

Hi, On 20.01.2010, at 11:02, Marco Vannini wrote:

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

i do not know if this would fit your needs, but if you delete the package "ITSMConfigurationManagement" all the tables for that package are deleted. After a nre installation of that single package you will have a clean CI DB. Be careful beacuse all you own class definitions are deleted as well, so you could copy and paste them from "ConfigItem" or just backup the related DB table and copy the content back after new installation of the CM package. Nils Leideck -- Nils Leideck Senior Consultant nils.leideck@leidex.net nils.leideck@otrs.com http://webint.cryptonode.de / a Fractal project CU @ CeBIT 2010 in Hannover, Germany and get to know more about OTRS at booth no. C37 in hall 2 from March 2-6, 2010!