SQL Statement for Jabber enabled user

[Michael Apperger]

Hello,

Can someone help me with an SQL statement for the Call Manager?
I need all users that are "Enable User for Unified CM IM and Presence".

Regards
Michael

[Rob Huffman]

Hi Michael,

One of the CSC greats, Bill Bell covers this in the Q&A in his blog;

http://www.ucguerrilla.com/2012/03/cucm-sql-queries-part-2.html

Cheers!

Rob

[Michael Apperger]

I have found many difference SQL Statements but not what i search :-(

[Jaime Valencia]

Have you already looked at the data dictionary??

https://developer.cisco.com/media/UCM10.5DataDictionary/UCM10.5DataDictionary.htm#enduser