Hi, Mark Mertel a écrit:
Kannan, it is unfortunate there is no UI for deleting users, nor is there a method in Kernel::System::User to accomplish this. There may be some referential integrity constraints in the database which may make it a bad idea to delete users - i.e. fields in other table which rely on a corresponding record in the user table in order to join properly. I am not familiar enough with OTRS to answer that question. However, the SQL to add a user is easily found in the Kernel::System::User->UserAdd method, and one can easily extrapolate the corresponding delete statement accordingly. The same is true for Queue and SystemAddress. You may be able to formulate the appropriate SQL, but executing it may be a problem if there is other data which depends on it. Better check with the OTRS folks on this first. my $deleteSQL = "DELETE system_user where login = 'login_name'";
In order not to mess up your DB, use the "valide" field both in users and customer users ... (it's quite in every object props !) or if you just want to delete some samples you entered to "play" with Otrs, just create a fresh new DB ... but be very careful modifying your DB manually, you may have strange things later ... MaNU
Dear All,
I have installed OTRS and slowly getting acquainted with its nice features. Want to know whether there is a provision for deleting users, ( both customer and Agent ) , Queue and System Address. If there is no interface , kindly guide me about the sql's to run on the DB for the removal of the above that will also delete all the dependencies.
Also it will be very helpful if some one can tell me about how to restrict the queues ( OR emai id's ) that gets listed in the To field of the Customer Message interface that is used to create New Ticket. ( That is , I don't want to display all the queues OR system emai ids in the New Ticket Creation Page because this causes confusion in the customer users ).
Again, congrats to the developers of OTRS for a really good product .
Thanking you,
Kannan.
Yahoo! India Matrimony: Find your partner online.Post your profile.
--- Mark Mertel mmertel@olympus.net Phone 206-322-9074 Cell 206-409-2018 _______________________________________________ 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 oder Consulting für Ihr OTRS System? => http://www.otrs.de/