Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

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

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?                

2 ACCEPTED SOLUTIONS

Accepted Solutions

Export phones, profiles, etc. dependencies from application user

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)

HTH -Bill (b) http://ucguerrilla.com (t) @ucguerrilla

Please remember to rate helpful responses and identify

Export phones, profiles, etc. dependencies from application user

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)

HTH -Bill (b) http://ucguerrilla.com (t) @ucguerrilla

Please remember to rate helpful responses and identify

4 REPLIES

Export phones, profiles, etc. dependencies from application user

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)

HTH -Bill (b) http://ucguerrilla.com (t) @ucguerrilla

Please remember to rate helpful responses and identify

New Member

Export phones, profiles, etc. dependencies from application user

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?

Export phones, profiles, etc. dependencies from application user

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)

HTH -Bill (b) http://ucguerrilla.com (t) @ucguerrilla

Please remember to rate helpful responses and identify

New Member

Export phones, profiles, etc. dependencies from application user

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!

87
Views
0
Helpful
4
Replies
CreatePlease to create content