there are two options here to extract your/a report, aside from doing it manually via cut&paste from the SCORM Basic Report:
- Work with raw data (mdl_scorm_scoes_track, for the tracking, and mdl_scorm_scoes and mdl_scorm for respectively SCORM course SCOes and SCORM activity) via a plug-in to facilitate data extraction given a plain SQL query like https://moodle.org/plugins/report_customsql which is able to provide a view of the data gathered by the SQL query and give you the facility to download that data via CSV too, which is easily importable by Excel-like programs
- Create your own report with new code (https://docs.moodle.org/dev/SCORM_reports), which requires the comprehension of the issues above, so my suggestion is to play with the first proposal
How to play with a raw SQL query?
You should be familiar with SQL first and the way Moodle stores the SCORM data then you can easily play with the tables above e.g. you can start playing with https://docs.moodle.org/35/en/ad-hoc_contributed_reports#Lists_All_completed_SCORM_activites_by_Course_name or https://docs.moodle.org/35/en/ad-hoc_contributed_reports#Lists_SCORM_status_for_all_enrolled_users_by_Course_name since they should do most of the work unless some missing fields and different logic, the first limited to those who have completed the SCO and the second giving you the full list of users including those having never attempted to a SCO.
You cannot find in Moodle a report like yours since it requires to define some strong constraints e.g. the whole of my SCORM packages are single-SCO based or I do not require an overall status of the SCORM course in case of multi-SCO based but SCO by SCO and so on which cannot be defined unless in a specific Moodle instance (!).
To tell the truth, Moodle could have more SCORM reports which the administrator could activate based on site wide constraints or automagically defined on a SCORM activity basis: it requires funding and no one 'till now looks like have ever funded those site-wide reports within the core code but the ones already there and the wonderful plug-in above, including those queries shared by the Community in the WIki above.
For the convenience of other English readers the columns in the wanted report are more or less the ones of the Basic Report, here extended for the enrolled users to any SCORM activity:
- Full name (First name / Surname)
- Email address
- Started on
- Last accessed on
- SCO Title
Thanks Matteo for your detailed reply!
I'd like to know just one more thing.
According to you is it possible to get this result through a new plug-in (or editing a an existing one), or is it necessary to edit default database code?
Do you know a SQL expert who can face our need, even creating a plug-in for us?
If you can sort it out to a SQL query, you can set it up as a report using the configurable reports block plugin.
We use it for several custom reports and you can setup permissions so that it is only shown to certain access levels.
https://moodle.org/plugins/block_configurable_reports is almost the same as https://moodle.org/plugins/report_customsql with some differences: IMHO the most relevant - but techie - is that the latter is more "active" in terms of latest commits (Jul 3, 2017 vs May 9, 2018).