cancel
Showing results for 
Search instead for 
Did you mean: 
cancel

export device profiles incl. MAC address from CUCM 8.6.2

cristinapetre
Beginner
Beginner

Hi all,

is there a possibility to export all device profiles including the MAC address which you can reach through the dependency records? The scope is to get the MAC address which is related to the device profile at the moment.

I didnt find anything therefore the question.

Many thanks in advance.

cu, cristina

1 ACCEPTED SOLUTION

Accepted Solutions

Hi Cristina

You can run this from the server CLI - log the SSH session to text, then you can import to Excel!

run sql select e.userid,d.name,dp.name from extensionmobilitydynamic emd join device d  on d.pkid = emd.fkdevice join device dp on dp.pkid = emd.fkdevice_currentloginprofile join enduser e on e.pkid = emd.fkenduser

Regards

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!

View solution in original post

4 REPLIES 4

Hi Cristina

You can run this from the server CLI - log the SSH session to text, then you can import to Excel!

run sql select e.userid,d.name,dp.name from extensionmobilitydynamic emd join device d  on d.pkid = emd.fkdevice join device dp on dp.pkid = emd.fkdevice_currentloginprofile join enduser e on e.pkid = emd.fkenduser

Regards

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!

thanks Aaron ;-)

You're welcome!

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!

aarono do yo also know the command for cucm 11.5 ? Its not working...

The specified table (device) is not in the database.
admin:
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: