[cisco-voip] Unused User Device Profiles

[Daniel]

Yeah this didn't do what I wanted I haven't had the chance to investigate it
yet though

I get the same result as you


On Wed, Aug 24, 2011 at 11:25 PM, Schmitz, Daniel <Daniel.Schmitz at solveos.de
> wrote:

> Hi does this command really work for you?****
>
> Because I tried it but there are some Accounts that still have an End User
> assigned and show up in this list.****
>
> ** **
>
> Mit freundlichen Grüßen / Kind Regards****
>
> ** **
>
> ** **
>
> Daniel Schmitz****
>
> Senior IT-Specialist****
>
> [image: Beschreibung: ccda_sm][image: Beschreibung:
> cid:image002.gif at 01CA72B9.77C69660][image: Beschreibung:
> cid:image003.gif at 01CA72B9.77C69660] [image: Beschreibung: specialist_sm]**
> **
>
> ** **
> ------------------------------
>
> *Solveos IT Solutions GmbH*
> Bernerstr. 38
> 60437 Frankfurt a. Main
>
> Telefon: +49 69 95022 327****
>
> Telefax: +49 69 95022 77327****
>
> Mobil: +49 172 5252383****
>
> Mail: daniel.schmitz at solveos.de****
>
> Web: http://www.solveos.de****
>
> AG Düsseldorf HRB 63231
> USt-ID-Nr.: DE811548338
> Geschäftsführer: Dirk Kiefer ****
> ------------------------------
>
> ** **
>
> 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.
>
> 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.****
>
> ** **
>
> ** **
>
> ** **
>
> *Von:* cisco-voip-bounces at puck.nether.net [mailto:
> cisco-voip-bounces at puck.nether.net] *Im Auftrag von *Abebe Amare
> *Gesendet:* Donnerstag, 4. August 2011 13:59
> *An:* Aaron Daniels - Lists
> *Cc:* cisco-voip at puck.nether.net
> *Betreff:* Re: [cisco-voip] Unused User Device Profiles****
>
> ** **
>
> Thanks a lot Aaron. I was also looking for this
>
> Thanks
>
> Abebe****
>
> On Tue, Aug 2, 2011 at 11:58 AM, Aaron Daniels - Lists <
> lists at daniels.id.au> wrote:****
>
> Hi Daniel,****
>
> Its a bit last week, but if you havnt already received an answer....****
>
>  ****
>
> UDP with no end users****
>
>           SELECT name from device where tkdeviceprofile=1 and fkenduser is
> NULL****
>
>  ****
>
> After deleting the UDP you will have stray DN’s lying around, to get rid of
> them:****
>
> Lines with no device****
>
>           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****
>
>  ****
>
> Thanks,****
>
> Aaron****
>
>  ****
>
>  ****
>
> *From:* Daniel [mailto:dan.voip at danofive.id.au]
> *Sent:* Thursday, 21 July 2011 3:53 PM
> *To:* cisco-voip at puck.nether.net
> *Subject:* [cisco-voip] Unused User Device Profiles****
>
>  ****
>
> Hi All,****
>
>  ****
>
> 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?****
>
>  ****
>
> thanks,****
>
>  ****
>
> Dan****
>
>  ****
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip****
>
> ** **
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110901/d34d7ed5/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.gif
Type: image/gif
Size: 3241 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110901/d34d7ed5/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.gif
Type: image/gif
Size: 3313 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110901/d34d7ed5/attachment-0001.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.gif
Type: image/gif
Size: 3934 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110901/d34d7ed5/attachment-0002.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 3321 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110901/d34d7ed5/attachment-0003.gif>