CUCM SQL Queries for users with IPCC Extension and Primary Extension asigned

Run the following in a CLI session on your CUCM Server to generate a list of users with IPCC extensions assigned in their user profile:

run sql select e.userid, n.dnorpattern from enduser as e, numplan as n, endusernumplanmap as x where (e.pkid = x.fkenduser and x.fknumplan = n.pkid and tkdnusage=2)

Run the following query for users with primary extensions assigned:

run sql select e.userid, n.dnorpattern from enduser as e, numplan as n, endusernumplanmap as x where (e.pkid = x.fkenduser and x.fknumplan = n.pkid and tkdnusage=1)