Reason codes for LastOutOfServiceInformation

ReasonForOutOfService=10    —  TCPtimedOut – The TCP connection to the Cisco Unified Communication Manager experienced a timeout error ReasonForOutOfService=12    —  TCPucmResetConnection – The Cisco Unified Communication Manager reset the TCP connection ReasonForOutOfService=13    —  TCPucmAbortedConnection – The Cisco Unified Communication Manager aborted the TCP connection ReasonForOutOfService=14    —  TCPucmClosedConnection – The Cisco Unified Communication Manager closed the TCP…

Expressway DMI Interface

From 12.7, expressway support dedicate Management Interface(DMI). s. Instead of sharing a routing interface with other traffic, management traffic is sent and received through LAN3 and no other traffic uses that port.The DMI is disabled by default. Enabling DMI Enabling the DMI function . This switches the LAN3 Port for management Traffic. Still you can…

CIMC Upgrade

When I visited a customer, I found alarms on their UCS server. So For CIMC acces I contacted the current supplier who installed this sever. They said due to java error CIMC doesn’t work with latest browsers. So they didn’t configure the CIMC. That’s not a good practice. Always Configure CIMC and if it’s outdated…

Flex Provisioning

With flex license, you will be getting a Provisioning EMail. Even If you don’t activate the license within 30 days the billing will gets started automatically. Todays blog is about how to provision and starting a Webex messaging subscription. Open the email you received titled Provisioning information required for order…, and click Set Up Your…

Assign Missing Owner Id using DAT

70% of license warning messages I have seen at my customer sites are due to missing Owner-ID.A common question many of my friends asked, is there a tool to assign Owner-Id on devices. Yes Cisco provide a tool called, Device assignment Tool in short we call it DAT. The tool connects to your system and…

SQl Query to pull Device Owner

The below SQL Query can be used to pull the details of Owner-Id assigned to the phones. Tables used.  Device – This table contains device-level information like IP Phones and gateways. Enduser – This table contains information about all Enduser in CUCM. Sql Query. SQL query to List the complete devices and the Owner status. Devices with…

Sql Query to pull unassigned DNS

The below SQL Query can be used to pull the details of Unassigned Dn’s Tables used.  NumPlan – This table contains information about all patterns configured in CUCM. Sql Query. run sql select dnorpattern from numplan where iscallable = ‘f’ Note:-unassociated DN IsCallable to False

SQL Query to pull devices not assigned with DN’s

The below SQL Query’s can be used to pull the devices which are not assigned with a DN Tables used.  Device – This table contains device-level information like IP Phones and gateways. DeviceNumPlanMap – This table contains the mapping between data in Device table and NumPlan table. If no DN’s are assigned, Device PKID wont be available…

SQL Query to list the Enduser, Controlled Devices,Extension Number & the device Type

The below SQL Query can be used to pull the details of Enduser-ID, controlled devices , their DN and the device Type. Tables used.  Device – This table contains device-level information like IP Phones and gateways. NumPlan – This table contains information about all patterns configured in CUCM. DeviceNumPlanMap – This table contains the mapping between data in…