04-06-2010 01:23 PM - edited 03-19-2019 12:44 AM
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
Solved! Go to Solution.
04-06-2010 02:52 PM
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.
Please remember to rate helpful responses and identify
04-06-2010 01:24 PM
What version of CUCM?
Please remember to rate helpful responses and identify
04-06-2010 01:30 PM
It is 6.1.4
04-06-2010 02:52 PM
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.
Please remember to rate helpful responses and identify
04-07-2010 07:55 AM
Thank you Bill, that was very helpful. Kindest Regards -Dave
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide