CUCM license automated report

[bgardner]

Any way to cause a license report to be generated automatically on a regular basis?  And emailed?

Are there CLI options for retrieving the data shown in the CUCM admin License Usage report?

Regards,

[Manish Gogna]

Hi,

There is no such automated report available on cucm.

Assuming you are running a cucm 9.x or higher version you can use the following CLI queries

admin:run sql select * from LicensingResourceUsage

admin:run sql select * from typelicensedresource

admin:run sql select * from typelicensedresourceproductmap

[bgardner]

Manish-

Thank you for your response.  I was able to access the CLI and run those commands.  I'm having trouble interpreting the output.  Do you know of any materials online that I can use to decipher the output?

Regards,

Brent Gardner

[bgardner]

I found this query which has almost everything I need:

admin:run sql SELECT name,value FROM TABLE (FUNCTION LicenseTotals()) (pkid,name,value,UserValue,DeviceValue)

It appears to produce a count of licenses currently in use.  Anyone know how I can get the count of licenses that are installed?

[Deepak Rawat]

Refer to below link in order to understand License Calculation in CUCM 9.x and above:

http://www.cisco.com/c/en/us/support/docs/unified-communications/unified-communications-manager-callmanager/117600-technote-cucm-00.html#anc6

Regards

Deepak