09-11-2002 07:14 AM - edited 03-12-2019 08:43 PM
I am trying to find a way to export the description field from the call manager to an excel spreadsheet so I can print a user directory. Is this possible? Does anyone know what file the call manager stores this info in, in the database? Thanks!!
09-12-2002 10:44 AM
You can save a route plan report as a csv. Go to Route Plan > Route Plan Report and click on View in File. You can then save to disk and open the .csv in excel and massage the data to your liking.
Tim Medley - CCNP+Voice, CCDP, CWNA
Sr. Network Architect
VoIP Group
iReadyWorld
09-12-2002 06:45 PM
It stores it in SQL, but I don't what table or how to write the query. If you figure it out, could you post it, it's something I've wondered about as well.
09-12-2002 06:53 PM
If you want the extension, first name and last name these are stored in the DC Directory and I have used a simple VB script to extract this to a CSV file that you can open in Excel.
09-13-2002 01:05 AM
Hi,
Could u pls mail me the script. I was searching for this utility from a long time. My id is vijs@cisco.com. Thanks....
Regards
Vijay
09-13-2002 01:24 AM
Could you please e-mail me a copy of the VB script. Thank you!
09-13-2002 06:29 AM
you can also use the c:> show tech >test.txt (to a file) or c:> show tech to export this info to the screen
09-16-2002 11:29 AM
Thanks so much for your response. Can you email me the script to extract this info? You can email me directly at amber_barker@bellsouth.net.
Thanks again!!
02-03-2003 09:58 AM
Hi I would like the script your created also, if you wouldn't mind.
Thank You
09-13-2002 11:48 AM
If you want to pull this information directly from the Call Manager there are three table you need to look at in the database. The first table in called "numplan" and it will hold all dialable numbers including extension and route patterns. The second is the "device" table. this holds all the device information including the device description. The third table in "devicenumplanmap" and it maps the extension to the phone. You can right a query like the following the pull the information for only the phones:
SELECT device.description, numplan.dnorpattern FROM device, numplan, devicenumplanmap WHERE numplan.pkid = devicenumplanmap.fkdevice AND numplan.pkid = devicenumplanmap.fknumplan AND device.name LIKE "SEP%"
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