RE: [otrs] How to delete user accounts and queues?
You can create a fresh database using the SQL scripts in the scripts/ database directory.
How much configuration will you lose? I would be interested in deleting all tickets from my testing period but retain all configuration of OTRS. Downloading configuration changes from SysConf is great but it only inludes changes made outside the database. All replies, queues, agents and other things are not considered. -- Lars
Deleting the tickets can easily be done via generic agent. This cleans the ticket / article db and leaves you with an 'empty' system. For queues and groups, I found it okay to set them to invalid and maybe later 'recycle' them for new queues/groups. Much easier than to setup the whole system... Greetz Daniel -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Lars Jørgensen Sent: Freitag, 11. Januar 2008 12:09 To: otrs@otrs.org Subject: RE: [otrs] How to delete user accounts and queues?
You can create a fresh database using the SQL scripts in the scripts/ database directory.
How much configuration will you lose? I would be interested in deleting all tickets from my testing period but retain all configuration of OTRS. Downloading configuration changes from SysConf is great but it only inludes changes made outside the database. All replies, queues, agents and other things are not considered. -- Lars _______________________________________________ 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 Support or consulting for your OTRS system? =http://www.otrs.com/
Lars Jørgensen wrote:
You can create a fresh database using the SQL scripts in the scripts/ database directory.
How much configuration will you lose? I would be interested in deleting all tickets from my testing period but retain all configuration of OTRS.
If you start with a fresh database, then everything that was in the database will be lost. Configuration settings are not stored in the database, so they will remain untouched.
Downloading configuration changes from SysConf is great but it only inludes changes made outside the database. All replies, queues, agents and other things are not considered.
Replies, queues and agents are not configuration settings, so no you can't get those through SysConf's export. There are backup/restore scripts available by the way (http://doc.otrs.org/2.2/en/html/ c2528.html), but I thought you wanted to start over. Nils Breunese.
participants (3)
-
Lars Jørgensen -
Nils Breunese (Lemonbit) -
Obee, Daniel