Hi all.
I am performing a 'content audit' before we move to a new platform to see what needs to be migrated and what can be archived as it has not been used/accessed in some time.
Is there a report or log that lists the files and modules that are used within each course. I don't have ready access to SQL so ideally something already available in the system would be most helpful.
Thank you.
Just moving your post to the Analytics and reporting forum where you'll hopefully get more specialised help 
Are you on Moodle 4.+? Report Builder module, in Site Admin>Reports menu has some of the items you seek. But maybe not everything.
Kind Regards
Kind Regards
Hi Shirley.
Open LMS EDU 4.1 MP4 (Build: 20240208)
I have tried looking into Reports and Logs and while I can extract course details and a complete list of files within our system I can't find anything that provides the name of the course to which a file is linked.
Hope that makes sense.
Open LMS EDU 4.1 MP4 (Build: 20240208)
I have tried looking into Reports and Logs and while I can extract course details and a complete list of files within our system I can't find anything that provides the name of the course to which a file is linked.
Hope that makes sense.
Moodle files can be used in multiple courses.
They are owned by a user.
mysql -u $mddbuser -p$mddbpass -e "use $mddbname;select id,userid,contenthash,filename,filearea,filesize from mdl_files" > moodlefiles.txt
contenthash value is really the location in moodledata/filedir/ as well as
the name of the file.
'SoS', Ken
They are owned by a user.
mysql -u $mddbuser -p$mddbpass -e "use $mddbname;select id,userid,contenthash,filename,filearea,filesize from mdl_files" > moodlefiles.txt
contenthash value is really the location in moodledata/filedir/ as well as
the name of the file.
'SoS', Ken