BLKBRD-L Notes

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:46 AM
To: BLKBRD-L@asu.edu
Subject: Re: [BLKBRD-L] Query to determine Blackboard course usage

I take it back, the query needs a bit of tweeking for Oracle. Also, this
will probably take a long time to run.

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 >= to_date('09/01/2003','MM/DD/YYYY') AND A.TIMESTAMP <=
to_date('09/19/2003','MM/DD/YYYY) 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;

On 11/1/05, Glen Parker <glparker@usf.edu> wrote:
>
> 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"
> >
> > Directions to BLKBRD-L archives and settings:
> > http://is.asu.edu/instruction/faq/usingBLKBRD-L.html
> >
>
>

Directions to BLKBRD-L archives and settings:
http://is.asu.edu/instruction/faq/usingBLKBRD-L.html

// posted by Bill @ 9:13 AM