RT 3.8.8: Which users have privileges on which

RT Users
1

queues?
MIME-Version: 1.0
Content-Type: text/plain; charset=“utf-8”
Content-Transfer-Encoding: quoted-printable

Have you tried Rights Matrix?

KennSent: =E2=80=8E12/=E2=80=8E13/=E2=80=8E2013 8:37 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RT 3.8.8: Which users have privileges on which
queues?
Hello everyone,

We’re running RT 3.8.8 (yes, I know it’s old…). We’re managing our=20
group and queue privileges via RT itself, rather than LDAP. How can we=20
generate a report that shows us per queue which users have rights?

I dug through the database schema for about an hour; decided it was=20
better to ask than to keep digging.

John
–=20
John Miller
Systems Engineer
Brandeis University
johnmill@brandeis.edu
(781) 736-4619

2

Hi Kenn,

No–hadn’t heard of Rights Matrix before–will give it a shot.

JohnOn Fri, Dec 13, 2013 at 2:11 PM, Kenneth Crocker kenn.crocker@gmail.comwrote:

queues?
MIME-Version: 1.0
Content-Type: text/plain; charset=“utf-8”
Content-Transfer-Encoding: quoted-printable

Have you tried Rights Matrix?

Kenn

Sent from my Windows Phone From: John Miller
Sent: =E2=80=8E12/=E2=80=8E13/=E2=80=8E2013 8:37 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RT 3.8.8: Which users have privileges on which
queues?
Hello everyone,

We’re running RT 3.8.8 (yes, I know it’s old…). We’re managing our=20
group and queue privileges via RT itself, rather than LDAP. How can we=20
generate a report that shows us per queue which users have rights?

I dug through the database schema for about an hour; decided it was=20
better to ask than to keep digging.

John
–=20
John Miller
Systems Engineer
Brandeis University
johnmill@brandeis.edu
(781) 736-4619

John Miller
Systems Engineer
Brandeis University
johnmill@brandeis.edu
(781) 736-4619

3

Just gave Rights Matrix a look. Is there a way to do a more generalized
query–to say look at all groups simultaneously, rather than one at a
time? I’d also like to join against the users table, and roll the whole
thing up into a report. Ideally if someone can point me toward some SQL
that would do the job, that’d work as well.

JohnOn Fri, Dec 13, 2013 at 2:11 PM, Kenneth Crocker kenn.crocker@gmail.comwrote:

queues?
MIME-Version: 1.0
Content-Type: text/plain; charset=“utf-8”
Content-Transfer-Encoding: quoted-printable

Have you tried Rights Matrix?

Kenn

Sent from my Windows Phone From: John Miller
Sent: =E2=80=8E12/=E2=80=8E13/=E2=80=8E2013 8:37 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RT 3.8.8: Which users have privileges on which
queues?
Hello everyone,

We’re running RT 3.8.8 (yes, I know it’s old…). We’re managing our=20
group and queue privileges via RT itself, rather than LDAP. How can we=20
generate a report that shows us per queue which users have rights?

I dug through the database schema for about an hour; decided it was=20
better to ask than to keep digging.

John
–=20
John Miller
Systems Engineer
Brandeis University
johnmill@brandeis.edu
(781) 736-4619

John Miller
Systems Engineer
Brandeis University
johnmill@brandeis.edu
(781) 736-4619