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:

Show CUPS commands for UC information

Show CUCM commands for phone ownership changes
Hide CUCM commands for jabber information
Allow Presentation Sharing Using BFCP:
Note: The next two commands work best for manipulating less that 1000 devices.
If dealing with more, you may want to add more contraints to the SQL

Find jabber devices not supporting BFCP:
run sql select name,description,enablebfcp from device where name like 'CSF%' and enablebfcp='f'

Output will look something like this:
name     description     enablebfcp 
======== =============== ========== 
CSFjldoe 81234 - Telecom f 

Turn on BFCP for any jabber client that does not have it turned on:
run sql update device set enablebfcp='t' where name like 'CSF%' and enablebfcp='f'
Show CUCM commands for BLF phone information
Show CUCM commands for phone information
Show CDR commands for phone information

Show TABLE information