Option 1. You can use the following query:

admin:run sql select d.name as devicename,dmap.numplanindex,n.dnorpattern,dmap.e164mask from device as d inner join devicenumplanmap as dmap on dmap.fkdevice=d.pkid inner join numplan as n on dmap.fknumplan=n.pkid order by d.name,dmap.numplanindex

The above will give you every device. If you want just phones:

admin:run sql select d.name as devicename,dmap.numplanindex,n.dnorpattern,dmap.e164mask from device as d inner join devicenumplanmap as dmap on dmap.fkdevice=d.pkid inner join numplan as n on dmap.fknumplan=n.pkid where d.name like 'SEP%' order by d.name,dmap.numplanindex

Option 2. With BAT, you could use the following procedure:

1. Create a new file format (Bulk Administration>Phones>Phone File Format>Create File Format

2. Config as follows

- Format name: ExportE164example

- For line fields select: Directory Number, External Phone Number Mask, Alerting Name, Display (and any other fields you are interested in)

- modify the phone maximums accordingly

3. Save the new file format

4. Go to Export Phones (Bulk Administration>Phones>Export Phones>Specific Details)

5. Query devices using the parameters that work for you (like Device Name begins with SEP or other criterion. You can specify multiple query parameters by hitting the "+" key on the "Find Phones where..." line of the web page interface

6. Click Next

7. Specify the filename (file name for your export job) and select the File Format you just created (e.g. ExportE164Example)

8. Select Run Immediately and give it a Job Name. Click on Submit

You can monitor the job under Job scheduler: (Bulk Administration>Job Scheduler)

When the job is complete you can download the file: (Bulk Administration>Upload/Download files)

HTH.

Regards,

Bill

Please remember to rate helpful posts.