Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Users might experience few discrepancies in Search results. We are working on this on our side. We apologize for the inconvenience it may have caused.
New Member

User reports or SQL Query

We have a Pub & Sub CUCM 8.5(1). We would like users reports showing the following output

  • first name
  • last name
  • userID
  • Extension

These reports need to be generated every week or so. Are there any built in reports within CUCM that already has the above information? Or will we need to run SQL queries instead?. If so, what is the SQL syntax that will generate the above results?

 

 

Thanks

4 REPLIES
Cisco Employee

The User Data Dump tool is

The User Data Dump tool is the easiest to use for this - built in reports can't be scheduled or email to you - UDD supports both those things:

http://www.ciscounitytools.com/Applications/CxN/UserDataDump/UserDataDump.html

 

Cisco Employee

For SQL Queries you can have

VIP Purple

[+5] to Anirudh. you can also

[+5] to Anirudh.

 

you can also refer the discussion

https://supportforums.cisco.com/discussion/11318391/cucm-sql-query

 

regds,

aman

New Member

The Technote about SQL query

The Technote about SQL query is good !  i liked it !

but i need to know  the DN , Description , for a particular  CSS...

Can u pls guide me to it !!!

191
Views
5
Helpful
4
Replies
CreatePlease to create content