10-10-2012 10:17 AM - edited 03-16-2019 01:37 PM
Hello,
I was wondering if there was anyway to run a report to see which devices were utilizing the Call Forward All feature in CUCM.
Is this possible?
Thanks
10-10-2012 10:23 AM
Use the export function of CUCM in the bulk edit tool to dump out all the details, and then use Excel to filter the information that you need.
You can use CLI do this using this command, this is an SQL QUERY:
run sql select dnorpattern,cfadestination,cfavoicemailenabled from CallForwardDynamic c, numplan n where c.fknumplan = n.pkid and (cfadestination != '' or cfavoicemailenabled ='t')
I already use this is very helpful, look at this discussion for more details:
https://supportforums.cisco.com/message/3330219#3330219
This other command list the CSS CFW, CFA Destination, DN, DNDescritption:
run sql SELECT dnorpattern, numplan.description AS DNDescription, cfadestination, callingsearchspace.name AS CSS FROM numplan JOIN callforwarddynamic ON numplan.pkid=callforwarddynamic.fknumplan JOIN callingsearchspace ON callingsearchspace.pkid=callforwarddynamic.fkcallingsearchspace_cfa
Regards
Rate this if helps!
Leonardo Santana
10-10-2012 12:17 PM
So under Cisco Unified CM Administration, go to Bulk Administration and then where?
Thank you for the SQL Queries, very cool.
10-10-2012 12:26 PM
GO at Phones -> Export Phones -> All Details
And then select the type of phones that you want to export, put the file name and click at Run Immediately.
Afther this go at Job Scheduler and see if your job is completed.
Once the job is completed download the file that this job generate.
Open the file with excel, convert the , to column and put a filter at the Forward All Destination field.
Regards
Rate this if helps
Leonardo Santana
10-10-2012 12:56 PM
Thank You.
This was very helpful
06-19-2015 10:46 AM
Leonardo,
I realize this is an old post, but I have a request from a user to try to automate a query for the current call forward information for a specific line. Following your reply post, I am familiar with both the job, and CLI Query. What I'm not sure of is if there's a way to create some automation to pull the Call forward info and then dump to an excel file for an end user's retrieval. I was thinking there may be an API/SDK tool or something to automate this. Maybe I can set up Filezilla (ftp client) to log in automatically and download the file? Any idea or help would be greatly appreciated. We are currently running CUCM 9.1(2).
Thanks in advance,
Arras
06-22-2015 06:11 AM
Hello Arras,
I dont have knowledge to give you a tip about how to automate this.
Sorry my friend :(
Leonardo Santana
06-22-2015 09:03 AM
I don't work with development or APIs, but you could possibly look into AXL to get the info, but you would need to schedule all that in a separate server and then do whatever processing you want to it.
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