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
Show CUCM commands for BLF phone information
Show CUCM commands for phone information
Show CDR commands for phone information

Show TABLE information
CUCM Server
 
View valued fields for 'blfspeeddial' table:             

View valued fields for 'device' table:                    

View valued fields for 'numplan' table:                          

Sig. fields for 'devicenumplanmap' table: 
Field Name         Description                        Example                              
================   ================================   ===============                      
pkid               primary key                        cd6f179d-78c4-c630-3e5b-92da58d3573a 
display            DN display name                    John Doe                             
displayascii       DN ASCII display name              John Doe                             
e164mask           external mask                      84300                                
label              DN on device primary label         John Doe                             
labelascii         DN on device ASCII label value     John Doe                             
___________________________________________________________________________________________

Sig. fields for 'callforwarddynamic' table:        

Sig. fields for 'enduser' table:                               

Sig. fields for 'devicehlogdynamic' table: 

Sig. fields for 'linegroupnumplanmap' table:       

Sig. fields for 'linegroup' table:                 

Sig. fields for 'tbl_billing_data' table in CAR database: 

CUP Server

Sig. fields for 'enduser' table: