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

[Rana Tanveer]

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