
Hi Folks, After deploying otrs newly in a server, I would like to get rid of the imaginary users (test users) from otrs. I deleted all the tickets created with Generic Agent, and I would like to get rid of those test users. Since all the tickets and users were test users, I am really not worried about "Data Consistency". So is there any way to do this in otrs 2.4.7? Thanks.... -- Deniz Rende E-mail: deniz.rende@gmail.com Phone: +1 (224) 789-UNIX (8649) Mobile: +1 (816) 213-2139 Web: http://www.deniz-rende.com/blog

Hi there,
After deleting all your tickets using GenericAgent, I guess you could remove
them directly from the database, making sure you won't delete the admin user
(ID=1), tables are named users for agents and customer_users,
customer_preferences and customer_company for customers
Leonardo Certuche
On Thu, Feb 25, 2010 at 10:44 AM, Deniz Rende
Hi Folks,
After deploying otrs newly in a server, I would like to get rid of the imaginary users (test users) from otrs. I deleted all the tickets created with Generic Agent, and I would like to get rid of those test users. Since all the tickets and users were test users, I am really not worried about "Data Consistency".
So is there any way to do this in otrs 2.4.7?
Thanks....
-- Deniz Rende E-mail: deniz.rende@gmail.com Phone: +1 (224) 789-UNIX (8649) Mobile: +1 (816) 213-2139 Web: http://www.deniz-rende.com/blog
--------------------------------------------------------------------- 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, \Use the link http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&CategoryID=4&ItemID=54to delete the ticket from OTRS. As per my knowledge it is not possible to delete the user and group from OTRS, instead of that you can inactive the group and user. Regards Sourabh Sarwate On Thu, Feb 25, 2010 at 11:08 PM, Leonardo Certuche < leonardo.certuche@itcon-ltda.com> wrote:
Hi there,
After deleting all your tickets using GenericAgent, I guess you could remove them directly from the database, making sure you won't delete the admin user (ID=1), tables are named users for agents and customer_users, customer_preferences and customer_company for customers
Leonardo Certuche
On Thu, Feb 25, 2010 at 10:44 AM, Deniz Rende
wrote: Hi Folks,
After deploying otrs newly in a server, I would like to get rid of the imaginary users (test users) from otrs. I deleted all the tickets created with Generic Agent, and I would like to get rid of those test users. Since all the tickets and users were test users, I am really not worried about "Data Consistency".
So is there any way to do this in otrs 2.4.7?
Thanks....
-- Deniz Rende E-mail: deniz.rende@gmail.com Phone: +1 (224) 789-UNIX (8649) Mobile: +1 (816) 213-2139 Web: http://www.deniz-rende.com/blog
--------------------------------------------------------------------- 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/
-- Regards, Sourabh Sarwate

Thank you Sourabh, it looks like the only way to get rid of the user would
be going into the database and delete the user from there.
So what is the recommendation here? Do I have to recreate my database? How
will this affect my install? Will I need to create my customer queues again?
Would not this mean a new set of test users and test emails?
I wish there was an easy way to get rid of the initial "test" data right
after the install...
On Fri, Feb 26, 2010 at 1:26 AM, Sourabh Sarwate
Hi,
\Use the link http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&CategoryID=4&ItemID=54to delete the ticket from OTRS. As per my knowledge it is not possible to delete the user and group from OTRS, instead of that you can inactive the group and user.
Regards Sourabh Sarwate
On Thu, Feb 25, 2010 at 11:08 PM, Leonardo Certuche < leonardo.certuche@itcon-ltda.com> wrote:
Hi there,
After deleting all your tickets using GenericAgent, I guess you could remove them directly from the database, making sure you won't delete the admin user (ID=1), tables are named users for agents and customer_users, customer_preferences and customer_company for customers
Leonardo Certuche
On Thu, Feb 25, 2010 at 10:44 AM, Deniz Rende
wrote: Hi Folks,
After deploying otrs newly in a server, I would like to get rid of the imaginary users (test users) from otrs. I deleted all the tickets created with Generic Agent, and I would like to get rid of those test users. Since all the tickets and users were test users, I am really not worried about "Data Consistency".
So is there any way to do this in otrs 2.4.7?
Thanks....
-- Deniz Rende E-mail: deniz.rende@gmail.com Phone: +1 (224) 789-UNIX (8649) Mobile: +1 (816) 213-2139 Web: http://www.deniz-rende.com/blog
--------------------------------------------------------------------- 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/
-- Regards, Sourabh Sarwate
--------------------------------------------------------------------- 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/
-- Deniz Rende E-mail: deniz.rende@gmail.com Phone: +1 (224) 789-UNIX (8649) Mobile: +1 (816) 213-2139 Web: http://www.deniz-rende.com/blog

Quesion here:
Are you connecting to an LDAP or are you using database backend for them? If
the answer is the latter, you could edit your test users (using the front
end or a database update) and for the rest of users, you could use the
/opt/otrs/bin/otrs.add* scripts to create the remaining users.
Leonardo Certuche
On Fri, Feb 26, 2010 at 12:20 PM, Deniz Rende
Thank you Sourabh, it looks like the only way to get rid of the user would be going into the database and delete the user from there.
So what is the recommendation here? Do I have to recreate my database? How will this affect my install? Will I need to create my customer queues again? Would not this mean a new set of test users and test emails?
I wish there was an easy way to get rid of the initial "test" data right after the install...
On Fri, Feb 26, 2010 at 1:26 AM, Sourabh Sarwate
wrote: Hi,
\Use the link http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&CategoryID=4&ItemID=54to delete the ticket from OTRS. As per my knowledge it is not possible to delete the user and group from OTRS, instead of that you can inactive the group and user.
Regards Sourabh Sarwate
On Thu, Feb 25, 2010 at 11:08 PM, Leonardo Certuche < leonardo.certuche@itcon-ltda.com> wrote:
Hi there,
After deleting all your tickets using GenericAgent, I guess you could remove them directly from the database, making sure you won't delete the admin user (ID=1), tables are named users for agents and customer_users, customer_preferences and customer_company for customers
Leonardo Certuche
On Thu, Feb 25, 2010 at 10:44 AM, Deniz Rende
wrote: Hi Folks,
After deploying otrs newly in a server, I would like to get rid of the imaginary users (test users) from otrs. I deleted all the tickets created with Generic Agent, and I would like to get rid of those test users. Since all the tickets and users were test users, I am really not worried about "Data Consistency".
So is there any way to do this in otrs 2.4.7?
Thanks....
-- Deniz Rende E-mail: deniz.rende@gmail.com Phone: +1 (224) 789-UNIX (8649) Mobile: +1 (816) 213-2139 Web: http://www.deniz-rende.com/blog
--------------------------------------------------------------------- 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/
-- Regards, Sourabh Sarwate
--------------------------------------------------------------------- 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/
-- Deniz Rende E-mail: deniz.rende@gmail.com Phone: +1 (224) 789-UNIX (8649) Mobile: +1 (816) 213-2139 Web: http://www.deniz-rende.com/blog
--------------------------------------------------------------------- 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/

The initial plan was to connect to an ldap, but that piece is still in the works. So, yes in this case database backend for now. How do you go about using the front end? I though it was not possible to do that through otrs. Are you suggesting to use some kind of a front end gui app for the database to remove users? I am using MySql 5.1 for the database... Thanks... On Fri, Feb 26, 2010 at 12:20 PM, Leonardo Certuche < leonardo.certuche@itcon-ltda.com> wrote:
Quesion here:
Are you connecting to an LDAP or are you using database backend for them? If the answer is the latter, you could edit your test users (using the front end or a database update) and for the rest of users, you could use the /opt/otrs/bin/otrs.add* scripts to create the remaining users.
Leonardo Certuche
On Fri, Feb 26, 2010 at 12:20 PM, Deniz Rende
wrote: Thank you Sourabh, it looks like the only way to get rid of the user would be going into the database and delete the user from there.
So what is the recommendation here? Do I have to recreate my database? How will this affect my install? Will I need to create my customer queues again? Would not this mean a new set of test users and test emails?
I wish there was an easy way to get rid of the initial "test" data right after the install...
On Fri, Feb 26, 2010 at 1:26 AM, Sourabh Sarwate
wrote: Hi,
\Use the link http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&CategoryID=4&ItemID=54to delete the ticket from OTRS. As per my knowledge it is not possible to delete the user and group from OTRS, instead of that you can inactive the group and user.
Regards Sourabh Sarwate
On Thu, Feb 25, 2010 at 11:08 PM, Leonardo Certuche < leonardo.certuche@itcon-ltda.com> wrote:
Hi there,
After deleting all your tickets using GenericAgent, I guess you could remove them directly from the database, making sure you won't delete the admin user (ID=1), tables are named users for agents and customer_users, customer_preferences and customer_company for customers
Leonardo Certuche
On Thu, Feb 25, 2010 at 10:44 AM, Deniz Rende
wrote: Hi Folks,
After deploying otrs newly in a server, I would like to get rid of the imaginary users (test users) from otrs. I deleted all the tickets created with Generic Agent, and I would like to get rid of those test users. Since all the tickets and users were test users, I am really not worried about "Data Consistency".
So is there any way to do this in otrs 2.4.7?
Thanks....
-- Deniz Rende E-mail: deniz.rende@gmail.com Phone: +1 (224) 789-UNIX (8649) Mobile: +1 (816) 213-2139 Web: http://www.deniz-rende.com/blog
--------------------------------------------------------------------- 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/
-- Regards, Sourabh Sarwate
--------------------------------------------------------------------- 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/
-- Deniz Rende E-mail: deniz.rende@gmail.com Phone: +1 (224) 789-UNIX (8649) Mobile: +1 (816) 213-2139 Web: http://www.deniz-rende.com/blog
--------------------------------------------------------------------- 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/
-- Deniz Rende E-mail: deniz.rende@gmail.com Phone: +1 (224) 789-UNIX (8649) Mobile: +1 (816) 213-2139 Web: http://www.deniz-rende.com/blog

Hi Deniz,
If you go to /otrs/index.pl?Action=AdminUser and type * on the search box,
you'll be able to see all users you created. If you click on any of them
you'll be able to change ANY field, that's the piece of front end gui app
you're probably looking for. If you prefer to use a gui app to edit directly
your database tables, you could use http://www.phpmyadmin.net
Leonardo Certuche
On 26 February 2010 14:06, Deniz Rende
The initial plan was to connect to an ldap, but that piece is still in the works. So, yes in this case database backend for now.
How do you go about using the front end? I though it was not possible to do that through otrs. Are you suggesting to use some kind of a front end gui app for the database to remove users? I am using MySql 5.1 for the database...
Thanks...
On Fri, Feb 26, 2010 at 12:20 PM, Leonardo Certuche < leonardo.certuche@itcon-ltda.com> wrote:
Quesion here:
Are you connecting to an LDAP or are you using database backend for them? If the answer is the latter, you could edit your test users (using the front end or a database update) and for the rest of users, you could use the /opt/otrs/bin/otrs.add* scripts to create the remaining users.
Leonardo Certuche
On Fri, Feb 26, 2010 at 12:20 PM, Deniz Rende
wrote: Thank you Sourabh, it looks like the only way to get rid of the user would be going into the database and delete the user from there.
So what is the recommendation here? Do I have to recreate my database? How will this affect my install? Will I need to create my customer queues again? Would not this mean a new set of test users and test emails?
I wish there was an easy way to get rid of the initial "test" data right after the install...
On Fri, Feb 26, 2010 at 1:26 AM, Sourabh Sarwate
wrote: Hi,
\Use the link http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&CategoryID=4&ItemID=54to delete the ticket from OTRS. As per my knowledge it is not possible to delete the user and group from OTRS, instead of that you can inactive the group and user.
Regards Sourabh Sarwate
On Thu, Feb 25, 2010 at 11:08 PM, Leonardo Certuche < leonardo.certuche@itcon-ltda.com> wrote:
Hi there,
After deleting all your tickets using GenericAgent, I guess you could remove them directly from the database, making sure you won't delete the admin user (ID=1), tables are named users for agents and customer_users, customer_preferences and customer_company for customers
Leonardo Certuche
On Thu, Feb 25, 2010 at 10:44 AM, Deniz Rende
wrote: Hi Folks,
After deploying otrs newly in a server, I would like to get rid of the imaginary users (test users) from otrs. I deleted all the tickets created with Generic Agent, and I would like to get rid of those test users. Since all the tickets and users were test users, I am really not worried about "Data Consistency".
So is there any way to do this in otrs 2.4.7?
Thanks....
-- Deniz Rende E-mail: deniz.rende@gmail.com Phone: +1 (224) 789-UNIX (8649) Mobile: +1 (816) 213-2139 Web: http://www.deniz-rende.com/blog
--------------------------------------------------------------------- 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/
-- Regards, Sourabh Sarwate
--------------------------------------------------------------------- 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/
-- Deniz Rende E-mail: deniz.rende@gmail.com Phone: +1 (224) 789-UNIX (8649) Mobile: +1 (816) 213-2139 Web: http://www.deniz-rende.com/blog
--------------------------------------------------------------------- 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/
-- Deniz Rende E-mail: deniz.rende@gmail.com Phone: +1 (224) 789-UNIX (8649) Mobile: +1 (816) 213-2139 Web: http://www.deniz-rende.com/blog
--------------------------------------------------------------------- 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 Deniz,
If you have skeleton db for OTRS you can droop and recreate but I have not
tried this thing.In OTRS you can inactive the user, group and queue but you
can not delete these entity. Hope if I am wrong some one from forum will
correct me.
My recommendation is use two setup of OTRS one for testing and one for
production.its always a better practice to make the changes on testing setup
before finaly implementing it on production server.
Regards
Sourabh Sarwate
On Fri, Feb 26, 2010 at 10:50 PM, Deniz Rende
Thank you Sourabh, it looks like the only way to get rid of the user would be going into the database and delete the user from there.
So what is the recommendation here? Do I have to recreate my database? How will this affect my install? Will I need to create my customer queues again? Would not this mean a new set of test users and test emails?
I wish there was an easy way to get rid of the initial "test" data right after the install...
On Fri, Feb 26, 2010 at 1:26 AM, Sourabh Sarwate
wrote: Hi,
\Use the link http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&CategoryID=4&ItemID=54to delete the ticket from OTRS. As per my knowledge it is not possible to delete the user and group from OTRS, instead of that you can inactive the group and user.
Regards Sourabh Sarwate
On Thu, Feb 25, 2010 at 11:08 PM, Leonardo Certuche < leonardo.certuche@itcon-ltda.com> wrote:
Hi there,
After deleting all your tickets using GenericAgent, I guess you could remove them directly from the database, making sure you won't delete the admin user (ID=1), tables are named users for agents and customer_users, customer_preferences and customer_company for customers
Leonardo Certuche
On Thu, Feb 25, 2010 at 10:44 AM, Deniz Rende
wrote: Hi Folks,
After deploying otrs newly in a server, I would like to get rid of the imaginary users (test users) from otrs. I deleted all the tickets created with Generic Agent, and I would like to get rid of those test users. Since all the tickets and users were test users, I am really not worried about "Data Consistency".
So is there any way to do this in otrs 2.4.7?
Thanks....
-- Deniz Rende E-mail: deniz.rende@gmail.com Phone: +1 (224) 789-UNIX (8649) Mobile: +1 (816) 213-2139 Web: http://www.deniz-rende.com/blog
--------------------------------------------------------------------- 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/
-- Regards, Sourabh Sarwate
--------------------------------------------------------------------- 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/
-- Deniz Rende E-mail: deniz.rende@gmail.com Phone: +1 (224) 789-UNIX (8649) Mobile: +1 (816) 213-2139 Web: http://www.deniz-rende.com/blog
--------------------------------------------------------------------- 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/
participants (3)
-
Deniz Rende
-
Leonardo Certuche
-
Sourabh Sarwate