PMO Reports: User License and Activity

ccppmop158
The User License and Activity report displays the license type and usage frequency of each resource. The report also shows general resource information. The report can be grouped by several different options, including No Grouping, Resource Manager, Primary Role, Employment Type, License Type, Usage Frequency, and OBS Level. The columns that display in the report are based on the grouping option selected. The user count by license type pie chart displays the number and percentage of users, grouped by license type. The user count by last login date pie chart displays the number and percentage of users, grouped by usage frequency. The following image displays the User License and Activity report with resource license details.
Image displaying the User License and Activity report with resource license details.
This report allows you to drill down to the User License and Activity Detail report by clicking a resource name. The Detail report allows you to see the resource access rights that contribute to each license type.
The following image shows the User License and Activity Details report with access right details.
Report Prerequisites
Verify that you have completed the following prerequisite before you run this report:
  • The user must have a status of "Active" to display in the report. Users with a status of "Inactive" or "Lock" do not display in the report even if the active flag on the resource is checked.
Report Properties
The following values list the report properties:
Name:
User License and Activity
Image displaying the User License and Activity Details report with access right details.
Resource ID:
CSK_USR_LicenseActivity
Description:
Administration (PMO Accelerator)
Folder:
CA PPM/Reports/Administration/User License and Activity
Path:
/ca_ppm/reports/administration/CSK_USR_LicenseActivity
Data Source:
CA PPM Bean Data Source
Report Parameter Options
The following table lists the report parameter options.
Prompt Text
Parameter Name
Type
Input Control Name
Input Control Resource ID
Mandatory
Default Value
Resource OBS Type
resourceOBSTypeKeyRequired
Single-select
Query
Resource OBS Type
resourceOBSTypeKeyRequired
Yes
Resource OBS Unit
resourceOBSUnitKeyRequired
Single-select
Query
Resource OBS Unit
resourceOBSUnitKeyRequired
Yes
Resource Manager
resourceManagerKey_1
Multiple-select
Query
Resource Manager
resourceManagerKey_1
No
Primary Role
primaryRoleKey_1
Multiple-select
Query
Primary Role
primaryRoleKey_1
No
Resource
resourceKey_1
Multiple-select
Query
Resource
resourceKey_1
No
Employment Type
employmentTypeKey_1
Multiple-select
Query
Employment Type
employmentTypeKey_1
No
License Type
licenseType
Multiple-select
Query
License Type
licenseType
Yes
Full, Restricted, View Only
Usage Frequency
usageFrequency
Multiple-select
Query
Usage Frequency
usageFrequency
Yes
Below 30 Days, Between 30 and 60 Days, More than 60 Days, Not Logged In
Sort By
sortLastLoginResource
Single-select
List of Values
Sort By
sortLastLoginResource
Yes
Last Login Date
Group By
groupResManagerLicenseUsageOBS
Single-select
List of Values
Group By
groupResManagerLicenseUsageOBS
Yes
License Type
Show Graphs?
showGraphs
Boolean
Show Graphs?
showGraphs
No
Checked
Database Schema
ppmDBSchema
Hidden
Not applicable
Yes
Passed through
Clarity PPM
UI Theme
ppmUserUITheme
Hidden
Not applicable
Yes
Passed through
Clarity PPM
Language
ppmUserLanguage
Hidden
Not applicable
Yes
Passed through
Clarity PPM
User ID
ppmUser
Hidden
Not applicable
Yes
Passed through
Clarity PPM
Parameter Lookup Values
The following values list the lookup values:
Employment Type:
Contractor, Employee
License Type:
Manager (Unrestricted), Team Member (Restricted), Viewer
Usage Frequency:
Below 30 Days, Between 30 and 60 Days, More than 60 Days, Not Logged In
Sort By:
Last Login Date, Resource
Group By:
No Grouping, Resource Manager, Primary Role, Employment Type, License Type, Usage Frequency, OBS Level 1-10
Parameter Explanations
The following list describes the parameters:
  • The Resource OBS Type is a cascading parameter that determines which units are listed in the Resource OBS Unit parameter. This parameter does not directly control which resources display in the report.
  • The Resource OBS Unit parameter displays values that are based on the Resource OBS Type selected. When you select an OBS unit in this parameter, the report displays the resources that are attached to the OBS unit and descendants of the unit you select.
  • The License Type parameter allows you to select which type of license to include in the report. The following options are available:
    Full
    –The report displays resources with the full license type based on the access rights that are granted through the resource, group, or resource OBS unit.
    Restricted
    –The report displays resources with the restricted license type based on the access rights that are granted through the resource, group, or resource OBS unit.
    View
    –The report displays resources with the view only license type based on the access rights that are granted through the resource, group, or resource OBS unit.
  • The Usage Frequency parameter allows you to select the users to include in the report, based on the frequency they log into
    Clarity PPM
    . The following options are available:
    Below 30 Days
    –The report displays resources who have used their licenses during the last 30 days, based on the last login date.
    Between 30 and 60 Days
    –The report displays resources who have not used their licenses for more than 30 days, but have accessed the system during the last 60 days, based on the last login date.
    More than 60 Days
    –The report displays resources who have not used their licenses for more than 60 days, based on the last login date.
    Not Logged In
    –The report displays resources that have never used their licenses, based on the last login date.
  • The report has a Sort By parameter that allows you to control how the report is sorted. The following sort options are available:
    Last Login Date
    –This option sorts the report by the last login date, in descending order, within the report grouping. The users who have not logged in to
    Clarity PPM
    sort to the top because they do not have a last login date. 
    Resource
    –This option sorts the report by the resource name, in ascending order, within the report grouping.
  • The report has a Group By parameter that allows you to control how the report is grouped. The following group options are available:
    No Grouping
    –This option does not group the report, so you should select this value if you do not want to do a grouping for one of the group by options.
    Resource Manager
    –This option groups the report by resource manager. 
    Primary Role
    –This option groups the report by the resource primary role.
    Employment Type
    –This option groups the report by the employment type. The values for employment type are: Contractor and Employee. 
    License Type
    –This option groups the report by license type. The values for license type are: Manager (Unrestricted), Team Member (Restricted), and Viewer. 
    Usage Frequency
    –This option groups the report by usage frequency. The values for usage frequency are: Below 30 Days, Between 30 and 60 Days, More than 60 Days, Not Logged In.
    OBS Level 1-10
    –This option requires that you select a unit in the resource OBS parameter to group by an OBS level. The resource OBS parameter and grouping by an OBS level work with one another. The resource OBS parameter determines which OBS you group by when you select a group by level. You can group by any OBS level from 1 to 10, which is the maximum number of levels for an OBS supported in
    Clarity PPM
    .  OBS level 1 is the top level in the hierarchy and OBS level 10 is bottom level in the hierarchy.  When you group by an OBS level, the resources that are attached to OBS units at the level you select and any units below the level you select are rolled up to the group by level of the report.
    If you group by an OBS level that is lower in the hierarchy, then the report groups the resources by this level (for example, OBS Level 4). If resources are associated to units above level 4 (for example, resources are attached to levels 2 and 3), then the resources that are associated to units higher in the hierarchy display in the report in an Undefined grouping. The Undefined grouping indicates that there is no OBS unit defined for the resource at the level by which you are grouping.
    If you group by an OBS level but you do not select a unit in the resource OBS parameter, then the report returns results; however, it does not group by an OBS level because it relies on the resource OBS parameter to determine which OBS to use for grouping.
  • The Show Graphs parameter controls whether the user count by license type and the user count by last login date pie charts display on the report. If the parameter is checked, the charts display on the first page of the report.
Report Fields and Calculations
If the report is not grouped, then the report displays the following columns: resource name, resource ID, user name, resource manager, primary role, employment type, license type, usage frequency, and last login date. If the report is grouped, then the report displays the same columns excluding the column that is selected as the grouping option. When the show graph parameter is checked, the report also displays two pie charts. The user count by license type pie chart displays the number and percentage of users, grouped by license type. The user count by last login date pie chart displays the number and percentage of users, grouped by usage frequency. The usage frequency categories are: below 30 days, between 30 and 60 days, more than 60 days, and not logged in.
The report displays license types based on the current
Clarity PPM
license model, which includes Full, Restricted, and View Only. The license types in the report are based on an input control that gets created when importing the Jaspersoft Advanced Reporting content. This input control has three values: Full, Restricted, and View Only. All
Clarity PPM
access rights are associated with a license type value. License types determine the level of license that is associated with users. Access rights determine the license type that is assigned to each user. If users have access rights for multiple license types, these users are assigned the highest license type. Users with a status of "Active" are included. Users with a status of "Inactive" or "Lock" are excluded. Resources only are included; roles are excluded.
Report Security
Security is determined by resource view rights.