Lets learn some basics of SQl Queries and try it on CUCM. What SQL? SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve…
Category: Unified Communication
How do I Size UC servers
Sizing is a part of UC engineers JOB role. it may be for a deployment, or a presales presentations, or may be for preparing a LLD document etc.. Sizing UC servers is easy with Cisco’s Sizgin tool. Many of us might have used Collaboration Sizing Tool (CST). This tool has been decommissioned and Quote Collab…
Cisco Collaboration Virtualization
How to check the UC virtualization support. Virtualization support varies by CSR releases. Cisco Collaboration virtualization is the place where you can check Vmware compatibility Cisco Collaboration virtualization Click to access Cisco Collaboration Virtualization. Select your applications and it takes you to the specific product hardware requirements page. For example i choose CUCM and it…
CSR Compatibility Matrix
When upgrading/Installing UC applications we need to make sure all applications are on compatible versions. CSR Compatibility Matrix provide you the recommended version and minimum version details . We must follow this matrix when installing /upgrading UC applications.Todays blog is all about the CSR compatibility matrix and how to use it. Compatibility Matrix Link Access…
Move to Type 9 password
Its highly recommended to replace your type 5 and 7 passwords with type 9 passwords. Many of us are aware that type 5 and type 7 passwords can be decrypted using online tools but many still not. Todays blog is all about configuring type 9 password. You can try decrypting type 5 and 7 password…
Remove RSA host key using ssh-keygen
nithineluvathingal@EluS-MacBookPRO ~ % ssh administrator@198.18.133.3 @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY! Someone could be eavesdropping on you right now (man-in-the-middle attack)! It is also possible that a host key has just been changed. The fingerprint for the RSA key…
PCD for Migrations/upgrades
Still many engineers are not aware about Cisco’s Prime collaboration Deployment and many hesitate to use it. From my experience its an awesome tool when upgrade/migrate UC application. PCD can also be used for UC backups(refer my previous blog https://defaultgateway.org/2021/02/06/cucm-backup-using-pcd-as-a-sftp-server/). When using PCD, always read the admin guide corresponding to your version. The below tables…
Verify MD5 from Router CLI
During a voice gateway IOS upgrade task to validate the file, customer requested to verify if the copied file and the file in the flash are of same size. Its not the right way. We need to compare the MD5 value. Today’s blog is about how to verify the MD5 using router CLI. Command to…
Insufficient license Warnings
I used to get calls from my customer saying that they see insufficient license warnings when login to CUCM. 90 % of the cases reported where due to the OWNER configuration . Remaining 10% are due to other reasons. With Pandemic many customer started creating Jabber profiles without choosing proper Owner filed which cause the…
Change ANI to Last/First redirect – SNR
When placing a PSTN call, if you send calling information other than your DID block. Most ISP drop the call or translate this to your DID pilot number. They does this for Billing Purpose. For such scenario instead of using Originator we need to use Last redirecting information. My previous blog was about how to…