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
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
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