Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Call Manager - Query end-users without controlled device and vice versa

Hi,

I'm trying to find all End-Users without a controlled device configured.

Vice versa, I want to see all Devices without a End-User configured.

Are there some Query's to do that?

thanks,

Marc

3 REPLIES

Hi Marc,Have you got any

Hi Marc,

Have you got any solution on this??

If yes, Please do let me know how to get this report ( Device without end user)

 

Thanks

Maninder

 

 

New Member

Hi Maninder,Unfortunately I

Hi Maninder,

Unfortunately I still haven't any solution for this.

regards
Marc

Hi Marc, By running the belo

Hi Marc,

 

By running the belo query we can get the details of Device which are not assoicated with any end user.

======================================

run sql select userid,firstname,lastname,telephonenumber,department,enduser.allowcticontrolflagcti,device.name,device.tkmodel, numplan.dnorpattern Primary from enduser left join enduserdevicemap on(enduser.pkid=enduserdevicemap.fkenduser) left join device on(enduserdevicemap.fkdevice=device.pkid) left join endusernumplanmap on(enduser.pkid=endusernumplanmap.fkenduser) left join numplan on(endusernumplanmap.fknumplan=numplan.pkid) where telephonenumber LIKE '4%' ORDER BY telephonenumber

===========================================================

294
Views
0
Helpful
3
Replies
CreatePlease to create content