cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
807
Views
0
Helpful
1
Replies
miket
Contributor

CUCM 12.5 sql qurey limit 1000

I have a customer that is running 12.5 CUCM and are trying to pull all the ip addresses of all the phones from CUCM using a SQL query. They are hitting the SQL limit of returning 1000 entries according to TAC. Has anyone seen this issue or have a sql query or a workaround to get all the IP's of the phones. We have over 5000 phones so it is important to the customer. Any ideas would help

1 REPLY 1
Jonas Fraga
Enthusiast

Hello @miket 

 

Maybe this will be helpful: https://community.cisco.com/t5/unified-communications/cucm-axl-query-returned-rows/td-p/2879446

 

Basically you need to manage pagination on your AXL queries to avoid this limitations and maybe run 5 queried paginated instead of 1 with all information.

Create
Recognize Your Peers
Content for Community-Ad