CC6 License Use Reports 1

[captaingadget]

I have a client with 4 networked CC6 contact centres. Is there any simple/quick way of reporting on the use of the licenses? By this I mean how close have they come to exhausting the license pool.

If there is not a quick/easy way, is there a slow and difficult way?

 

[DancingDave]

Are the sites licenses separately (nodal) or using a common (corporate) license file?

Regardless, the short answer is 'yes'

The long answer is...

From the NTP for CCMS

"The License Manager is installed on the same server as Contact Center Manager
Server. It uses the Contact Center Manager Server database to store the
historical statistics that it records for the maximum number of licenses that are
issued in an interval, day, week, and month.
This option is the most commonly used. It covers both the Node server and the
Network Control Center (NCC) server.
For nodal installations, the NCC requests its license from one of the nodal
servers. When you set up the NCC server, ensure that the correct Contact Center
Manager Server package is selected as the server that holds the required license.
For Corporate installations, Nortel recommends that the NCC is used as the
primary license manager."


The license manager produces historical stats

From the same NTP
"Historical reporting data is produced by the License Manager to support the
analysis and management of concurrent license usage in the network. Historical
data is available in intervals (15 minute) on a daily, weekly, or monthly basis.
License utilization is reported on a per-client basis, with the IP address of the
client used to denote individual clients.
The License Manager reports the following statistics:
?? Timestamp – Time the data is written to the database.
?? IP Address – The IP address of the Contact Center Manager Server,
Contact Center Manager Administration, Contact Center Multimedia, and
Communication Control Toolkit.
?? License identifier – The name of the license.
?? Maximum allocation during interval – Maximum number of licenses
allocated to the server during the 15-minute interval.
Note: If a interval has 10 licenses issued for a feature, then 10 is written to the
database table. If, in the next interval, there are another 5 license issued, then for
this interval 15 is written to the database table. However, at the end of the
interval, if only 14 licenses were issued, but 15 were issued at some stage during
the interval, then a value of 15 is written to the database.
The data is written to the database on the server on which you installed the
License Manger for each 15-minute interval. These statistics are consolidated
daily, weekly, and monthly.
The License Manager reports any errors in writing data to the database.
The data is stored on a site-by-site basis where the site identifier is the IP address
of the server.

A report template is available allowing reports to be generated using this
statistical information. The data is available from the following database views:
?? iLicenseStat — interval statistics
?? dLicenseStat — daily statistics
?? wLicenseStat — weekly statistics
?? mLicenseStat — monthly statistics"


DD

 

[captaingadget]

Great stuff DD thanks.

 

[captaingadget]

Thanks DD for your help on this, I was hoping this task would go away but it hasn't so I have another question as I can't seem to find out much about it.

Are you saying that there should be some canned reports available to get these stats out 'cos I can't find any, or are you suggesting that I need to write a customised Crystal report or something?

Do I need to set anything up to get this stuff written to the datatbase in the first place. As you may have gathered I'm completely clueless on this subject.

 

[DancingDave]

CaptainGadget, I did some checking with our supplier and it turns out that there isn't a facility to run reports after all.

It's being taken up with Nortel (and sponsored by our supplier) to get functionality added in a future release. I'll post back on a new thread if anything comes of this

DD