User reports or SQL Query

[swaro2000]

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

[lindborg]

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

[Anirudh Mavilakandy]

For SQL Queries you can have a look at this,

http://www.cisco.com/c/en/us/support/docs/unified-communications/unified-communications-manager-callmanager/117726-technote-cucm-00.html

[Aman Soi]

[+5] to Anirudh.

you can also refer the discussion

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

regds,

aman

[maqsood ahmed]

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 !!!