License Use

<< Click to Display Table of Contents >>

License Use

Report Name: License Use (122860)

 

Report Type: Standard Report

 

Description: The report allows users to investigate license use in detail or in a summary. If a license database is used, the license use is saved in the license database rather than the registered databases. Under this case, calculations of license uses are based on the data in the license database.

 

There are ten report type options to investigate license use from different angles. All of the Report Types cover Professional licensing. Four of the ten types also include Enterprise licensing: Summary by User, Summary by LicenseTitle, Summary of Issued Licenses, and Details. The table below explains each.

 

Report Type

"Counts" Column Output

EQuIS Products

Summary by User

Total number of license_checked_out per user and license title in the selected date range for Professional;

one license per user for Enterprise if the license was checked out within the selected date range - see Notes.

Professional and Enterprise

Summary by Day

The number of uses on a certain day based on license_checked_out records in the selected date range for Professional.

Professional

Summary by Hour

The number of uses at a certain hour based on license_checked_out records created in the selected date range for Professional; the report excludes hours during which no new license was checked out.

Professional

Summary by LicenseTitle

The number of recorded license_checked_out per license_title in the selected date range for Professional;

the number of active users per license_title that was checked out within the selected date range for Enterprise

Professional and Enterprise

Summary by LicenseTitle-Day

The number of uses per day by license_title, based on license_checked_out records in the selected data range for Professional.  

Professional

Summary by LicenseTitle-Hour

The number of uses per day and hour by license_title, based on license_checked_out records in the selected date range for Professional.

Professional

 

Report Type

Output Description

EQuIS Products

Last Use Date

The most recent license_check_out per license_title for Professional.

Professional

Last Use Date by User

The most recent license_check_out per user and license_title for Professional.

Professional

Summary of Issued Licenses

The number of all licenses by title.

All

Details

user_name, license_title, license_check_out and license_expires details from ST_LICENSE_USE in the selected date for Professional and Enterprise

Professional and Enterprise

 

Notes:

Only administrators can run this report.

For Enterprise 6 licenses in Summary by User or Summary by LicenseTitle, active user accounts consume a license whether or not currently logged in. Therefore, as long as a user has an active Enterprise account per license title or type checked out in a selected date range, the count for that user is always one. For example, when the user John with EQuIS Enterprise - Silver license used Enterprise in 1/1/2016-2/1/2016, the Count is one in the date range, though John logged in Enterprise on 1/2 and also on 1/20 if his license is still valid in the selected date range. The count also remains one whether or not the license expired and was renewed, creating a new record in ST_LICENSE_USE. Active means that the License has not yet expired.
For Professional licenses, users consume a license when they are logged into the application. Therefore the Professional count indicates application usage, rather than simply an active user. For example, if the date range is 1/1-1/30 and John logged in to Professional on 1/2 and on 1/20, the Count for user John is two.

When ST_LICENSE.LICENSE_TITLE is not populated, the license_title output is populated with General License: app_id (from ST_LICENSE_USE). Note this also applies if historic ST_LICENSE records are deleted.

The report does not include how much time a license is used, since this information is not precisely recorded in the EQuIS Database.

For Unlimited Enterprise licensing, the Number of Licenses column is left blank and "Unlimited licenses" is populated in the Remark column.

For all Report Types except Summary of Issued Licenses, the Database_Server column provides the server of the license database, which may differ from the user database if a separate license database is used to store licensing.

For Summary by User type Enterprise license users should have counts = 1. Except if there are two separate and distinct users, who have the same user_name, you can have multiple values (image below).

 

30206-Distinct-Users

 

Report Dependencies: There are no dependencies for this report.

 

File Name: EarthSoft.Reports.Library.122860.dll

 

Language: English

 

Input Parameters: A selection made to customize the output of a report.

 

Input Parameters

Input Parameter Screenshot

Output Columns

Date Range



Start Date


End Date

Report Type



Summary by User


Summary by Day


Summary by Hour


Summary by LicenseTitle


Summary by LicenseTitle-Day


Summary by LicenseTitle-Hour


Details

                                               

30206-input_params

Columns are different based on
a selection of Report Type.

 

Tables: ST_LICENSE_USE, ST_LICENSE, ST_LICENSED_DATABASE, ST_USER

 

Database Type: SQL

 

Database Schema: Standard (no custom or add-on schemas required)

 

Database Version: EQuIS Version 6.6+

 

Data Requirements: N/A

 

Report Requirements: Only DLS or ALS administrators are able to run the report.

 

Output Type: IGrid

 

Revision History: In Version 7.0.0, the revisions below have been completed.

1.If a database is registered in a license database, the License Use Report calculates its license uses from itself rather than the license database in the report of v6.6.0. Based on the fact that license use is always saved in the license database and not in any of the registered databases, the report is modified so that it calculates license use from the license database when a license database is used. In addition, it is not meaningful to calculate license use of Enterprise recorded in ST_RECENT, so it was removed from the modified report (Case 138774).

 

Example Output: View the following examples.

 

1.Report Type = Summary by User - the number of times a license is used by a user during the selected date range.

 

30206-output1_zoom79

 

2.Report Type = Summary by LicenseTitle-Hour - the number of times a license is used at a certain hour of a day.

 

30206-output2

 

3.Report Type = Summary by LicenseTitle - the number of times a license is used in the selected date range.

 

30206-output3
 

4.Report Type = Summary by Day - the number of times a license is used on a certain day of the selected date range. Note the chart is not part of the report, but is created using the XY Chart tool in Professional.

 

30206-output4_zoom45

 

5.Report Type = Summary of Issued Licenses - the title and number of licenses in a login database or licensed databases.

 

30206-output5_zoom73