Tools

Tools

----------------

http://www.freesshd.com/?ctt=download

Free SFTP

http://www.pronetexpert.com/technologies/free-tools

3CDaemon free SFTP

http://www.elifulkerson.com/projects/tcping.php

To test your SFTP, use a SFTP client


http://the.earth.li/~sgtatham/putty/latest/x86/psftp.exe)

Tcping 986 or 984

SerialGrabber

Serial/mac/dn collector tool

easy to use screenshot tool

http://lightscreen-portable.en.softonic.com/

Unity Express New Language Package Installation

Step 1- configure the ftp

config t

software download server url ftp :// / username cisco password cisco123

// to check the ftp path show software download version

Step 2- Change the voicemail capacity to 480

voicemail capacity time 480

// to reduce vm users mail box size

voicemail mailbox owner "test" size 100

Step 3- download the pkg and prt file from FTP to CUE

software install add cue-vm-langpack.nm-aim.3.1.1.pkg

software install add cue-vm-ja_JP-langpack.nm-aim.3.1.1.prt1

Step 4- Change language settings

System > Language Settings

Reference:

http://www.cisco.com/en/US/docs/voice_ip_comm/unity_exp/rel3_1/installation/guide/nuinstall31.html

Unity Express Upgrade

Download Installation Packages and Language Packages (.prt) from Cisco

config t

software download server url ftp://x.x.x.x/ username xxxxx password xxxxx

show software download server

exit

software download upgrade cue-vm-k9.nm-aim.3.2.2.pkg

software download status

show software directory download

software install upgrade cue-vm-k9.nm-aim.3.2.2.pkg

show software version

Reference:

http://www.cisco.com/en/US/docs/voice_ip_comm/unity_exp/rel3_2/installation/guide_/upgrade32.html

International CDR Report from CUCM CLI

By using SQL query we would be able to generate CDR details from CUCM CLI

Here is the query for international calls

Partition= here you should have to mention your international partition

eg : -

run sql select datetimestampconnect,datetimestampdisconnect,duration,callingPartyNumber,originalCalledPartyNumber from car: tbl_billing_data where finalCalledPartyNumberPartition='PT_Int' and datetimestamporigination between '2011-11-21 00:00:00' and '2011-11-26 23:59:59'

Here are the few more queries from CM 


run sql select datetimestampconnect,datetimestampdisconnect,duration,callingPartyNumber,originalCalledPartyNumber from car: tbl_billing_data where datetimestamporigination between '2012-05-01 00:00:00' and '2012-06-02 00:00:00'

 =>This query will give you the details about call disconnection. run sql select 

run sql select datetimestampconnect,datetimestampdisconnect,duration,callingPartyNumber,origCause_value,originalCalledPartyNumber,destCause_value from car: tbl_billing_data where datetimestamporigination between '2012-03-30 17:20:00' and '2012-03-30 17:35:00'


 run sql select * from car:tbl_billing_data

run sql select * from car:tbl_billing_data where datetimestampconnect > '2011-04-15 11:02:25'

run sql select * from car:tbl_billing_data where originalcalledpartynumber like '%2966'

SQL CDR reporting in CUCM ver 8:

https://supportforums.cisco.com/thread/2087799

There are changes in the DB table. new format is given below

run sql car select call_type,callingpartynumber, originalcalledpartynumber, datetimestamporigination from car:tbl_billing_data where originalcalledpartynumber in ("911")

run sql car select * from car:tbl_billing_data where originalcalledpartynumber like '%2966'

https://community.cisco.com/t5/ip-telephony-and-phones/car-database-tables-in-cucm-10-5/td-p/3210520

UCCX SQL access for third party application

Open the command line on your UCCX server and do the following:

Step 1: -

C:\>osql -L

Servers:

(local)\CRSSQL

Step 2: -

Connect to MSDE using Local account

osql -E -S SERVERNAME\CRSSQL

Step 3: -

List the current logins in SQL

exec sp_helplogins

go

Step 4: -

Create a user account and grant access to db_cra database:

use db_cra

go

exec sp_addlogin 'username','password'

go

exec sp_grantdbaccess 'username'

go

exec sp_addrolemember 'db_wallboard_read','username'

go

Eg:-

1> exec sp_addrolemember 'db_datareader','Muttil'

2> go

'Muttil' added to role 'db_datareader'.

Cisco IP Phone - SSH login

Step 1: go to Device phone configuration page and configure the SSH login user name and password and reset the phone.

Step 2: SSH to the phone using that username and password.
It would prompt again. Enter user debug and password debug

· show command and ” ? “ will give you entire command details

Sample Commands

clear call history

show brightness

show call-history summary

show config network

show cpu

show power

show stream active all

erase all settings

reset factory

show stream active all

Troubleshooting

If you are not able to login SSH , download the cnf.xml file and check the config file.
Check if the user name and password is updated on the cnf.xml
Here is the cmd for that : tftp 172.22.32.12 GET SEPFCFBFBCA1B1B.cnf.xml

SQL Query to check SSH enabled or not

run sql SELECT Device.name,TypeModel.name,"SSH Enabled" FROM Device,TypeModel,DeviceXml4k WHERE DeviceXml4k.fkDevice=Device.pkid AND Device.tkModel=TypeModel.enum AND xml LIKE "%0%"

CAD Logs

Farzan.SKSocket[addr=10.91.80.162,port=1736,localport=43027] timed out or stuck so closed.

%MIVR-ICD_CTI-3-CLIENT_SOCKET_CLOSED:Client connection

ADOutOfServiceMsg

Reason code:32765

DeviceOutOfServiceMsg (Rsrc:Matiuj.Zaman,Reason:DEVICE_UNREGISTERED)

128210861: Aug 16 14:01:00.095 EDT %MIVR-SS_RM-7-UNK:Rsrc: Matiuj.Zaman New State:UNAVAILABLE Old State:UNAVAILABLE Reason code:32759

PING_INFO:Server pinging client for info.: trace=Ping results to client: 10.91.80.184

Backup Cisco Router files to TFTP Server

Configure TFTP application (eg-3CDaemon)

Steps:
---------

Router#copy flash tftp

Source filename [DistinctiveRingList.xml]? ringtones/DistinctiveRingList.xml

Address or name of remote host []? 10.81.110.3

Destination filename [DistinctiveRingList.xml]? ringtones/DistinctiveRingList.xml
!!
2823 bytes copied in 0.972 secs (2904 bytes/sec)

Unable to delete user from Cisco Unity

Unable to delete user from Cisco Unity system

1. Trouble Shooting Steps

Step 1:

When checked the config found user extension assigned to old user, and user was not present in AD.

Tried to delete the user from CLI by using below Command

admin:run cuc dbquery unitydirdb EXECUTE PROCEDURE csp_UserDelete(pObjectId='a6ef1f75-253c-426f-93f6-88b5af84a788')

Key value for constraint (informix.pk_tbl_globaluser) is still being referencedot .

Command failed

Got above error and checked call routing /call handlers but didnt find anything.

Step 2:

Run the below query and found the following dependency.

admin:run cuc dbquery unitydirdb select * from vw_subscriberreference where objectid IN (select objectid from vw_subscriber where fn_tolower(alias) =fn_tolower('mary.flanders'))

objectid displayname referencetype referrerobjectid referrerobjecttype

------------------------------------ --------------- ------------- ------------------------------------ ------------------

a6ef1f75-253c-426f-93f6-88b5af84a788 AA Recipient c40fa18d-755e-40f5-b6d4-1fbd4a069a75 3

a6ef1f75-253c-426f-93f6-88b5af84a788 Receptionist Recipient 3f1ab745-40ca-4b67-8456-5041e52cbd19 3

a6ef1f75-253c-426f-93f6-88b5af84a788 mary.aRecipient 2081d266-1c83-4392-a9b8-466f391b3c23 3

Step 3:

Removed old user account from AA,Receptionist from following locations

Go to Call Management -- System Call Handlers --and select Call Handlers--choose edit --message settings

And remove associated user

Step 4:

Run the below command and deleted account from data base.

admin: run cuc dbquery unitydirdb SELECT ObjectId from vw_User WHERE Alias='mary.a' --to get the object ID

admin:run cuc dbquery unitydirdb EXECUTE PROCEDURE csp_UserDelete(pObjectId='a6ef1f75-253c-426f-93f6-88b5af84a788')

Few other cmds

----------------------

admin:run sql select userid, pkid from enduser where userid = ''

admin:run sql SELECT fkenduser, fkappserver FROM enduserappservermap WHERE fkenduser = '83215248-6288-446d-87e2-db5efcca3e98'

run sql delete FROM enduserappservermap WHERE fkenduser = '83215248-6288-446d-87e2-db5efcca3e98' and fkappserver = '67285943-ff95-4f4f-88c6-e6206cf23551

CME phone Firmware load

copy tftp:10.10.50.33 flash:apps31.8-4-1-23.sbn
copy tftp:10.10.50.33 flash:cvm31sccp.8-4-1-23.sbn
copy tftp:10.10.50.33 flash:cnu31.8-4-1-23.sbn
copy tftp:10.10.50.33 flash:dsp31.8-4-1-23.sbn
copy tftp:10.10.50.33 flash:jar31sccp.8-4-1-23.sbn
copy tftp:10.10.50.33 flash:SCCP31.8-4-2S.loads
copy tftp:10.10.50.33 flash:term31.default.loads


Tftp-server flash:apps31.8-4-1-23.sbn
Tftp-server flash:cnu31.8-4-1-23.sbn
Tftp-server flash:cvm31sccp.8-4-1-23.sbn
Tftp-server flash:dsp31.8-4-1-23.sbn
Tftp-server flash:jar31sccp.8-4-1-23.sbn
Tftp-server flash:SCCP31.8-4-2S.loads
Tftp-server flash:term31.default.loads


telephony-service
load 7931 SCCP31.8-4-2S
no create cnf
create cnf

exit
wr mem

tftp 10.10.60.250 get SEP001D09130611.cnf.xml

Deb ephone detail mac
Deb tftp event
debug ephone register
debug ephone statistics
debug ephone error
debug ephone message
debug ephone state
debug dhcp

PRI Config

isdn switch-type primary-net5
controller E1 0/0/0
framing crc4
linecode hdb3
pri-group timeslots 1-31
isdn bchan-number-order asce
clock source line

-----------------------------------------------

!

card type t1 1 0

!

//Enable T1 1/0

!

controller T1 1/0/0

framing esf

linecode b8zs

cablelength long 0db

pri-group timeslots 1-24

!

// configure T1

!

interface Serial1/0/0:23

no ip address

encapsulation hdlc

isdn switch-type primary-ni

isdn incoming-voice voice

isdn map address ^011 plan unknown type unknown

isdn supp-service name calling

no cdp enable

!

//Configure the T1 controller 1/0/0:23

voice-port 1/0/0:23

bearer-cap Speech

!

// For Bearer Capability in the ISDN Q.931 SETUP message.

!

dial-peer voice 7 pots

preference 5

incoming called-number .

direct-inward-dial

port 1/0/0:23

!

Refrence:

http://www.voip-info.org/wiki/view/CallManager+Express

http://uc500.com/en/configuring-cisco-unified-communications-manager-express

http://3packet.com/voip-phones-cisco-asterisk/ -- B/w calc

http://www.uccx.net/ –UCCX

http://chikkis.blogspot.com/ -Lab

http://cciev.wordpress.com/ -wordpress

http://voip.rheid.com/voip-faqs/voip-bandwidth-calculator.html

http://www.asteriskguide.com/bandcalc/bandcalc.php

tcping utility

http://www.elifulkerson.com/projects/tcping.php

http://pushkarbhatkoti.wordpress.com/ - Moh Download

http://pushkarbhatkoti.wordpress.com/2009/06/08/cisco-presence-integration-with-ccm-7x-in-20-minutes/ - Presence Configuration

http://my.lovelycharts.com    -->Flow charts


Cisco Icons

http://wenku.baidu.com/view/a6a518ff700abb68a982fbae.html

Cisco Unity Express Backup Procedure

Backup procedure

1. Configure a FTP server where you have to store the backup files .

Check ftp status using following DOS commands

ftp

telnet 21

There are two ways to take CUE backup files ,CLI or GUI

CLI backup procedure:

(config)# backup server url ftp:/// username XXX password XXX

# offline

=> It will bring the CUE off the production

# backup category all

Once complete the CUE back up enter below cmd It will bring the CUE back into production

# continue

Status commands

# show backup history

# show backup server

GUI backup procedure:

Go to Administration menu and select backup/Restore->choose configuration

Ref - http://netribe.blogspot.be/2010/08/upgrading-cisco-cue-from-311-to-32x.html

Debug CMDs

MGCP gateway

--------------

show ccm manger--to check reg or not

show mgcp statistic

show mgcp endpoints

show mgcp connection

debug mgcp packets

debug mgcp state

debug mgcp error

debug isdn q931

H.323

----------

show dialplan number

debug vtsp session

debug vpm signal

debug voice ccapi inout

debug voip dialpeer

debug cch323 h225

debug cch323 session

debug ccsip mess

debug voice ccapi inout

show isdn status

show isdn active

show isdn history

sh voice call summary

sh voice call status

show voip rtp connections

show dial-peer voice summary
show dialplan number
show call active voice
show call active voice brief
show isdn status

CM CLI

admin:file list activelog /cm/trace/cti/sdl/ date detail page

admin:file list activelog /cm/trace/cti/

admin:file list activelog /cm/trace/

admin:file list activelog /cm/trace/ccm/sdi/ detail date page

admin:file list activelog /cm/cdr_repository/car - CDR info

tftp 172.22.32.12 GET SEPFCFBFBCA1B1B.cnf.xml

utils diagnose test 

file get activelog tomcat/logs/*  -  To download Tomcat logs