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

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)

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)

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
http://wiki.bestpractical.com/index.cgi?CleanlyCustomizeRT. 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)