<h3 class="EP8xU" 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">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><br>Rana Tanveer<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">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 class="Wj3C7c">
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>