SQL Query for ELM/PLM licenses Required, Installed and Available
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.
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.
The short answer is that you don't.... That isn't entirely true while at
the same time it kind of is, but for the most part you don't configure
the softkeys. You enable or disable them via TCL. Here is the long
answer. Be sure to read the whole thing or e...
Topology: IP Phone > Switches > Microsoft NPS setup to forward 802.1x
proxy to > ISE 2.1 patch 3 Authentication: EAP-TLS using Cisco MIC SANs
Phone Models 802.1X support? 802.1x flavor Addtl Comment EAP-MD5 EAP-TLS
Cisco 3905 Y Y N Cisco 6911 Y Y N Cisco ...
This document describe how DST changes and how time changes are
implemented in DST. Daylight Saving Time (DST) is the practice of
setting the clocks forward 1 hour from standard time during the summer
months, and back again in the fall, in order to make b...