need sql query to extract license parameters from cisco unity10.x

[manilagoel]

Hello,

Using a AXL soapRequest <executeSQLQuery> to
extract the licensing information from CUCM, CUPS and CUC version 10.0

Required licensing details for CUC (like
CUC_BasicMessaging, CUC_SpeechConnectPort, CUC_SpeechView, CUC_SpeechViewPro ) and Presence(ALL license types).

So, need a sql query to extract the above licensing information from the respective devices.

Tried cisco LCU tool but it does not provide license parameters for CUC as SQL Query used does have CUC parameters.

Is there any way (any vbscript) to extract license information programmatically?

Is Cisco Unity Supports AXL service?

-Manila

[Geevarghese Cheria · Accepted solution]

Hi Manila,

I think AXL does not support CUC.  Cisco Unity Connection includes several Representational State Transfer (REST) application programming interfaces (APIs) that provide provisioning, messaging, and telephony access to Connection. These APIs provide the ability to integrate Connection features into existing enterprise-wide provisioning management systems and messaging clients. The APIs are REST interfaces that standardize operations such as add, delete, view, and modify.

Please Refer - Cisco Unity Connection APIs - DocWiki

You may also refer this document  SQL Cisco Unity Connection? for related information

Thanks and Regards,

Geevarghese

[manilagoel]

Hey Geevarghese,

Thanks for the reply its very useful.

I have used the below link to extract information for the licenses used:

Cisco Unity Connection Provisioning Interface (CUPI) API -- License Dump APIs - DocWiki

But I also require the information regarding Total licenses or Free Licenses.

Is there any REST API available for the same??

Thanks & Regards,

Manila

[Geevarghese Cheria]

Hi Manila,

From Version9 of Unity Connection licensing is managed centrally via the Enterprise Licensing Manager service. There is no API to have  programmatic query/management of ELM data.

Reference- https://communities.cisco.com/thread/41608

Thanks and Regards,

Geevarghese