I posted about this 3 years ago, with no luck. Perhaps I posted in the wrong forum, so I'm going to try again.
I have created an SQL report that would give me details of all new course shells (from mdl_course) created in the last week. I was hoping to run this weekly. It's important to note that 99% of our courses are copies created using the restore function. Even new courses are 'restored' from a template.
However, it hit a snag when I discovered that the neither the "timecreated" nor the "timemodified" fields contain the time the original course record was created. I'm surprised that there's no timestamp for when the new record is created in the mdl_course table.
Does anyone know where I can find the timestamp for the actual creation of a new course record?
WHERE from_unixtime(timecreated)>CURDATE() - interval 7 DAY