SQL query to see UDP, Phone, UserID and DN on CUCM (CLI)

[aubert ciavaldini]

Hi,

I'm looking for a SQL query to see UDP, Phone, UserID and DN on CUCM (CLI).

Thanks a lot for your help.

BR

Aubert

[Aseem Anand]

Hi,

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

Aseem

[aubert ciavaldini]

Hi Aseem,

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.

BR

Aubert

[Evgeny Udaltsov]

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