At Monday 11/6/2006 10:35 AM, Krieg, Alexander wrote:
Hi,
for some database clean up i would like to know which column in
which table to check via sql-statement to figure out, if a user is a
requestor of a Ticket.
thanx
alexander
Hello Alexander,
Unfortunately, it's more complicated than just a column in a table.
If you're considering sql deletes, you risk hosing your database if
you don't get all the connections right. I'd highly recommend writing
a perl script that uses the RT API for this kind of work.
Steve
Stephen Turner
Senior Programmer/Analyst - Client Support Services
MIT Information Services and Technology (IS&T)
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
