03-17-2010 05:11 AM - edited 03-15-2019 09:49 PM
Hi,
In our Cisco Unified CM Administration System version 7.0.1.11000-2 installation, I would like to make a complete report on the following:
I would like to make a complete report on all the users and all the phones they have attached including the phone number they have been assigned
With my information, I would like to have a list showing that my username is Carl-Marius Steensen and I have a CISCO IP PHONE 7940 series phone and I have the internal phone number 1595 assigned.
I know how to make a separate report on all the users and a separate report on all the numbers and a separate report on all the phones, but I do not know how I make a combined report in the "Cisco Unified CM Administration" system
Can you help me with this?
Kind regards,
Carl-Marius
Solved! Go to Solution.
03-17-2010 06:49 AM
Hi Carl-Marius,
Sadly, there is no built-in/canned report within CUCM that is going
to give you all this info in one nice report If I were tasked with this
job, I would probably use a combination of the Route Plan Report (view in file)
along with a BAT Phone Export and load the outputs in excel (.xlsx). I just tried
these out and with some serious "sorting" and trimming you can get exactly what you
require.
Cheers!
Rob
03-17-2010 06:51 AM
Unfortunately there is no report that contains all that info within the same report from the Unified CM admin.
You would need to gather all the info via sql qrys directly in the cli joining all the relevant tables.
HTH
java
If this helps, please rate
www.cisco.com/go/pdihelpdesk
03-17-2010 06:49 AM
Hi Carl-Marius,
Sadly, there is no built-in/canned report within CUCM that is going
to give you all this info in one nice report If I were tasked with this
job, I would probably use a combination of the Route Plan Report (view in file)
along with a BAT Phone Export and load the outputs in excel (.xlsx). I just tried
these out and with some serious "sorting" and trimming you can get exactly what you
require.
Cheers!
Rob
03-17-2010 06:51 AM
Unfortunately there is no report that contains all that info within the same report from the Unified CM admin.
You would need to gather all the info via sql qrys directly in the cli joining all the relevant tables.
HTH
java
If this helps, please rate
www.cisco.com/go/pdihelpdesk
03-18-2010 03:05 AM
Hi Rob and Java,
Thank you both for your answers, I guess I will have do to some manually programming to make this list the way I want it.
But thanks for your answers; I really appreciate your fast reply
Kind regards,
Carl-Marius
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: