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:                          
Field Name                      Description                        Example                              _
pkid                            primary key                        cd6f179d-78c4-c630-3e5b-92da58d3573a  
dnorpattern                     DN                                 82345                                 
description                     device description                 82345 - Telecom                       
alertingname                    DN alerting name                   John Doe                              
alertingnameascii               DN ASCII alerting name             John Doe                              
cfnaduration                    No Answer Ring Duration (seconds)  20                                    
callingpartytransformationmask  mask                               84300                                 
cfbdestination                                                                                           
cfnadestination                                                                                          
cfbvoicemailenabled                                                                                      
cfnavoicemailenabled                                                                                     
cfdfvoicemailenabled                                                                                     
cfaptvoicemailenabled                                                                                    
cfaptdestination                                                                                         
cfaptduration                                                                                            
cfbintdestination                                                                                        
cfbintvoicemailenabled          call forward busy internal to vm   t                                     
cfnaintdestination                                                                                       
cfnaintvoicemailenabled                                                                                  
cfhrdn                                                                                                   
cfhrintdn                                                                                                
cfhrintvmenabled                                                                                         
cfhrvmenabled                                                                                            
cfurdestination                                                                                          
cfurintdestination                                                                                       
cfurintvoicemailenabled                                                                                  
cfurvoicemailenabled                                                                                     
cfbdestination                                                                                           
_________________________________________________________________________________________________________

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: