<font size="2"><font face="verdana,sans-serif">Yeah this didn't do what I wanted I haven't had the chance to investigate it yet though<br></font></font><div><div><font class="Apple-style-span" face="verdana, sans-serif"><br>
</font></div><div><font class="Apple-style-span" face="verdana, sans-serif">I get the same result as you</font></div><div><font class="Apple-style-span" face="verdana, sans-serif"><br></font></div><div><font class="Apple-style-span" face="verdana, sans-serif"><br>
</font><div class="gmail_quote">On Wed, Aug 24, 2011 at 11:25 PM, Schmitz, Daniel <span dir="ltr"><<a href="mailto:Daniel.Schmitz@solveos.de">Daniel.Schmitz@solveos.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div lang="DE" link="blue" vlink="purple"><div><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt">Hi does this command really work for you?<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt">Because I tried it but there are some Accounts that still have an End User assigned and show up in this list.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:9.0pt">Mit freundlichen Grüßen / Kind Regards<u></u><u></u></span></p><p class="MsoNormal">
<span style="font-size:9.0pt"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:9.0pt"><u></u> <u></u></span></p><p class="MsoNormal" style="line-height:12.0pt;text-autospace:none"><span style="font-size:9.0pt;color:black">Daniel Schmitz<u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:12.0pt;text-autospace:none"><span style="font-size:9.0pt;color:black">Senior IT-Specialist<u></u><u></u></span></p><p class="MsoNormal" style="line-height:12.0pt;text-autospace:none">
<span style="font-size:10.0pt;color:black"><img width="75" height="75" src="cid:image001.gif@01CC6272.18827B60" alt="Beschreibung: ccda_sm"><img width="75" height="75" src="cid:image002.gif@01CC6272.18827B60" alt="Beschreibung: cid:image002.gif@01CA72B9.77C69660"><img width="75" height="75" src="cid:image003.gif@01CC6272.18827B60" alt="Beschreibung: cid:image003.gif@01CA72B9.77C69660"> <img width="75" height="75" src="cid:image004.gif@01CC6272.18827B60" alt="Beschreibung: specialist_sm"><u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:12.0pt;text-autospace:none"><span lang="EN-US" style="font-size:9.0pt;color:black"><u></u> <u></u></span></p><div class="MsoNormal" align="center" style="text-align:center"><span style="font-size:9.0pt"><hr size="1" width="100%" noshade style="color:#ACA899" align="center">
</span></div><p class="MsoNormal" style="line-height:12.0pt;text-autospace:none"><b><span lang="EN-US" style="font-size:9.0pt">Solveos IT Solutions GmbH</span></b><span lang="EN-US" style="font-size:9.0pt"><br>Bernerstr. </span><span style="font-size:9.0pt">38<br>
60437 Frankfurt a. Main<br><br><span style="color:black">Telefon: <a href="tel:%2B49%2069%2095022%20327" value="+496995022327" target="_blank">+49 69 95022 327</a></span></span><span style="font-size:9.0pt;color:black"><u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:12.0pt;text-autospace:none"><span style="font-size:9.0pt;color:black">Telefax: <a href="tel:%2B49%2069%2095022%2077327" value="+49699502277327" target="_blank">+49 69 95022 77327</a><u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:12.0pt;text-autospace:none"><span lang="EN-US" style="font-size:9.0pt;color:black">Mobil: <a href="tel:%2B49%20172%205252383" value="+491725252383" target="_blank">+49 172 5252383</a><u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:12.0pt;text-autospace:none"><span lang="EN-US" style="font-size:9.0pt;color:black">Mail: <a href="http://daniel.schmitz@solveos.de" target="_blank">daniel.schmitz@solveos.de</a><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:9.0pt;color:black">Web: </span><span lang="EN-US" style="font-size:9.0pt;color:black"><a href="http://www.solveos.de/" target="_blank"><span lang="DE">http://www.solveos.de</span></a></span><span style="font-size:9.0pt"><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:7.5pt">AG Düsseldorf HRB 63231</span><span style="font-size:7.5pt"><br>USt-ID-Nr.: DE811548338<br>Geschäftsführer: Dirk Kiefer <u></u><u></u></span></p>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-size:7.5pt"><hr size="1" width="100%" noshade style="color:#ACA899" align="center"></span></div><p class="MsoNormal" align="center" style="text-align:center">
<span style="font-size:8.0pt"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:7.5pt">Der Inhalt dieser E-Mail ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte, dass jede Form der Kenntnisnahme, Veröffentlichung, Vervielfältigung oder Weitergabe des Inhalts dieser E-Mail unzulässig ist. Wir bitten Sie, sich in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen. Wir möchten Sie außerdem darauf hinweisen, dass die Kommunikation per E-Mail über das Internet unsicher ist, da für unberechtigte Dritte grundsätzlich die Möglichkeit der Kenntnisnahme und Manipulation besteht.<br>
<br></span><span lang="EN-US" style="font-size:7.5pt">The information contained in this e-mail is confidential. It is intended solely for the addressee. Access to this e-mail by anyone else is unauthorized. If you are not the intended recipient, any form of disclosure, reproduction, distribution or any action taken or refrained from in reliance on it, is prohibited and may be unlawful. Please notify the sender immediately. We also like to inform you that communication via e-mail over the internet is insecure because third parties may have the possibility to access and manipulate e-mails.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt">Von:</span></b><span style="font-size:10.0pt"> <a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a> [mailto:<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a>] <b>Im Auftrag von </b>Abebe Amare<br>
<b>Gesendet:</b> Donnerstag, 4. August 2011 13:59<br><b>An:</b> Aaron Daniels - Lists<br><b>Cc:</b> <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br><b>Betreff:</b> Re: [cisco-voip] Unused User Device Profiles<u></u><u></u></span></p>
<div><div></div><div class="h5"><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal" style="margin-bottom:12.0pt">Thanks a lot Aaron. I was also looking for this<br><br>Thanks<br><br>Abebe<u></u><u></u></p><div><p class="MsoNormal">
On Tue, Aug 2, 2011 at 11:58 AM, Aaron Daniels - Lists <<a href="mailto:lists@daniels.id.au" target="_blank">lists@daniels.id.au</a>> wrote:<u></u><u></u></p><div><div><p class="MsoNormal"><span lang="EN-AU" style="font-size:11.0pt;color:#1F497D">Hi Daniel,</span><span lang="EN-AU"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-AU" style="font-size:11.0pt;color:#1F497D">Its a bit last week, but if you havnt already received an answer....</span><span lang="EN-AU"><u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-AU" style="font-size:11.0pt;color:#1F497D"> </span><span lang="EN-AU"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-AU" style="font-size:11.0pt;color:#1F497D">UDP with no end users</span><span lang="EN-AU"><u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-AU" style="font-size:11.0pt;color:#1F497D"> SELECT name from device where tkdeviceprofile=1 and fkenduser is NULL</span><span lang="EN-AU"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-AU" style="font-size:11.0pt;color:#1F497D"> </span><span lang="EN-AU"><u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-AU" style="font-size:11.0pt;color:#1F497D">After deleting the UDP you will have stray DN’s lying around, to get rid of them:</span><span lang="EN-AU"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-AU" style="font-size:11.0pt;color:#1F497D">Lines with no device</span><span lang="EN-AU"><u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-AU" style="font-size:11.0pt;color:#1F497D"> SELECT NP.dnorpattern FROM numplan as NP LEFT JOIN devicenumplanmap as DM ON NP.pkid = DM.fknumplan WHERE DM.fknumplan is NULL and NP.tkpatternusage=2</span><span lang="EN-AU"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-AU" style="font-size:11.0pt;color:#1F497D"> </span><span lang="EN-AU"><u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-AU" style="font-size:11.0pt;color:#1F497D">Thanks,</span><span lang="EN-AU"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-AU" style="font-size:11.0pt;color:#1F497D">Aaron</span><span lang="EN-AU"><u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-AU" style="font-size:11.0pt;color:#1F497D"> </span><span lang="EN-AU"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-AU" style="font-size:11.0pt;color:#1F497D"> </span><span lang="EN-AU"><u></u><u></u></span></p><div style="border:none;border-left:solid windowtext 1.5pt;padding:0cm 0cm 0cm 4.0pt;border-color:-moz-use-text-color -moz-use-text-color -moz-use-text-color blue">
<div><div style="border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0cm 0cm 0cm;border-color:-moz-use-text-color -moz-use-text-color"><p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt">From:</span></b><span lang="EN-US" style="font-size:10.0pt"> Daniel [mailto:<a href="mailto:dan.voip@danofive.id.au" target="_blank">dan.voip@danofive.id.au</a>] <br>
<b>Sent:</b> Thursday, 21 July 2011 3:53 PM<br><b>To:</b> <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br><b>Subject:</b> [cisco-voip] Unused User Device Profiles</span><span lang="EN-AU"><u></u><u></u></span></p>
</div></div><div><div><p class="MsoNormal"><span lang="EN-AU"> <u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-AU" style="font-size:10.0pt">Hi All,</span><span lang="EN-AU"><u></u><u></u></span></p><div><p class="MsoNormal">
<span lang="EN-AU"> <u></u><u></u></span></p></div><div><p class="MsoNormal"><span lang="EN-AU" style="font-size:10.0pt">In regards to extension mobility, does anyone know of a way to get a report of unused User Device Profiles? Any User Device Profile not assigned to a user?</span><span lang="EN-AU"><u></u><u></u></span></p>
</div><div><p class="MsoNormal"><span lang="EN-AU"> <u></u><u></u></span></p></div><div><p class="MsoNormal"><span lang="EN-AU" style="font-size:10.0pt">thanks,</span><span lang="EN-AU"><u></u><u></u></span></p></div><div>
<p class="MsoNormal"><span lang="EN-AU"> <u></u><u></u></span></p></div><div><p class="MsoNormal"><span lang="EN-AU" style="font-size:10.0pt">Dan</span><span lang="EN-AU"><u></u><u></u></span></p></div><div><p class="MsoNormal">
<span lang="EN-AU"> <u></u><u></u></span></p></div></div></div></div></div></div><p class="MsoNormal" style="margin-bottom:12.0pt"><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" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><u></u><u></u></p></div><p class="MsoNormal"><u></u> <u></u></p></div></div></div></div>
<br>_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br></blockquote></div><br></div></div>