Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
VIP Purple

Hi, check this link for

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

2 REPLIES
VIP Purple

Hi, check this link for

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

New Member

aman,this is a great article.

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

204
Views
0
Helpful
2
Replies
CreatePlease login to create content