Does this help?
run sql select eu.userid, d.name, d.description, n.dnorpattern as DN from device as d inner join devicenumplanmap as dnpm on dnpm.fkdevice = d.pkid inner join enduserdevicemap as eudm on eudm.fkdevice=d.pkid inner join enduser as eu on eudm.fkenduser=eu.pkid inner join numplan as n on dnpm.fknumplan = n.pkid and d.tkclass = 1
I would like to see all users connected with UDP, Phones, UserID and DN.
Do you have a SQL query to display the connected users list ?
Thanks a lot for your help.
Hi, hope it will be useful for you
SELECT userid, d.name AS device, d.description, n.dnorpattern AS DN FROM enduser LEFT JOIN enduserdevicemap eudm on enduser.pkid = eudm.fkenduser LEFT JOIN device d on eudm.fkdevice = d.pkid LEFT JOIN devicenumplanmap dnpm on dnpm.fkdevice = d.pkid LEFT JOIN numplan n on dnpm.fknumplan = n.pkid WHERE d.tkclass = '254' ORDER BY userid