![]() ![]() run sql select d.name, d.description, n.dnorpattern as DN, rp.name as partitionįrom device as d inner join devicenumplanmap as dnpm on dnpm.fkdevice = d.pkid Here is a query that is designed to find phones that do not have a line-level user association. Check out the URLįind Phones that Do Not have a Line-Level User Association If you look a little further in the thread it gives you your answer. ![]() You would do that if you wanted to ensure that both are configured, and want to find devices that need remediation. You can refer to the earlier query to find devices with just no Owner ID, or, remove the d2 join to focus only on the devices that have no end user association, if you want to separate the two things. Run sql select d.name, n.dnorpattern as dn, rp.name as partition from device as d inner join devicenumplanmap as dnpm on dnpm.fkdevice = d.pkid inner join numplan as n on dnpm.fknumplan = n.pkid inner join routepartition as rp on n.fkroutepartition=rp.pkid and d.tkclass = 1 inner join device as d2 on d.pkid = d2.pkid and d2.fkenduser is null where d.pkid not in (select fkdevice from enduserdevicemap) and d.tkproduct in ('462', '449', '537', '390') This mess works for me to list devices which do not have an Owner ID and are not associated with an end user: I've also learned some of our devices are not provisioned correctly either.Īs far as i know, anything relating to CTI control, which I don't believe TCT/BOT supports anyway, requires end user assignment, but we can see how far my beliefs have taken me so far in this thread The simple query I posted lists devices which have no owner ID assigned, which may or may not work properly in your environment I guess based on provisioning. If the userID is set as the owner ID, or if the device is associated with the end user, it appears discoverable and the client will register. Specifically with the TCT as I didn't test other types: ![]() Doing some learning this morning to test what I've told you, and I've learned more. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |