Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

CM Bulk Administration - Generating a list containing external mask?

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: CM Bulk Administration - Generating a list containing extern

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.

HTH -Bill (b) http://ucguerrilla.com (t) @ucguerrilla

Please remember to rate helpful responses and identify

4 REPLIES

Re: CM Bulk Administration - Generating a list containing extern

What version of CUCM?

HTH -Bill (b) http://ucguerrilla.com (t) @ucguerrilla

Please remember to rate helpful responses and identify

New Member

Re: CM Bulk Administration - Generating a list containing extern

It is 6.1.4

Re: CM Bulk Administration - Generating a list containing extern

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.

HTH -Bill (b) http://ucguerrilla.com (t) @ucguerrilla

Please remember to rate helpful responses and identify

New Member

Re: CM Bulk Administration - Generating a list containing extern

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

366
Views
0
Helpful
4
Replies