I am currently working for a company that uses Moodle as an educational platform for technical and corporate traning. The company is interested in the creation of a monthly report that will contain all the content that has been aadded on the Moodle enviroment during the last month. By content i mean every new course, every new educational resource (docx files, pdfs,videos, etc.) and every new activity (mutiple choice quizzes, assignments, etc.). The Moodle and the PHP versions are both 3.4, the Moodle database is MariaDB and the operating system of the Moodle server is linux (CentOS). Curently the company is using the configurable reports plugin for the creation of various other reports. I would like to ask if there is an appropriate sql query, or a plugin or even a different external tool for the creation of this particular report.
All help and suggestions will be greatly appreciated.
Thank you in advance for your time.