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
 
Sig. fields for 'blfspeeddial' table:             

Sig. fields for 'device' table:                    

Sig. fields for 'numplan' table:                          

Sig. fields for 'devicenumplanmap' table: 

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: 
Field Name                  Description                          Example                   
================            ==================================   ===============           
origdevicename              Device call originated from          SEP00235E17EF3C           
user_id                     User of device call orignated from   jldoe                     
callingpartynumber          DN of the party placing the call     81234                     
datetimestampconnect        time the call connected              2014-04-17 10:27:58.0                
duration                    duration of call in seconds          20                                   
datetimestampdisconnect     hung up time                         2014-04-17 10:47:02.0                
finalcalledpartynumber      DN called                            82345                                
destdevicename              Device of number called              SEP00235E17EF3C                      
datetimeOrigination         UNIX time stamp (great for sorting)  1399479957                           
___________________________________________________________________________________________

CUP Server

Sig. fields for 'enduser' table: