SQL query to locate administrators

RT Users
1

Hi all,

I’ve been navigating the rt3 database schema and have had a difficult time
of locating a table that has ACL/admin information. I’d ultimately like to
be able to run a query to select all of the users that have administrative
rights on queues. The privilege escalation routine in RT3 is a bit more
complex I’m afraid, but in the off chance that it isn’t, if anyone has any
recommendations that would be great.

Thanks all!

Steve

2

Hi all,

I've been navigating the rt3 database schema and have had a

difficult time of locating a table that has ACL/admin information. I’d
ultimately like to be able to run a query to select all of the users that
have administrative rights on queues. The privilege escalation routine in
RT3 is a bit more complex I’m afraid, but in the off chance that it isn’t,
if anyone has any recommendations that would be great.

Thanks all!

Steve -

Use a perl script and the RT API to do this. You’ll save yourself a lot of
pain…

Steve
Stephen Turner
Senior Programmer/Analyst - Client Support Services
MIT Information Services and Technology (IS&T)

3

Thanks for the reply Steve.

Any chance you can point me to information on the RT API? Is this a perl
module that’s accessible through CPAN?

Thanks again,

SteveOn 1/10/07, Stephen Turner sturner@mit.edu wrote:

    From: rt-users-bounces@lists.bestpractical.com

[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Steve
Finkelstein
Sent: Wednesday, January 10, 2007 3:56 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] SQL query to locate administrators

    Hi all,

    I've been navigating the rt3 database schema and have had a

difficult time of locating a table that has ACL/admin information. I’d
ultimately like to be able to run a query to select all of the users that
have administrative rights on queues. The privilege escalation routine in
RT3 is a bit more complex I’m afraid, but in the off chance that it isn’t,
if anyone has any recommendations that would be great.

    Thanks all!

Steve -

Use a perl script and the RT API to do this. You’ll save yourself a lot of
pain…

Steve

Stephen Turner
Senior Programmer/Analyst - Client Support Services
MIT Information Services and Technology (IS&T)

4

Thanks for the reply Steve.

Any chance you can point me to information on the RT API? Is this a

perl module that’s accessible through CPAN?

Thanks again,

Steve

Hi Steve,

The API is made up of the perl modules found under $RTHOME/lib. There’s an
overlay scheme in use, described in
Request Tracker Wiki. You can learn
how the API is used by digging into the mason components under
$RTHOME/share/html.

You can see the doc for the API by using perldoc: for example

perldoc Ticket_Overlay.pm

Good luck,
Steve
Stephen Turner
Senior Programmer/Analyst - Client Support Services
MIT Information Services and Technology (IS&T)