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