<div dir="ltr">Hi Jan,<div><br></div><div>Why not use sqlops to query the database from within your config script?</div><div><br></div><div>Best regards,</div><div><br></div><div>Charles</div><div><br></div><div class="gmail_extra">
<br><br><div class="gmail_quote">On 21 August 2013 13:36, Jan Gaida <span dir="ltr"><<a href="mailto:jan.gaida@grupoamper.com" target="_blank">jan.gaida@grupoamper.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Hello,<div><br></div><div>I need to obtain the number of subscribed watchers for a given presentity-uri. </div><div><br></div><div>I can get it with a SQL Query like "select count(*) from kamailio.active_watchers where presentity_uri = 'test@domain';". But I think there should be a way to get it from within the configuration script.</div>
<div><br></div><div>Regards</div><div><div><br></div>-- <br><div dir="ltr">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td bgcolor="#004054" colspan="2" height="8px" width="570">
<img alt="" border="0" height="8" width="1"></td>
</tr>
<tr valign="top">
<td bgcolor="#FFFFFF" width="380">
<font color="#004054" face="Arial"><b>Jan </b></font><b><font color="#004054" face="Arial">Gaida</font></b><br>
<font color="#99cc33" face="Arial" size="1">Ingeniero Desarrollo Software</font></td>
<td>
<img style="float:right"></td>
</tr>
<tr>
<td colspan="2">
<img alt="" border="0" height="5" width="1"></td>
</tr>
<tr valign="top">
<td valign="bottom" width="380"><span style="font-size:x-small;font-family:Arial">C/ Marconi 3 (PTM)</span><br><font color="#000000" face="Arial" size="1">28760 Tres Cantos<br>Spain</font><br>
<font color="#8f8f8f" face="Arial" size="1"><a href="mailto:jan.gaida@grupoamper.com" target="_blank">jan.gaida@grupoamper.com</a> | </font><a href="http://www.grupoamper.com" target="_blank"><font color="#8f8f8f" face="Arial" size="1">www.grupoamper.com</font></a></td>
<td valign="bottom">
<img style="float:right"></td>
</tr>
</tbody>
</table>
<br></div>
</div></div>
<br>
<div><br></div><div><p><font color="#5f497a" size="1" face="Times New Roman">This message and any attachments are intended only for the use of the individual to whom they are addressed and it may contain information that is privileged or confidential. If you have received this communication by mistake, please notify us immediately by e-mail or telephone.The storage, recording, use or disclosure of this e-mail and its attachments by anyone other than the intended recipient is strictly prohibited. This message has been verified using antivirus software; however, the sender is not responsible for any damage to hardware or software resulting from the presence of any virus.</font></p>
<p><font color="#5f497a" size="1" face="Times New Roman"><br></font></p><p><font color="#5f497a" size="1" face="Times New Roman">Este mensaje y cualquier anexo son exclusivamente para la persona a quien van dirigidos y pueden contener información privilegiada o confidencial. Si usted ha recibido esta comunicación por error, le agradecemos notificarlo de inmediato por esta misma vía o por teléfono. Está prohibida su retención, grabación, utilización o divulgación con cualquier propósito. Este mensaje ha sido verificado con software antivirus; sin embargo, el remitente no se hace responsable en caso de que en éste o en los archivos adjuntos haya presencia de algún virus que pueda generar daños en los equipos o programas del destinatario.</font></p>
</div><br>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br><br>
</div></div>
<br>
<font face="Helvetica, Arial, sans-serif"><font size="2"><span style="font-size:10pt"><a href="http://www.sipcentric.com/" title="blocked::http://www.sipcentric.com/" target="_blank">www.sipcentric.com</a><br>
<br>
Follow us on twitter <a href="http://twitter.com/sipcentric" title="blocked::http://twitter.com/sipcentric" target="_blank">@sipcentric</a><br>
<br>
<font color="gray">Sipcentric Ltd.
Company registered in England & Wales no. 7365592.</font> <font color="gray">Registered
office: Unit 10 iBIC, Birmingham Science Park, Holt Court South, Birmingham B7 4EJ.</font></span></font></font>