Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Users might experience few discrepancies in Search results. We are working on this on our side. We apologize for the inconvenience it may have caused.
New Member

Help exporting all MACs and DIDs w/ external phone number mask

I'd really like a list of more settings, but I currently just need the External Phone Number Mask value for every line. The export function seems to be used for importing purposes (tried to manipulate template to no avail) and the reporting feature is just by phone, not DID.

Is there an easy way to do this? Seems like it would be a simple query if I knew the database structure.

Any help would be appreciated.

2 REPLIES

Re: Help exporting all MACs and DIDs w/ external phone number ma

The MAC number isn't saved.. but since the device name is SEP+MAC, it's easy to be separated. You'll have devices in the device table, lines in the numplan table, and the whole thing is linked together via numplanmap table.

And Cisco offers the whole DB schema for download: http://www.cisco.com/application/pdf/en/us/guest/products/ps6164/c1671/ccmigration_09186a0080705df6.pdf

Anonymous
N/A

Re: Help exporting all MACs and DIDs w/ external phone number ma

Saved my life, thanks!

SELECT name,device.description,dnorpattern,e164mask

FROM (

numplan

inner

join devicenumplanmap

on numplan.pkid

= devicenumplanmap.fknumplan

)

inner

join device

on devicenumplanmap.fkdevice

= device.pkid

187
Views
5
Helpful
2
Replies
CreatePlease to create content