[cisco-voip] Unused User Device Profiles

Schmitz, Daniel Daniel.Schmitz at solveos.de
Wed Aug 24 09:25:46 EDT 2011


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
[cid:image001.gif at 01CC6272.18827B60][cid:image002.gif at 01CC6272.18827B60][cid:image003.gif at 01CC6272.18827B60] [cid:image004.gif at 01CC6272.18827B60]

________________________________
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<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<mailto: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<mailto:dan.voip at danofive.id.au>]
Sent: Thursday, 21 July 2011 3:53 PM
To: cisco-voip at puck.nether.net<mailto: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<mailto: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/20110824/0deb100d/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 3321 bytes
Desc: image001.gif
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110824/0deb100d/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.gif
Type: image/gif
Size: 3313 bytes
Desc: image002.gif
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110824/0deb100d/attachment-0001.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.gif
Type: image/gif
Size: 3934 bytes
Desc: image003.gif
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110824/0deb100d/attachment-0002.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.gif
Type: image/gif
Size: 3241 bytes
Desc: image004.gif
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110824/0deb100d/attachment-0003.gif>


More information about the cisco-voip mailing list