I started to post some of the Blackboard 9.1 SQL Server queries that I've found handy (or collected) from others.
Caveat: I'm not a SQL DBA so my code is prob. inefficient, ugly, etc.
Tuesday, April 5, 2011
Auditing Users (from CBergeron AT LAKELANDCC.EDU)
This query will show a user's activity in courses. Removing the 'and course_pk1 like '%'' clause to also see their activity in the admin GUI.
select * from activity_accumulator where
(select pk1 from users where user_id like ('YOUR_USERID'))
and timestamp > '2010-09-20'
and timestamp < '2010-09-30'
and course_pk1 like '%'
order by timestamp