can we search phone/DN by "external phone number mask"?

[Oak Ridge]

Somebody wrongly configured the same number as  "external phone number mask" in multiple phones.  We don't want to lookup them by viewing each of the DN. What is the best way to search phone/DN by "external phone number mask"?

[Chris Deren]

You can run SQL query such as:

select * from devicenumplanmap where e164mask='XXXXXXXXXX'

where XXXXXXXXX is the mask

Chiris

[William Bell · Accepted solution]

As Chris noted, the devicenumplanmap table stores the value for the e164mask. If you want to see a list of DNs alongside the mask then you may want to use a more robust query, such as:

select d.name,n.dnorpattern, dmap.numplanindex, dmap.e164mask
from device d
inner join devicenumplanmap dmap on dmap.fkdevice = d.pkid
inner join numplan n on dmap.fknumplan=n.pkid
where dmap.e164mask=''
order by d.name, dmap.numplanindex

The above query will give you a list of devices and then show DNs assigned to those devices. The dmap.numplanindex field corresponds to button position on the phone station.

HTH.

-Bill (@ucguerrilla)

[Chris Deren]

+5 Bill for providing proper query, I got lazy :-)

Chris