SQL Query Callmanager Publishers for licence reporting
I hope somebody can help me with this. I would like to make a SQL Query on the Callmanager Publishers for the fields "Device Name", "UserID 1" and "Owner User ID". I found already the fields "Owner User ID" and "Device Name" with:
SELECT device.name, enduser.userid FROM device LEFT JOIN enduser ON device.fkenduser = enduser.pkid
But now I struggle a lot to find the last field "UserID 1" in this table and DB jungle.
To make a usable licence reporting per user on our CUCM I need this two user fields.
Mabye somebody can help me out to find this field.
Greetings, Wanted to share a few lessons learned while migrating from a distributed to centralized IMP deployment. Our current setup included many CUCM/IMP distributed clusters with centralized Expressway server for MRA login. We did not wish to perf...
Parsec's Cisco UCCE/PCCE CC Connector application for CRM works as a bridge between the CRM and Cisco UCCE/PCCE CC solution.The CRM can be any cloud based CRM like Salesforce (SFDC), ServiceNow ,MS Dynamics or a 3rd party CRM.The CRM user/Agent will have ...
It’s a feature which allows CUCM to determine whether the phone is in its home location or a roaming station.By enabling this feature users can roam from one site to another site and acquire the site-specific settings such as Codecs, MRGL, Call rout...
Cisco just Announced their new Collaboration Toolbox resources portal. You can check it out here https://collabtoolbox.cisco.com/ It has a bunch of tools a partner can find helpful. But if your interested in learning which...