cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Walkthrough Wednesdays
648
Views
5
Helpful
3
Replies
Highlighted

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

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

3 REPLIES 3
Highlighted
Cisco Employee

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

Highlighted

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

Highlighted

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

 

Content for Community-Ad