[rt-users] Query to get watchers of Qs.

[Rana Tanveer]

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 <ranatanveer at 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.brumm at 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 <ranatanveer at 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: sales at 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
---------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090213/2a50add1/attachment.htm>