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