04-18-2012 11:54 PM - edited 03-19-2019 04:46 AM
Good Day All,
I need to run an sql query on the CUCM to list all of my directory numbers, their partition, and their external mask values.
I came across this excerpt below earlier so I have a bit of an idea how to do it but iw would be great to see some other examples of sql queries.
Any assistance is most appreciated.
Also, is there a document somewhere to tell me how to run these queries?
Thanks in advance
Regards
Amanda
*******************************************************************************************************************************************************************************
Currently Being Moderated
05/04/2011 5:18 AM (in response to Joshua Royle)
Re: Is there a way of pulling a report off CM showing all phones that have diverts on?Try if running this SQL query from the CLI helps you, it should list all DN's that have CFA enabled to VM or a DN:
run sql select dnorpattern,cfadestination,cfavoicemailenabled from CallForwardDynamic c, numplan n where c.fknumplan = n.pkid and (cfadestination != '' or cfavoicemailenabled ='t')
Solved! Go to Solution.
04-05-2016 08:12 AM
Hi
If you run the query over AXL then it will come back in a format you can read with whatever script language you call it with, and you can then format it however you like for output.
Are you running it from the server CLI or otherwise?
Aaron
04-05-2016 08:14 AM
From the CLI today, I have an SSIS instance that connects via SSH and runs the query.
AO
04-05-2016 09:59 AM
I'm trying AXL and its failing, I've started a new discussion on it.
https://supportforums.cisco.com/discussion/12954431/cucm-axl-query-returned-rows
AO
06-02-2017 08:10 AM
Does anyone know if there is a way to query the
06-17-2015 01:00 PM
Thanks Aaron! This information is still relevant.
03-15-2016 09:18 PM
Thanks. very informative and easy to step in.
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