[otrs] Clean up the database.

[Sachin]

I have implemented OTRS as a test system. created a lot of test tickets , but now i want to make it available for production use. for that i need to delete all the tickets generated... the users created should remain.....only the ticket and customers..should go out... please help.

[Jeffery Chen Fan]

use GenericAgent
....

---------------------------------------------------------------------
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/

--
Jeffery
___
/\__\ "What is the world coming to?"
\/__/  

[Frans Stekelenburg]

You can use the Generic Agent to remove all or some ticket based on criteria.

With a bulk change you could set all or some tickets to state ‘removed’ for instance, and than run GA on it.

 

Deleting customers is harder, like for some other data types. You could do it in the database (phpmyadmin), or you can do like I do, recycle. Make them invalid, rename them to INVALID… en reuse (rename) when needed.

http://www.mail-archive.com/search?q=delete+users&l=ot...@otrs.org

 

 

New OTRS users will discover that many of the questions they have, already have been asked and answered in the past. It is therefor good practice to search the mailing list archive (beside docs, faq etc on otrs,org):

 

http://www.mail-archive.com/search=?l=ot...@otrs.org

 

gr,

Frans