Mr. Mike Gibson's Cisco Info
Useful commands and SQL.

Useful CISCO command line commands
Favorite commands that can't be done in Web GUI

show commands:

Show CUBE commands

run sql commands:

Hide CUPS commands for UC information
Presence server:
Find general user info:
run sql select userid,mailid,primarynodeid,enablecalendarpresence,xcp_user_id from enduser where userid='jldoe'
Output will look something like this:
userid mailid          primarynodeid enablecalendarpresence xcp_user_id 
====== =============== ============= ====================== =========== 
jldoe  jldoe@ilstu.edu 2             t                      4317        

Turn on calendar presence for user:
run sql update enduser set enablecalendarpresence=ítí where userid='jldoe'

Show CUCM commands for phone ownership changes
Show CUCM commands for jabber information
Show CUCM commands for BLF phone information
Show CUCM commands for phone information
Show CDR commands for phone information

Show TABLE information