Hi
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.
thanks.
/andreas
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.
-kevin
At Tue, 31 Jul 2012 13:34:14 -0400,
Kevin Falcone wrote:
[1 <text/plain; us-ascii (quoted-printable)>]
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