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…

SQL Query to list Enduser and controlled devices

Use below SQL query to List User-ID and controlled devices. Tables used. Device – This table contains device-level information like IP Phones and gateways.Enduser – This table contains information about all Enduser in CUCM.Enduserdevicemap – This table contains the mapping between data in Enduser table and Device table. Sql Queries. run sql select enduser.userid, device.name from enduser, enduserdevicemap,device…

Flex 3 Licenses

Flex license is still a confusing topic for may of us . Question like, How to compare with old license, Which license are included with NU, Which license to choose when selecting a 78XX phone model , what are the benefits of each license type etc.. Today blog is all about the Flex 3 license….