PyATS Installation

Python Automated Test System(pyATS) is a python based test automation. Its organically developed by internal Cisco Engineers and made public on 2017 through devnet. I use pipenv to create isolated Python environments. Pipenv is a combination of both PIP and virtualenv. Most popular tools to isolate python environment is virtualenv. Use the tool comfortable for…

New Webex devices announced during Webexone 2021

Some cool devices has been announced on webex one 2021. For those who missed Webex one, watch the Keynotes from below link. Keynotes from day 1 https://www.youtube.com/watch?v=Rd3j6qAKmeY Keynotes from Day 2 https://www.youtube.com/watch?v=x_4zen_dozw Webex Desk Mini Explore webex Mini from https://hardware.webex.com/products/desk-mini Bang & Olufsen Cisco 980 Explore Cisco 980 from https://hardware.webex.com/products/cisco-headset-980 Webex Board Pro Explore Webex…

Webex Ideas

If you ever thought of an option to submit some cool ideas which you like to see on Webex or if you have a feedback about webex, there is a portal from cisco to submit this. User Community Feedback you can access the portal from https://ciscocollabcustomer.ideas.aha.io. Submitted ideas will be evaluated by Cisco’s product teams…

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…

Show tech-support confidential

Have you ever thought of hiding sensitive information’s when sharing a show tech files? Form Cisco IOS XE Amsterdam 17.3.x with show tech-support, Cisco introduced a keyword confidential which hide sensitive information.. show tech-support confidential : The confidential keyword was introduced, to mask sensitive information in the output of show tech-support command When using show…

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…