05-18-2012 07:15 AM - edited 03-16-2019 11:14 AM
Is there a report that I can run that will give me a listing of which numbers are assigned to my users?
I.E., --- 1111 - Bob Smith, 1112 - Fred Jones. etc ...............
FYI - I found the solution I was looking for
In CUCM Admin go to "Call Routing" - "Directory Numbers" and then filter for Directory Number and add Description where the criteria is "is not empty". This gives me the number, partition and description (name) that I am looking for. Now, I just need to figure out a way to export it ... one step at a time
05-18-2012 07:19 AM
Hi there,
Maybe this would work for you;
From CUCM admin try Call Routing > Route Plan Report and once it loads
up look at the top right hand corner of the page for "View in File" this will allow
you to save a copy in .csv format
Cheers!
Rob
"Show a little faith, there's magic in the night" - Springsteen
05-18-2012 07:57 AM
thanks - that's a very comprehensive reporting tool, but it does not give me the users name with the number
05-18-2012 09:24 AM
Hi there,
Sorry about that, I keep forgetting that we put all the user names in the "Description"
on the Device config page which then populates the Route Plan Report accordingly.
Have you tried using BAT> Export to get @ the details you need?
Cheers!
Rob
"Show a little faith, there's magic in the night" - Springsteen
05-19-2012 07:44 PM
Here is another option for you.
Run the following from Command Line, copy/paste to notepad then import into Excel.
run sql select numplan.dnorpattern, routepartition.name AS routepartitionname, numplan.description FROM numplan LEFT OUTER JOIN routepartition ON numplan.fkroutepartition = routepartition.pkid order by dnorpattern
Hope this helps.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: