cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
458
Views
0
Helpful
2
Replies
Highlighted
Enthusiast

Find out what users have no "Primary Extension"

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.

Everyone's tags (4)
2 REPLIES 2
Beginner

Re: Find out what users have no "Primary Extension"

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

Find out what users have no "Primary Extension"

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,

CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards