PMO Reports: User License and Activity Detail

ccppmop1561
The User License and Activity Detail report displays all of the access rights granted to a resource. The access rights may be granted directly to the resource, through a group, or through a resource OBS. The access rights include global, instance, and OBS unit rights. The report also displays participant rights that are granted through the project.
The following image shows a User License and Activity Detail report example:
Image displaying the User License and Activity Detail report with resource access rights details.
Report Prerequisites
Complete the following prerequisites before you run this report:
  • The user must have a status of
    Active
    to appear in the report. Users with a status of
    Inactive
    or
    Lock
    do not appear in the report even if the
    active
    flag on the resource is checked.
  • Global access rights display in the report if the user is granted at least one global access right directly, through a group, or through a resource OBS unit used for access rights.
  • Instance access rights display in the report if the user is granted at least one instance access right directly, through a group, or through a resource OBS unit used for access rights.
  • OBS Unit access rights display in the report if the user is granted at least one OBS unit access right directly, through a group, or through a resource OBS unit used for access rights.
Report Properties
The following values list the report properties:
Name:
User License and Activity Detail
Resource ID:
CSK_USR_LicenseActivityDetail
Description:
Administration (PMO Accelerator)
Folder:
CA PPM/Reports/Administration/User License and Activity Detail
Path:
/ca_ppm/reports/administration/CSK_USR_LicenseActivityDetail
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
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
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 based on the Resource OBS Type selected. When you select an OBS unit in this parameter, the report displays the resources 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 granted through the resource, group, or resource OBS unit.
    Restricted
    : The report displays resources with the restricted license type based on the access rights 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 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. 
Report Fields and Calculations
The report is grouped by resource and displays all access rights that are granted to each resource. The columns include: access right name, access right type, access right to OBS unit, granted through type, granted through, and access right description. 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.
This report contains the following columns:
Access Right To OBS Unit
: This column displays data if the Access Right Type is "OBS Unit". In this case, the column displays the OBS Type and Unit to which the user has access for the access right.
Granted Through Type
: This column displays how the access right is granted. The options include:
Resource
: The access right is assigned directly to the user.
Group
: The access right is assigned to a group and the resource belongs to the group.
OBS Unit
: The access right is assigned to a resource OBS unit and, depending on the OBS association mode, the resource is associated to the unit, an ancestor unit, or a descendant unit. The resource OBS must have the option set for "Used for Access Rights" (
Administration/Organization and Access/OBS
). If this option is checked, then the OBS units display an "Access Rights for this Unit" tab where you can assign rights to the OBS unit. Any resources belonging to the unit receive these rights, depending on the OBS association mode.
Granted Through
: This column displays the specific resource, group, or OBS unit through which the access right is granted.
Granted Trough Type Granted Through
Resource
: The resource name displays.
Group
: The group name displays.
OBS Unit
: The OBS type and unit name display.
Report Security
Security is determined by resource view rights.