Query to get watchers of Qs

RT Users
1

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

2

Hi Rana,

try this out:

I think it is what you are looking for.

Torsten2009/2/8 Rana Tanveer ranatanveer@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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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

3

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 TanveerOn Mon, Feb 9, 2009 at 5:00 PM, Torsten Brumm torsten.brumm@googlemail.comwrote:

Hi Rana,

try this out:
RT::Extension::WatchedQueues - List queues the user is a watcher of - metacpan.orghttp://search.cpan.org/~elacour/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@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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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

4

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@gmail.comwrote:

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.
GetWatcherInfoByTicket - Request Tracker Wiki

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@googlemail.com> wrote:

Hi Rana,

try this out:
RT::Extension::WatchedQueues - List queues the user is a watcher of - metacpan.orghttp://search.cpan.org/~elacour/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@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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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