Hi Mark,
I've used the following one quite successfully in the past. You could
change the third WHERE clause so that it is a value between two dates to
get specific months. I imagine you could also tweak it to give you each
month in an academic year in a sequence, too. Hope that's of some use!
Gerard
/* This query is designed to show the total number of hits for
any one course site divided up by each user.
*/
USE bb_bb60_stats
SELECT
course_main.course_name,
activity_accumulator.course_pk1,
activity_accumulator.event_type,
activity_accumulator.user_pk1,
users.pk1,
users.user_id,
users.firstname,
users.lastname,
count (*) 'Event count'
FROM
activity_accumulator
inner join course_main
on activity_accumulator.course_pk1 = course_main.pk1
inner join users
on activity_accumulator.user_pk1 = users.pk1
where
activity_accumulator.event_type = 'course_access'
and course_main.course_id = '80103.YX.00.08'
and timestamp > '2008-08-01'
GROUP BY
course_main.course_name,
activity_accumulator.course_pk1,
activity_accumulator.event_type,
activity_accumulator.user_pk1,
users.pk1,
users.user_id,
users.firstname,
users.lastname
go
......................................................
Gerard Elder
VLE Systems Development Officer
Blackboard Administrator
City of Sunderland College
[log in to unmask]
tel: 0191 5116005
fax: 0191 5116163
......................................................
-----Original Message-----
From: Blackboard/Courseinfo userslist
[mailto:[log in to unmask]] On Behalf Of Pelling, Mark
Sent: Monday, May 11, 2009 10:01 AM
To: [log in to unmask]
Subject: Re: Does anyone know a suitable database query for...
Morning,
Does anyone have a querry that would allow a specific course to be
tracked ie number of page hits per month, with maybe student ID (so that
we can cross tab with the school / program)
The main issue that we have is that the general stats that BB has often
time out (too much data - all stduents are enrolled on this module)
We have Crystal Reports but again many issues with accessing such a
large set of data.
Is there anywhere/ one whom has a selection of stat generating querries
that they are willing to share
Kind regards
Mark Pelling
________________________________
From: Blackboard/Courseinfo userslist on behalf of Andrew Raistrick
Sent: Tue 20/01/2009 16:19
To: [log in to unmask]
Subject: Re: Does anyone know a suitable database query for...
Try this for a specific student
select f.file_name,f.link_name,u.status_ind,u.upload_date,u.dtmodified
from bb_bb60.files f , bb_bb60.course_user_uploads u ,
bb_bb60.course_users c, bb_bb60.users s
where f.pk1=u.files_pk1 and u.course_users_pk1=c.pk1 and
c.users_pk1=s.pk1 and s.user_id='u0870483'
order by u.upload_date asc
Note, The STATUS_IND column represents the following :
a = Added
s = Sent
r = Received
Hope this helps
Andy Raistrick
Email: [log in to unmask]
Tel: (01484) 471315
The University of Huddersfield
Computing and Library Services
PO Box No. 341
Huddersfield
HD1 3DH
________________________________
From: Blackboard/Courseinfo userslist
[mailto:[log in to unmask]] On Behalf Of CLAY Gary M
Sent: 20 January 2009 15:41
To: [log in to unmask]
Subject: Does anyone know a suitable database query for...
... obtaining details of Student work submission into Blackboard (via
dropbox/assignment/turnitin) - per student/module?
--------------------------------------------------
Gary Clay
Learning Development Manager
Learning Development and Innovation
Staffordshire University
Beaconside Campus
Stafford ST18 0AD
Telephone +44 (0) 1785 353648
e-mail [log in to unmask]
The information in this email is confidential and is intended solely for
the addressee. Access to this email by anyone else is unauthorised.
If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on
it, except for the purpose of delivery to the addressee, is prohibited
and may be unlawful. Kindly notify the sender and delete the message and
any attachment from your computer.
1 Vision. Our students voted us top new University for student
satisfaction.
This transmission is confidential and may be legally privileged. If you
receive it in error, please notify us immediately by e-mail and remove
it from your system. If the content of this e-mail does not relate to
the business of the University of Huddersfield, then we do not endorse
it and will accept no liability.
