Find out what users have no "Primary Extension"

[kylebrogers]

Is there a way to determine what users on a system have no Primary Extension set?  There isn't a Primary Extension field in the search criteria of the End Users page.

This is CUCM 8.6.2.

[slashdots]

I don't know any pre defined report for that.

If your familiar with the CUCMs CLI you can run an SQL query to get this.

I’ve played around a little bit and created this query:

run sql select userid from enduser 
where userid NOT IN 
(select u.userid from enduser as u 
inner join endusernumplanmap as nm on u.pkid=nm.fkenduser 
inner join numplan as n on nm.fknumplan=n.pkid) 

Be careful when playing around with SQL queries, always keep an eye on CPU and memory usage of CUCM.

hope that helps

[Tadeusz Zeludziewicz]

Hi,

it's long ago that you have posted your question, here is the answer if you still need it:

The easiest way I found is to export the users to the txt file then import to Excell - there you can easily see it.

Go:  Bulk Administration > Users > Export Users,  export in format "All User Format"

Cheers,