Participante em Destaque,
Prêmio"Escolha dos membros": novembro de 2014
My Customer have a solution of CallManager 5.1.3 with 3500 IP Phones and ask for me if is possible to filter only DN that have mail box configured. Is it this possibility?
Yes, this is possible as Jonathan said you could run a query from the command line or use the SOAP/AXL API to submit a sql query. Nothing native to CUCM for this type of query.
If you use putty you can log the output of a sql command from the cli to a text file.
The following query will get you near what you are looking for I think:
admin: run sql select dnorpattern, cfadestination, cfavoicemailenabled from numplan order by dnorpattern
You can then use excel or something to parse this out to suit your customer's needs. Or if you wanted separate queries:
Oh, and since you are using 5.1.3, the 8.0 data dictionary won't help you as the schema has changed significantly. Here is the 5.x database schema:
Please remember to rate helpful posts.