Hi everyone,
Does anyone know of a way to list all course formats and the number of courses using each format?
Kind of like in Site Administration, where you go to say, "Manage Activities", and you can see how many instances of each activity currently exist. And then clicking on the number displays a list of all the courses using that particular activity.
Any third-party plug-ins floating around that can make this happen? Or some report I can build?
Thanks for any help or suggestions!
Sarah
Do you have access to the database? This is very easy with a simple query:
select format, count(*) from mdl_course GROUP BY format
select format, count(*) from mdl_course GROUP BY format
Thank you, Jason.
I don't personally have access to the database, but I will forward your query suggestion to our backend admin for him to pull that up for me.
Much appreciated!
Sarah
I don't personally have access to the database, but I will forward your query suggestion to our backend admin for him to pull that up for me.
Much appreciated!
Sarah
Worked like a charm!
Thanks Jason!
Sarah
Thanks Jason!
Sarah