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
tel: 0191 5116005
fax: 0191 5116163
......................................................
-----Original Message-----
From:
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:
Sent: Tue 20/01/2009 16:19
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
Computing and Library Services
PO Box No. 341
HD1 3DH
________________________________
From:
Sent: 20 January 2009 15:41
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
Beaconside Campus
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