[cisco-voip] Unused User Device Profiles

[Aaron Daniels - Lists]

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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110802/d896b057/attachment.html>