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:             
Field Name         Description                        Example                              
================   ================================   ===============                      
pkid               primary key                        853c43f7-1821-f531-17d4-35a231508bf2 
label              primary label                      John Doe                             
labelascii         ASCII label value                  John Doe                             
fkdevice           key to device                      8328a7ca-f78c-e6c7-d2ea-9rb54001cbea 
blfindex           location of BLF                    4                                    
blfdestination     DN BLF points to                   82345                                
fknumplan          key ptr to DN                      8328a7ca-f78c-e6c7-d2ea-9rb54001cbea 
___________________________________________________________________________________________

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: 

CUP Server

Sig. fields for 'enduser' table: