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 U
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
Hi Rana,
try this out:
http://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
> Hi Everyone
>
> I am using RT 3.8.1 on Fedora 10.
>
> I need one query from you, i want to get watch
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
+9232241