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
Show CUCM commands for jabber information
Hide CUCM commands for BLF phone information
Cisco CM - Show BLF for DNs
(Simple) list content of BLF labels for a DN. Nice and simple/short command to show what is out there:
run sql select label,labelascii from blfspeeddial where blfdestination='82345'

Output will look something like this:
label       labelascii  
=========== =========== 
Mike Gibson Mike Gibson 
Mr Gibson   Mr Gibson   
Mike G.     Mike G.     
test        test        
Gibson      Gibson      
Mike Gibson Mike Gibson 

List content of BLF labels, index of labels, and description of the devices they belong on.
run sql select blf.blfdestination,blf.label,blf.labelascii,blf.blfindex,d.name,d.description from device d,blfspeeddial blf where blf.blfdestination='81234' and blf.fkdevice=d.pkid order by d.description

Output will look something like this:
blfdestination label       labelascii  blfindex name            description
============== =========== =========== ======== =============== ===============
81234          Mike Gibson Mike Gibson 7        SEP68BC044143D3 80200 - Telecom
81234          Mr Gibson   Mr Gibson   3        SEP64A5055E7682 82345 - Telecom
81234          Mike G.     Mike G.     3        SEP30435516F77D 82392 - Telecom
81234          test        test        4        SEP142439455B59 86014 - Telecom
81234          Gibson      Gibson      20       SEP61A2E3146506 88443 - Telecom
81234          Mike Gibson Mike Gibson 18       SEP0012203B4E35 88730 - Telecom
List content of BLF labels for a device they belong on. List by device and order of index.
run sql select blf.blfdestination,blf.label,blf.labelascii,blf.blfindex,d.name,d.description from device d,blfspeeddial blf where d.description like '81234%' and blf.fkdevice=d.pkid order by d.name,blf.blfindex

Output will look something like this:
blfdestination label       labelascii  blfindex name            description
============== =========== =========== ======== =============== ===============
82345          Dan T       Dan T       1        SEP00255E173F3C 81234 - Telecom
83456          Brian G     Brian G     2        SEP00255E173F3C 81234 - Telecom
84567          Danny E     Danny E     3        SEP00255E173F3C 81234 - Telecom
85678          Jane D      Jane D      4        SEP00255E173F3C 81234 - Telecom
86789          Anne M      Anne M      5        SEP00255E173F3C 81234 - Telecom

Show CUCM commands for phone information
Show CDR commands for phone information

Show TABLE information