CUCM 12.5 sql qurey limit 1000

[miket]

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

[Jonas Fraga]

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.