Solved: SQL Query for ELM/PLM licenses Required, Installed and Available

dgauthier · ‎10-09-2014

Support Forum,

I have been writing test SQL queries against the 'licensingresourceusage' and 'licenseserver' from the UCM Data Dictionary 10.0 and have not come across a method to retrieve total licenses, either 'Required', 'Installed' or 'Available' in ELM/PLM.

I have retrieved licenses allocated to an enduser e.g. tin, copper, bronze, etc. But I cannot find the overall license summary.

Does the ELM/PLM run a separate dB with no SQL access? or I am not using the correct command syntax for the given tables in the UCM 10.0 Data Dictionary.

Any suggestions would be greatly appreciated. Thanks.

Aman Soi · ‎10-09-2014

Hi,

check this link for license calculation using SQL queries

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

regds,

aman

View solution in original post

Aman Soi · ‎10-09-2014

Hi,

check this link for license calculation using SQL queries

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

regds,

aman

dgauthier · ‎10-09-2014

aman,

this is a great article. Many of the SQL queries I have done are included with this doc. I was definitely on the right track. I have no digested all of the doc...but from initial scan it seems right on track. I appreciate the assistance.

David