List Devices outside of Home Location

Ever wondered how many of your telephony devices are located outside of their home location (as configured on the device when using the Device Mobility feature)?

Here’s how: log on to the CUCM CLI and run the following query:

run sql select d.name, d.description, dp.name from devicemobilitydynamic dmd, device d, devicepool dp where dmd.fkdevice = d.pkid and dmd.fkdevicepool_devicemobility = dp.pkid

This will produce output like:

name            description           name
=============== ===================== =====
SEP0016466166B8 Phone 77640           HQ
SEP001E156CF34B Phone 79117           HQ
SEP001149604BFA Phone 77666           HQ
SEP0015FFFF5B38 Phone 77685           HQ

What this means is that the given devices are put in the HQ Device Pool (according to the Device Mobility setup) while they have another Device Pool configured. To remedy this solution, you should reconfigure those devices so they belong to the HQ Device Pool. You’ll probably need to change the Location and Device Calling Search Space settings as well.

This has been tested with CUCM 6.