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

[Marc Aemmer]

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

[Maninder Singh Gujral]

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

[Marc Aemmer]

Hi Maninder,

Unfortunately I still haven't any solution for this.

regards
Marc

[Maninder Singh Gujral]

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

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