Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

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

  • Contact Center
2 REPLIES
Cisco Employee

Hi,

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

New Member

Hi Aseem,

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

37
Views
0
Helpful
2
Replies