Hi All,
I am trying to run a report which lists all assignments and the file submissions associated with them including file size.
I am struggling to do this and wondered if I am running through the right tables?
SELECT a.name, s.assignment, s.submission, f.itemid, f.filesize,
FROM mdl_assign a
LEFT JOIN mdl_assignsubmission_file s ON a.id = s.assignment
LEFT JOIN mdl_files f ON s.assignment = f.itemid
One issue is I get multiple submissions for the same contenthash which I worked around, but then seemed to retrieve far too few assignments which made me wonder if these are the tables I should be using?
Any pointers would be greatly appreciated!