Requestor of a Ticket

RT Users
1

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

2

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)