Poodll does not yet have a reporting module, though Intelliboard can report on Poodll useage in your site. Because Classic Poodll stores files locally, you will need to look in your Moodle database mdl_files table to find out how many Poodll files are there. The following SQL is hopefully a good starting point.



For AUDIO


SELECT DISTINCT contenthash,contextid,component,filearea,itemid,userid FROM `mdl_files` WHERE (filename LIKE 'upfile%.mp3' OR filename LIKE 'poodllfile%.mp3') AND filearea NOT LIKE 'draft'


For VIDEO


SELECT DISTINCT contenthash,contextid,component,filearea,itemid,userid FROM `mdl_files` WHERE filename LIKE 'poodllfile%.mp4 AND filearea NOT LIKE 'draft' 


Notes:


  • Sometimes the same file can appear multiple times in the mdl_files table. It might have a different filename,
    e.g abc.mp3 and abc(1).mp3
  • Sometimes it will have the same filename but be in the draft file area, not in permanent storage. This is if it has been created or edited recently.

The above SQL deals with both of those cases, because it omits draft files. And because the duplicate files will have the same contenthash,  "DISTINCT contenthash .." eliminates duplicates from the report.


There are some less likely file types with entries from Poodll, e.g FLV or WEBM files. These would be produced if a user was choosing to not use our cloud conversion services. This is sometimes the case though fewer than 10% of users would be in this category.