Access Detailed by User
Displays details, by user and asset, for every content access, including source and device type.
BCS Report Parameter: platform_access_detailed_by_user
Filter Controls
Asset
- Description: Provides the ability to select one, many, or all assets in the filter criteria.
- Control Type: Multi-select list
- BCS Parameter: asset_list
- Possible Values: CSV list of <any_asset_id> values
- Default Value: All available
Asset Category
- Description: Provides the ability to select all or specific asset categories.
- Control Type: Multi-select
- BCS Parameter: asset_category
- Possible Values: 1 (Books), 2 (Courses), 3 (Custom Content), 4 (Instructor Led Training), 5 (Learning Portals), 6 (Resources), 21 (Videos)
- Default Value: All available
- BCS Parameter: asset_subcategory
- Possible Values: 1 (Journals), 3 (Summaries), 4 (BluePrints), 6 (Reports), 9 (Recorded Sessions), 10 (Newsletters), 11 (Audio Books), 12 (Books), 13 (Book Section), 14 (Courses), 15 (Course Topic), 16 (Learning Program), 17 (Live Learning), 18 (Simulations), 19 (KnowledgeCenters), 20 (SkillSoft Advantage), 21 (Business Impact), 22 (Challenges), 23 (Express Guides), 24 (Job Aids), 25 (Learning Sparks), 26 (Mentoring), 27 (Practice Labs), 28 (Projects), 29 (SkillBriefs), 30 (Assessments), 31 (External Learning Objects), 32 (Learning Events), 35 (Business Exploration Series), 36 (Custom), 37 (Videocasts)
- Default Value: All available
Custom Filters
- Description: Provides the ability to filter on one or two fields that exist in the report definition. You can define either an AND or an OR statement when using two filters. The field selector drop-down will include all fields that are available in the report definition.
- Control Type: Logical filter
- BCS Parameter: you cannot specify custom filters when running this report via BCS
Device Type
- Description: Provides ability to select included Devices.
- Control Type: Multi-Select List
- BCS Parameter: device_type
- Possible Values: 0 (Other), 1 (PC), 2 (Tablet), 3 (Smartphone)
- Default Values: 1, 2, 3
Report Activity Date Range
- Description: Allows the user to determine the date range for all activity for the report.
- Control Type: Multi-option
Use the following parameters to set start and end dates.
- BCS Parameter: report_start_date (optional)
- Possible Values: <date_value in the format MM/DD/YYYY>
- Default Value: the first day of the preceding calendar month
- BCS Parameter: report_end_date (optional)
- Possible Values: <date_value in the format MM/DD/YYYY>
- Default Value: 'now', or the last successful database refresh
Use the following parameters to set dates for a number of previous intervals, such as, "previous 3 months."
- BCS Parameter: report_date_period (required)
- Possible Values: 1 (Days), 2 (Weeks), 3 (Months), 4 (Years)
- Default Value: 3
- BCS Parameter: report_date_period_count (required)
- Possible Values: valid numeric value with the following maximum value for each report_date_period:
Days - 9999
Weeks - 999
Months - 999
Years - 99
- Default Value: 1
- BCS Parameter: report_to_date (optional)
If you are using report_date periods, report_to_date=true will include all activity for the requested periods plus activity in the current period up to the current date and time. If report_to_date=false, the report will only include activity for the requested periods.
- Possible Values: true or false
- Default Value: true
- Example:
- If report_to_date = true, the end date is always the date the report is run, up to and including the most recent database refresh.
- If report_to_date = false, the end date is the last day of the previous interval. For instance, if today is December 31, the ‘Previous [n] Months’ ends on November 30 and the ‘Previous [n] Years’ ends on December 31 of the prior year.
- BCS Parameter: display_units (optional and used in chart templates only)
- Possible Values: 1 (Year), 2 (Quarter), 3 (Months), 4 (Weeks), 5 (Days)
- Default Value: 3
Select Subgroups
- Description: Provides the ability to include subgroups within the scope of the report.
- Control Type: Single-select check box
- BCS Parameter: select_subgroups
- Possible Values: 0 (don’t select), 1 (select)
- Default Value: Don't select
Source
- Description: Provides the ability to select included access sources.
- Control Type: Multi-Select List
- BCS Parameter: selector_source
- Possible Values: 0 (Other), 1 (Learning App), 2 (Skillport), 3 (OLSA), 4 (BCS), 5 (Learning Portal), 6 (SCM)
- Default Value: 1, 2
User/Group
- Description: Provides the ability to select one, many, or all users or groups as part of the filter criteria.
- Control Type: Multi-select
- BCS Parameter: user_list
- Possible Values: CSV list of <username> values
- Default Value: All
- BCS Parameter: group_list
User Profile
- Description: Provides the ability to filter data based on user profile fields that have been configured and enabled on the User Profile page.
- Control Type: Logical filter
- BCS Parameter: N/A
User Status
- Description: Provides the ability to specify user statuses.
- Control Type: Multi-select
- BCS Parameter: user_status
- Possible Values: 1 (activated), 2 (deactivated)
- Default Value: Activated
Display Options
Include Timestamps Selector
- Description: Includes timestamps in all date fields in the report.
- Control Type: Single-select check box
- BCS Parameter: show_date_with_time
- Possible Values: 0 (don’t show), 1 (show)
- Default Value: Show
Show Multi-Group Selector
- Description: Used to determine how records that contain field(s) that could have multiple values (such as a user that exists in multiple groups) present or stored the data in the report. If multiple rows are selected, a record will be provided for every instance.
- Control Type: Single-select
- BCS Parameter: show_multiple_groups
- Possible Values: 1 (multiple rows), 2 (single row)
- Default Value: Multiple rows
Time Zone
- Description: Provides a list of standard time zones so you can display the times in your local time zone. This does not affect the actual UTC time of the activity. Default value is UTC.
- Control Type: Single-select
- BCS Parameter: time_zone
- Possible Values: see BCS SubmitReport Time Zones for a list of acceptable values
- Default Value: GMT
Required Columns
Asset Title
- Description: The title of the asset.
- BCS Value: asset_title
Username
- Description: User's login name.
- BCS Value: skillport_username
Default Columns
Access Date
- Description: Date of content access.
- BCS Value: course_access_date
Asset ID
- Description: The ID of the learning asset, for example, COMM0101.
- BCS Value: asset_name
Asset Sub-type
- Description: The type of asset sub-category.
- BCS Value: asset_subcategory
Asset Type
- Description: The type of asset.
- BCS Value: asset_category
Device Type
- Description: Type of Device providing access.
- BCS Value: platform_device_type
First Name
- Description: The user's first name.
- BCS Value: user_first_name
Group Name
- Description: The name of the group.
- BCS Value: group_title
Group Org Code
- Description: The organization code associated with the group.
- BCS Value: group_orgcode
Last Name
- Description: The user's last name.
- BCS Value: user_last_name
Source Type
- Description: Source of platform access.
- BCS Value: platform_source_type
Optional Columns
Approval Manager First Name
- Description: The first name of the approval manager.
- BCS Value: cud_approval_manager_first_name
Approval Manager ID
- Description: The ID of the approval manager.
- BCS Value: cud_approval_manager_Skillport_name
Approval Manager Last Name
- Description: The last name of the approval manager.
- BCS Value: cud_approval_manager_last_name
Display First Name
- Description: The user's first name as it appears in Skillport.
- BCS Value: cud_display_first_name
Display Last Name
- Description: The user's last name as it appear in Skillport.
- BCS Value: cud_display_last_name
Email
- Description: The email address of the user.
- BCS Value: cud_user_email
Group Path
- Description: The path to the group's location based on the hierarchy configured in Skillport.
- BCS Value: group_path
Location
- Description: The user's geographic location (for example, where the user's office or branch is located).
- BCS Value: cud_location
User ID
- Description: The numeric SkillPort user ID.
- BCS Value: skillport_user_id
User Role
- Description: The user's SkillPort role: Super Administrator, Company Administrator, Company Administrator-Custom, Administrator, Administrator-Custom, Manager, Manager-Custom, and End-User.
- BCS Value: user_role
User Status
- Description: The user's status: Activated, Deactivated, or Pending.
- BCS Value: user_status
|