We are in need of cross referencing or somehow consolidating our End User fields (user ID, Controlled Devices, and Primary Extension) with our phone DN fields (Directory Number, Associated Devices, and Line Text Label). I'm thinking the best way to go about this is through a SQL query but I'm just not familiar enough with the syntax or the CUCM database schema to get anything useful. There are a number of reasons we want this information:
1. We sync with LDAP and want to be sure that the Line Text Label field not only exists but also matches the LDAP synced User ID field.
2. Some end users have physical phones however do not have them assigned under Controlled Devices in End User configuration.
3. Some end users do not have the Primary Extension assigned to them under End User configuration or it is incorrect.
4. We want to verify that the Telephone Number field pulled from LDAP matches up with the users actual DN.
You should be able to find what you need using the Bulk Administration Export within CUCM. This has the capability of exporting nearly every configuration item within CUCM to a .csv files. Keep in mind that large exports, such as Devices, can take 12 or more hours for larger clusters.