[cisco-voip] Unused User Device Profiles

[Abebe Amare]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110804/d9645fc1/attachment.html>