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:

Hide CUBE commands
search of active calls with DN 82345:
show voip rtp connections detail | include 82345

Output will look something like this:
 callId 12223833 (dir=1): called=915038603911 calling=2074382345 redirect= 
     dest callId 12223834: called=15038603911 calling=2074382345 redirect= 
 callId 12223834 (dir=2): called=15038603911 calling=2074382345 redirect= 
    dest callId 12223833: called=915038603911 calling=2074382345 redirect= 
Easy to read list of active calls:
show voip rtp connections detail | include (dir=1)
Output will look something like this:
 callId 12223833 (dir=1): called=915038603911 calling=2074382345 redirect= 
 callId 12224128 (dir=1): called=912174154485 calling=2074388619 redirect= 
 callId 12224975 (dir=1): called=2074382515 calling=7087458138 redirect=   
 callId 12224977 (dir=1): called=2074382515 calling=7087458138 redirect=   
 callId 12225345 (dir=1): called=2074382231 calling=6182034430 redirect=   
{continues}



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