Extract DN and corresponding MAC info from CM database

[m.balastik]

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.

[beth-martin]

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

[m.balastik]

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