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:                    
Field Name         Description                        Example                              _
pkid               primary key                        8018a7ba-a98c-e6c7-ce2b-6cb94001abcd  
name               device name                        SEP00235E17EF3C                       
description        device description                 82345 - Telecom                       
isactive           active state of device             t                                     
fkenduser          key ptr to device owner            8328a7ca-f78c-e6c7-d2ea-9rb54001cbea  
tkmodel            134 = RDP                          435                                   
                   435 = 7945                                                               
                   436 = 7965                                                               
                   437 = 7975                                                               
                   503 = CSF jabber                                                         
                   575 = BOT                                                                
                   652 = IOS tablet                                                         
tkdeviceprotocol   0  = SCCP                          0                                     
                   11 = SIP                                                                 
                   16 = RDP                                                                 
enablebfcp         Presentation Sharing Using BFCP    f                                     
tkClass                                                                                     
fkPhoneTemplate                                                                             
____________________________________________________________________________________________

View valued 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: 

CUP Server

Sig. fields for 'enduser' table: