How can I search and find Extension Mobility and Jabber devices...

[kbeaton]

How can I search and find Extension Mobility and Jabber devices with no user assigned?

I need to find Extension Mobility and Jabber devices for which the Active Directory users have been disabled.

I need to do this to manage unused devices in Call Manager

TIA

[Maren Mahoney · Accepted solution]

AFAIK there is no simple query/report native to CUCM that does this. Automation tools such as Akadian and Second Nature do this, but not CUCM. But all is not lost...

Jabber will be easier. Use the Bulk Administration Tool to do a Phone Report (BAT > Phones > Generate Phone Reports), using as your search "Phones that begin with CSF" (or whatever your naming convention is) and then select as one of the fields the "Owner ID".  The limiter for that one is the BAT searches are limited to 1000 results, so if you have more you'd have to do it in batches.

 If you have so many that this method would not work, I'd suggest doing a BAT Export of all phones. (BAT > Import/Export> Export and select "Phones") From there you would use Excel Magic to sort by Device Type with a secondary sort by Owner. All of the Jabber devices that do not have an owner would be together.

Extension Mobility is harder as the profile itself does not have an owner field. The thing I'm coming up with is that you could do another BAT export, this time exporting Device Profiles and also End Users. Then use Excel Magic (like VLOOKUP) to find the Device Profile names that do not appear in the End Users list of Controlled Profiles.

There is probably a simple SQL query for the Jabber devices where the Owner ID field is blank. (Don't look at me for that though....lol) And one could probably be constructed for the Device Profiles as well, but that one would be a lot more complicated.

Let us know if you have questions.

Maren

[kbeaton]

Hi Maren,

Thanks for the ideas!

The Jabber one is pretty easy, the EM one I'm sure I can figure out, I'll just have to spend some time...

Thanks!

[Roger Kallberg]

This article might be of help for this. Finding Orphaned User Device Profiles for EM 

[Maren Mahoney]

That is a fabulous find, @Roger Kallberg ! Bill Bell is amazing and I learned a lot from the UC Guerilla website over the years. I should have known he'd have a solution for this!

Maren

[kbeaton]

One more question, do either Akadian or Second Nature report on UCCX by chance?

[Maren Mahoney · Accepted solution]

Akkadian Lab does for sure. Second Nature (Unimax is the company) may, but you'd have to ask them to be sure. I've used both and both are amazing tools for automation in medium and large environments.

Maren