<div dir="ltr">Actually this query will get you both number and the user/callhandler it's on:<div><br><div><div>run cuc dbquery unitydirdb select num.transfernumber, handler.displayname from tbl_alternatecontactnumber as num left join tbl_menuentry as menu on num.menuentryobjectid = menu.objectid left join tbl_handler as handler on menu.callhandlerobjectid = handler.objectid where num.transfernumber like '9%'</div><div><br></div><div><br></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Aug 19, 2015 at 4:19 PM, Brian Meade <span dir="ltr"><<a href="mailto:bmeade90@vt.edu" target="_blank">bmeade90@vt.edu</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">Sounds like alternate number to me.<div><br></div><div>If they haven't deleted it, try running this from the Unity Connection publisher:</div><div><div>run cuc dbquery unitydirdb select * from tbl_alternatecontactnumber where transfernumber like '9%'</div></div><div><br></div><div><br></div><div>That will show all alternate contact numbers beginning with 9 and then we can figure out the user or call handler it's configured on from there.</div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Aug 19, 2015 at 3:52 PM, <span dir="ltr"><<a href="mailto:norm.nicholson@kitchener.ca" target="_blank">norm.nicholson@kitchener.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<div style="width:100%;font-size:initial;font-family:Calibri,'Slate Pro',sans-serif,sans-serif;color:rgb(31,73,125);text-align:initial;background-color:rgb(255,255,255)">
All to the same number in St Kitts. </div>
<div style="width:100%;font-size:initial;font-family:Calibri,'Slate Pro',sans-serif,sans-serif;color:rgb(31,73,125);text-align:initial;background-color:rgb(255,255,255)">
<br>
</div>
<div style="width:100%;font-size:initial;font-family:Calibri,'Slate Pro',sans-serif,sans-serif;color:rgb(31,73,125);text-align:initial;background-color:rgb(255,255,255)">
<br>
</div>
<div style="width:100%;font-size:initial;font-family:Calibri,'Slate Pro',sans-serif,sans-serif;color:rgb(31,73,125);text-align:initial;background-color:rgb(255,255,255)">
<br style="display:initial">
</div>
<div style="font-size:initial;font-family:Calibri,'Slate Pro',sans-serif,sans-serif;color:rgb(31,73,125);text-align:initial;background-color:rgb(255,255,255)"><span>
Norm Nicholson<br>
Telecom Analyst <br>
City of Kitchener <br>
</span><a href="tel:%28519%29741.2200%C2%A0x7000" value="+15197412200" target="_blank">(519)741.2200 x7000</a><br>
</div>
<table width="100%" style="background-color:white;border-spacing:0px">
<tbody>
<tr>
<td colspan="2" style="font-size:initial;text-align:initial;background-color:rgb(255,255,255)">
<div style="border-style:solid none none;border-top-color:rgb(181,196,223);border-top-width:1pt;padding:3pt 0in 0in;font-family:Tahoma,'BB Alpha Sans','Slate Pro';font-size:10pt">
<div><b>From: </b>Brian Meade</div>
<div><b>Sent: </b>Wednesday, August 19, 2015 3:47 PM</div>
<div><b>To: </b>Norm Nicholson</div>
<div><b>Cc: </b><a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a></div>
<div><b>Subject: </b>Re: [cisco-voip] Unity 10.5 hacking issue</div>
</div>
</td>
</tr>
</tbody>
</table><div><div>
<div style="border-style:solid none none;border-top-color:rgb(186,188,209);border-top-width:1pt;font-size:initial;text-align:initial;background-color:rgb(255,255,255)">
</div>
<br>
<div>
<div dir="ltr">Was it all the same destination number or different numbers? Manually added alternate contacts bypass the restriction tables I believe.</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Wed, Aug 19, 2015 at 3:37 PM, <span dir="ltr"><<a href="mailto:norm.nicholson@kitchener.ca" target="_blank">norm.nicholson@kitchener.ca</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US">
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I had an issue with someone getting into Unity and calling long distance one evening. The restrict tables were correct but I found the ports on voicemail had the LD calling search space and removed it, and the LD stopped. Any idea how they
can dial 9 , is it from the main call processor or is it in call handlers. <u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Any help would be appreciated.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Thanks<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><b><span style="color:#00b050">Norm Nicholson<u></u><u></u></span></b></p>
<p class="MsoNormal"><b><span style="color:#00b050">Telecom Analyst<u></u><u></u></span></b></p>
<p class="MsoNormal"><b><span style="color:#00b050">City of Kitchener<u></u><u></u></span></b></p>
<p class="MsoNormal"><b><span style="color:#00b050"><a href="tel:%28519%29%20741-2200%20x%207000" value="+15197412200" target="_blank">(519) 741-2200 x 7000</a><u></u><u></u></span></b></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
<br>
_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div></div></div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>