Hi All again I have write Below Query, and is working for me, posting here for community review and sugessions.
SELECT DISTINCT Queues.id AS Q_ID, Groups.id AS R_Gr_ID, Groups.Type As Gr_Type, CachedGroupMembers.MemberId AS RoleMember_id, Principals.PrincipalType AS PrincipalType, Users.Name AS UserShortID FROM Queues, Groups, CachedGroupMembers, Principals, Users WHERE Queues.id = 5 AND Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = Queues.id AND CachedGroupMembers.GroupId = Groups.id AND Principals.id = CachedGroupMembers.MemberId AND Principals.Disabled = 0 AND Principals.PrincipalType = 'user' AND Users.id = Principals.id; On Fri, Feb 13, 2009 at 12:05 AM, Rana Tanveer <ranatanv...@gmail.com>wrote: > Hi Torsten BrummThanks for your resopnse. but i need simple SQL query to > get watchers from RT Database. > > my requirement is specific, because i am also creating monitoring script > for my RT Service. > > Again i want to mention, i am using RT 3.8.1. could anyone have this query. > > I read the stuff on wiki but no clue, below is only for Ticket Watchers. > http://wiki.bestpractical.com/view/GetWatcherInfoByTicket > > My Requirement = i want simple query to get current watchers of all the > enable Queues. > > Thanks and Regards. > > Rana Tanveer > > > On Mon, Feb 9, 2009 at 5:00 PM, Torsten Brumm < > torsten.br...@googlemail.com> wrote: > >> Hi Rana, >> >> try this out: >> http://search.cpan.org/~elacour/RT-Extension-WatchedQueues-0.03/lib/RT/Extension/WatchedQueues.pm<http://search.cpan.org/%7Eelacour/RT-Extension-WatchedQueues-0.03/lib/RT/Extension/WatchedQueues.pm> >> >> I think it is what you are looking for. >> >> Torsten >> >> 2009/2/8 Rana Tanveer <ranatanv...@gmail.com> >> >>> Hi Everyone >>> >>> I am using RT 3.8.1 on Fedora 10. >>> >>> I need one query from you, i want to get watchers of Queues from RT >>> database to display at my site for management review. >>> can anyone help me out in this query ? >>> >>> >>> -- >>> --------------------------------------------- >>> Rana Tanveer >>> +923224194457 >>> http://www.sysadminsline.com >>> --------------------------------------------- >>> >>> _______________________________________________ >>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >>> >>> Community help: http://wiki.bestpractical.com >>> Commercial support: sa...@bestpractical.com >>> >>> >>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >>> Buy a copy at http://rtbook.bestpractical.com >>> >> >> >> >> -- >> MFG >> >> Torsten Brumm >> >> http://www.torsten-brumm.de >> > > > > -- --------------------------------------------- Rana Tanveer +923224194457 http://www.sysadminsline.com ---------------------------------------------
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com