Provides a full list of assets in the site, including details about the library structure. Only includes assets to which the company is entitled. Results are not limited by the privileges assigned to the Administrator running the report.
Note: In some instances, Book assets may not include a valid path.
Description: Provides the ability to select all or specific asset categories and sub-categories.
Categories and sub-categories can be selected independently of each other.
Selecting an asset category will include all sub-categories for that value.
You can also select sub-categories individually.
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: See the tables below for a list of sub-categories available for each category. There are no sub-categories for the Instructor Led Training or Video categories.
Default Value: All available, except JobAids and SkillBriefs
Note: “6 English (All)” applies only to Book and Video assets. If you filter the template to only “English (All)”, you will only see books and videos in your report. If you want to see all US English assets, filter for both “6 English (All)” and “8 English”.
Description: Allows the user to select one event and then filter that event by date.
Control Type: Single-select
BCS Parameter: date_filter_field
Possible Values: published_date
Static Dates
To enter static dates, use the following parameters with a specific date for the filter_start_date and filter_end_date parameters:
BCS Parameter: filter_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: filter_end_date (optional)
Possible Values: <date_value in the format MM/DD/YYYY>
Default Value: 'now', or the last successful database refresh
Note: Default start and end dates will only be used if a date_filter_field value is entered and the date values are left blank. In this instance, the date values are dynamic and will update each time the report is run.
Dynamic Dates
For dynamic dates that change each time the report is run, use the following parameters:
BCS Parameter: filter_date_period (required)
Possible Values: 1 (Days), 2 (Weeks), 3 (Months), 4 (Years)
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
Filter to Date
If you are using filter_date periods, filter_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 filter_to_date=false, the report will only include activity for the requested periods.
BCS Parameter: filter_to_date (optional)
Possible Values: true or false
Default Value: true
Example:
If filter_to_date = true, the end date is always the date the report is run, up to and including the most recent database refresh.
If filter_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.
Description: For courses, this is the expected duration of the asset. For videos, audio books, and recorded sessions, this is the actual run time. Displayed in hh:mm format for Previewed reports, and reports exported to PDF and HTML. Displayed in minutes for reports exported to CSV and Excel.
Asset Type