Rob is correct (+5 big R.) the best way to get this data out of CUCM is to use BAT. If you are trying to move from one CUCM to another then version differences may come into play. If you were moving between CUCM clusters that are the same version, you could use bulk export "All Details" for a phone but you have to make sure certain things are provisioned on the target CUCM before you import (e.g. users, softkey template names, phone button template names, partitions, etc.).
You can also export specific fields from the source CUCM and import into a target CUCM. Again, you will have to do some prep work on the target OR normalize the exported data file to conform to the target CUCM config. It is always a three step process (at a minimum).
When you have different CUCM versions, the "All Details" export typically adds the challenge of field alignment due to feature differences. It is pretty easy to find these by exporting "All Details" from both CUCM clusters. Then open both in Excel. From here you can compare headers (I like to select the header row, copy, and paste [transposed] in another sheet. It is easier to do a side by side comparison).
If you just want the MAC addresses and that is all you care about, then you can run this query from the console:
admin: run sql select tm.name as model, d.name, d.description from device as d inner join typemodel as tm on d.tkmodel = tm.enum where d.name like 'SEP%' order by tm.name
HTH.
Regards,
Bill
http://ucguerrilla.com
