export device profiles incl. MAC address from CUCM 8.6.2

[cristinapetre]

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

[Aaron Harrison · Accepted solution]

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

[cristinapetre]

thanks Aaron ;-)

[Aaron Harrison]

You're welcome!

[thorstenn]

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

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