<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta name=Generator content="Microsoft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Sprechblasentext Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.E-MailFormatvorlage17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.SprechblasentextZchn
{mso-style-name:"Sprechblasentext Zchn";
mso-style-priority:99;
mso-style-link:Sprechblasentext;
font-family:"Tahoma","sans-serif";
mso-fareast-language:DE;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=DE link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Hi does this command really work for you?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Because I tried it but there are some Accounts that still have an End User assigned and show up in this list.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Mit freundlichen Grüßen / Kind Regards<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal style='line-height:12.0pt;text-autospace:none'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'>Daniel Schmitz<o:p></o:p></span></p><p class=MsoNormal style='line-height:12.0pt;text-autospace:none'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'>Senior IT-Specialist<o:p></o:p></span></p><p class=MsoNormal style='line-height:12.0pt;text-autospace:none'><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'><img width=75 height=75 id="Bild_x0020_1" src="cid:image001.gif@01CC6272.18827B60" alt="Beschreibung: ccda_sm"><img width=75 height=75 id="Bild_x0020_2" src="cid:image002.gif@01CC6272.18827B60" alt="Beschreibung: cid:image002.gif@01CA72B9.77C69660"><img width=75 height=75 id="Bild_x0020_3" src="cid:image003.gif@01CC6272.18827B60" alt="Beschreibung: cid:image003.gif@01CA72B9.77C69660"> <img width=75 height=75 id="Bild_x0020_4" src="cid:image004.gif@01CC6272.18827B60" alt="Beschreibung: specialist_sm"><o:p></o:p></span></p><p class=MsoNormal style='line-height:12.0pt;text-autospace:none'><span lang=EN-US style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p><div class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'><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;font-family:"Verdana","sans-serif"'>Solveos IT Solutions GmbH</span></b><span lang=EN-US style='font-size:9.0pt;font-family:"Verdana","sans-serif"'><br>Bernerstr. </span><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>38<br>60437 Frankfurt a. Main<br><br><span style='color:black'>Telefon: +49 69 95022 327</span></span><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><o:p></o:p></span></p><p class=MsoNormal style='line-height:12.0pt;text-autospace:none'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'>Telefax: +49 69 95022 77327<o:p></o:p></span></p><p class=MsoNormal style='line-height:12.0pt;text-autospace:none'><span lang=EN-US style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'>Mobil: +49 172 5252383<o:p></o:p></span></p><p class=MsoNormal style='line-height:12.0pt;text-autospace:none'><span lang=EN-US style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'>Mail: <a href="daniel.schmitz@solveos.de">daniel.schmitz@solveos.de</a><o:p></o:p></span></p><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'>Web: </span><span lang=EN-US style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><a href="http://www.solveos.de/"><span lang=DE>http://www.solveos.de</span></a></span><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:7.5pt;font-family:"Verdana","sans-serif"'>AG Düsseldorf HRB 63231</span><span style='font-size:7.5pt;font-family:"Verdana","sans-serif"'><br>USt-ID-Nr.: DE811548338<br>Geschäftsführer: Dirk Kiefer <o:p></o:p></span></p><div class=MsoNormal align=center style='text-align:center'><span style='font-size:7.5pt;font-family:"Verdana","sans-serif"'><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;font-family:"Verdana","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:7.5pt;font-family:"Verdana","sans-serif"'>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;font-family:"Verdana","sans-serif"'>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.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Von:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-bounces@puck.nether.net] <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> cisco-voip@puck.nether.net<br><b>Betreff:</b> Re: [cisco-voip] Unused User Device Profiles<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></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<o:p></o:p></p><div><p class=MsoNormal>On Tue, Aug 2, 2011 at 11:58 AM, Aaron Daniels - Lists <<a href="mailto:lists@daniels.id.au">lists@daniels.id.au</a>> wrote:<o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-AU style='font-size:11.0pt;color:#1F497D'>Hi Daniel,</span><span lang=EN-AU><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-AU style='font-size:11.0pt;color:#1F497D'> </span><span lang=EN-AU><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-AU style='font-size:11.0pt;color:#1F497D'>UDP with no end users</span><span lang=EN-AU><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-AU style='font-size:11.0pt;color:#1F497D'> </span><span lang=EN-AU><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-AU style='font-size:11.0pt;color:#1F497D'>Lines with no device</span><span lang=EN-AU><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-AU style='font-size:11.0pt;color:#1F497D'> </span><span lang=EN-AU><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-AU style='font-size:11.0pt;color:#1F497D'>Thanks,</span><span lang=EN-AU><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-AU style='font-size:11.0pt;color:#1F497D'>Aaron</span><span lang=EN-AU><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-AU style='font-size:11.0pt;color:#1F497D'> </span><span lang=EN-AU><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-AU style='font-size:11.0pt;color:#1F497D'> </span><span lang=EN-AU><o:p></o:p></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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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><o:p></o:p></span></p></div></div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-AU> <o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-AU style='font-size:10.0pt'>Hi All,</span><span lang=EN-AU><o:p></o:p></span></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-AU> <o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-AU> <o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-AU style='font-size:10.0pt'>thanks,</span><span lang=EN-AU><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-AU> <o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-AU style='font-size:10.0pt'>Dan</span><span lang=EN-AU><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-AU> <o:p></o:p></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">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><o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p></div></body></html>