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:                    
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                                      
___________________________________________________________________________________________

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: 

CUP Server

Sig. fields for 'enduser' table: