1. Sql Database For Mac
2. Sql Query For Database Size

Mar 12, 2012 - The third query in my series on CUCM SQL queries provides a simple but effective query. SEPDEADBEEF0003 Bria on Mac +4.

Sql Database For Mac

Introduction This document provides Structured Query Language (SQL) queries that can be run in the CLI in order to get the device information associated with an application user. Prerequisites Requirements Cisco recommends that you have knowledge of Cisco Unified Communications Manager (CUCM).

There is a possibility that you may sustain a loss equal to or greater than your entire investment. You should ensure you understand all of the risks. Therefore, you should not invest or risk money that you cannot afford to lose. Free download mt4 platform.

Components Used The information in this document is based on CUCM Version 8.X and later, but might work for earlier versions. Tables The SQL queries are formed with the use of data from these tables:. Device - This table contains device level information such as IP phones, gateways, and so on. NumPlan - This table contains information about all patterns configured in CUCM. DeviceNumPlanMap - This table contains the mapping between data in the Device table and the NumPlan table. RoutePartition - This table contains the information about all partitions configured in CUCM. ApplicationUser - This table contains information about application users.

Sql Query For Database Size

ApplicationUserDeviceMap - This table contains the mapping between data in ApplicationUser table and Device table. DirGroup - This table contains information about Permission Groups. ApplicationUserDirGroupMap - This table contains the mapping between data in ApplicationUser table and DirGroup table. More information about these tables can be found in the for the respective version. SQL Queries For clarity, the queries are written to find one association at a time.