Export phones, profiles, etc. dependencies from application users in CUCM v8

[vivian.le]

I have an application user where a large number of phones and profiles are associated to it. I need to be able to export this list of associated devices so that it can be recreated on another server and verified.  In CUCM 6, the list could be pulled from the dependency records but it's no longer available as far as I can see in CUCM 8.  Does anyone know of another way to list this information?                

[William Bell · Accepted solution]

Vivian,

This query (executed from the CLI) would do it.

admin:run sql select au.name,d.name as devicename from applicationuser au inner join applicationuserdevicemap admap on admap.fkapplicationuser=au.pkid inner join device d on admap.fkdevice=d.pkid order by au.name,d.name

name        devicename

=========== ================

wbell-admin CSFWJBELL

wbell-admin Testprofile

wbell-admin SEPDEADBEEF0001

HTH.

-Bill (http://ucguerrila.com)

[vivian.le]

Thanks for responding Bill.  Unfortunately, I don't have access to the OS admin account.  Is there any other way via the CM Administration page?

[William Bell · Accepted solution]

I suppose you could export the application users using BAT:

Bulk Administration > Import/Export > Export

Specify a file name.

Under "User Data", you should see an "Application User" option. Select that and execute the export.

If it is like the End User export, you should see the device/profile associations in the csv file that is packaged in the tar archive. I believe version 8 should have the Application User option. I just checked on my CUCM 9.1 system.

HTH.

-Bill (http://ucguerrilla.com)

[vivian.le]

Thanks Bill!  I was looking user export in BAT which only exports end users.  I was looking in the wrong place.  Thanks for pointing me in the right direction!