At Tue, 31 Jul 2012 13:34:14 -0400, Kevin Falcone wrote: > > [1 <text/plain; us-ascii (quoted-printable)>] > On Fri, Jul 27, 2012 at 11:50:02AM +0200, Andreas Davour wrote: > > I have searched the wiki and the mailing list archive and not found any > > hints. > > > > What I'd like to do is create a list of active users, then go over that > > list or users, showing each and every queue that specific user have rights > > to post on. > > > > I know how to do it in the GUI, but then I get a lot more information which > > I don't need, and I'd like to get the data in a way that I could pipe it > > for further processing on the command line. > > > > Pointers to the documentation appreciated. I have looked around in the db > > and can't figure out how to tie the data about queue id and user id > > together. > > The easiest code (although it's a bit complex because of the caching) > is all the checking in Elements/SelectQueue - it loads up an RT::Queue > with the appropriate CurrentUser and then calls CurrentUserHasRight - > there are some other methods like Users' WhoHaveRight that might be > interesting. Doing this by hand in the DB is likely to be really > complex unless you understand all the relationships. The generated > SQL is often quite hairy.
Sounds like I will give up on that part of RT. Many thanks for your feedback Kevin! /andreas
