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.
John On Fri, Dec 13, 2013 at 2:11 PM, Kenneth Crocker <[email protected]>wrote: > 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: [email protected] > 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 > [email protected] > (781) 736-4619 > -- John Miller Systems Engineer Brandeis University [email protected] (781) 736-4619
