CM Bulk Administration - Generating a list containing external mask?

Answered Question
Apr 6th, 2010

Hello, I want to get a report which would include

the users full name extension and external calling mask. The only option I can't find is

getting that external mask in the report. Any help would be appreciated. Thank You

I have this problem too.
0 votes
Correct Answer by William Bell about 6 years 9 months ago

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.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
William Bell Tue, 04/06/2010 - 14:52

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.

dkearsley Wed, 04/07/2010 - 07:55

Thank you Bill, that was very helpful. Kindest Regards -Dave

Actions

This Discussion