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

Extract DN and corresponding MAC info from CM database

I would like to extract DN and corresponding MAC information from the SQL database on the CM. Looking at the database I see that the information is split between two tables but I don't know which field to use which is the same in both tables so that I can create the query. (Perhaps there is a third table required?) I need to update approx 700 phones with a new voicemail profile and the update phones function in BAT does not have a way to do this. I need to remove all of these phones and then reload them using the add phones function in BAT.

2 REPLIES
Bronze

Re: Extract DN and corresponding MAC info from CM database

Here is a query you can run on the SQL server. Run this at your own risk but it should give you the dn and mac addresses you are looking for.

Run on the pub's database:

select device.name,

numplan.dnorpattern,

devicenumplanmap.display,

device.description

from device,

devicenumplanmap,

numplan

where devicenumplanmap.fknumplan=numplan.pkid and

devicenumplanmap.fkdevice=device.pkid and

devicenumplanmap.numplanindex=1 and

device.tkclass=1

order by

numplan.dnorpattern

New Member

Re: Extract DN and corresponding MAC info from CM database

Thanks for the info. I did figure out the query last week which is very similar to the one you posted and it gave me the data I was looking for.

Thanks

Monica

108
Views
5
Helpful
2
Replies
CreatePlease login to create content