BrnDmp

Setting up Moodle Reporting

Setting a reporting concept for client. Things to report:

Global:

• Date
• Week
• Site name
• Site contact 1/2
• Version
• Last update

• enrolled users
• # active users
• # courses
• # groups

Course:

• this weeks most popular course (by unique ip)
• this weeks most popular course (by activity)

I create an aggregate dashboard kind of report which is clickable which allows each item to link to the history of that item. Not sure yet if I include results in a seperate database to prevent data loss after log table gets cleaned.

SQL statements used:

# enrolled users:

select count(*) from prefix_user where deleted = 0;

# deleted users:

select count(*) from prefix_user where deleted = 1;

# active users (last week):

# courses:

# groups:

course activity per week by unique ip

course activity per week by clicks