Tuesday, November 01, 2005
[BLKBRD-L] Query to determine Blackboard course usage
From: blkbrd-l - A list for Blackboard course administrators and faculty
[mailto:BLKBRD-L@asu.edu] On Behalf Of Glen Parker
Sent: Tuesday, November 01, 2005 10:44 AM
To: BLKBRD-L@asu.edu
Subject: Re: [BLKBRD-L] Query to determine Blackboard course usage
BB_BB60_STATS is a different schema, not a table. If you wanted to run
it against the ACTIVITY_ACCUMULATOR table in the BB_BB60_STATS schema,
you can either log into the BB_BB60_STATS schema, or prefix the table
with teh schema name, like BB_BB60_STATS.ACTIVITY_ACCUMULATOR
The query above should run fine, and will run against your 'main'
schema's activity_accumulator table. To run against your stats schema,
replace ACTIVITY_ACCUMULATOR with BB_BB60_STATS.ACTIVITY_ACCUMULATOR in
line 5 of the above query.
Thanks, Glen
On 11/1/05, John Pfeffer <jpfeffer@buffalo.edu> wrote:
>
> apologies for my previous post, I meant to include the original
> message I was referring to- here it is: (My question was, is this
> doable against an oracle database? This refers to a table I can't find
> in ours, BB_BB60_stats. Thanks.
>
> "In our MS SQL Dtabase, I am using the following query to get the
> login count for the Instructors. It will give you the Instructor names
with no.
> of times they successfully logon to Blackboard during a period. It
> should be run on the "BB_BB60_Stats" database.
>
> Simply change the Date Range for your need. Also put "1" instead of "2
"
> to get student login count.
>
> With Regards,
> Jomon
>
>
> SELECT
> U.FIRSTNAME +' '+ U.LASTNAME as [User Name] ,count(A.PK1) as [Login
> Count] FROM ACTIVITY_ACCUMULATOR A INNER JOIN USERS U ON A.USER_PK1 =
> U.PK1 WHERE A.[TIMESTAMP] >= '09/01/2003' AND A.[TIMESTAMP] <=
> '09/19/2003' AND A.DATA = 'Login succeeded.' AND A.EVENT_TYPE =
> 'LOGIN_ATTEMPT' AND
> U.INSTITUTION_ROLES_PK1 = 2
>
> group by A.User_PK1,U.FIRSTNAME, U.LASTNAME order by
> U.LASTNAME,U.FIRSTNAME"
