cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
951
Views
0
Helpful
4
Replies
Highlighted
Beginner

export device profiles incl. MAC address from CUCM 8.6.2

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
Highlighted

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
Highlighted

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

Highlighted

thanks Aaron ;-)

Highlighted

You're welcome!

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

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

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