Thanks for the info however this is not what I trying to query. I should have been more detailed in my request, sorry.
the mask I'm referring to is the e164mask.
The following command shows what I am after but it does not show the MAC address of the phone that is using the e164mask.
run sql select dnorpattern, d.description, e164mask, tkpatternusage from devicenumplanmap inner join numplan on fknumplan=numplan.pkid join device d on fkdevice = d.pkid
