I'd like to quantify the content creation activity for our site. For example, "In 2019, Professor Smith added 99 modules".
Right now, I have a SQL query that looks at the mdl_course_modules table and is mostly what I need, but with a problem:
Typically when users create material, they duplicate prior items as a starting point. We consider this best practice since you avoid re-doing all the various settings. The problem though, is that when an activity is duplicated, the copy retains the 'added' date of the original and so you no longer have an accurate view of what Professor Smith has been up to.
I've considered building a query on the logs, but that data doesn't look as friendly to work with. Any suggestions or different approaches welcome!
Moodle 3.8+