BLKBRD-L Notes

From: blkbrd-l - A list for Blackboard course administrators and faculty [mailto:BLKBRD-L@asu.edu] On Behalf Of Tony Harris
Sent: Tuesday, November 22, 2005 3:13 PM
To: BLKBRD-L@asu.edu
Subject: Re: [BLKBRD-L] Batch Course Unavailable

Ah, well since everyone has posted this, then let me say yes, we do the SQL bit about a month after each semester to turn off the courses for that semester (we use a term code imbedded in the name, which makes it easy).

Could do it by snapshot of course, and that might be easier for you.
For us, generating the appropriate file out of our SIS would probably be more work than just doing the one line SQL statement.

The statement Chuck and others have shared will work in Oracle too.

Tony Harris
Assistant CTO
Community College of Vermont
harrist@ccv.edu
(802) 241-3535

Zhë dishthe shthál ñe lhôñ svóná záxá.
(The direct path is not always straight.)
-------------------------------------------
PRIVACY & CONFIDENTIALITY NOTICE: This message is for the designated recipient only and may contain privileged, confidential, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of an email received in error is prohibited.

Rothman, Chuck wrote:

>I believe version 6.2 will still run the Blackboard utilities:
>http://www.wcc.vccs.edu/services/blackboard/tipsTricks.html (scroll
>down for bbUtilities).
>
>Otherwise, there's a simple query to the database that will make the
>change:
>
>update course_main set available_ind='N' where course_id like '%U05%'
>and available_ind='Y'
>
>(This works for MS-SQL; not sure about others) Change the '%U05%' to
>match some unique element in the courseID. Make sure to include the
>single quotes; the % is the wild card.
>
>
>---
>Chuck Rothman, Educational Technology (518) 783-2573
>Siena College I&TS
>515 Loudon Rd., Loudonville, NY 12211
>"Ever pick your feet in Poughkeepsie?"
>
>
>-----Original Message-----
>From: blkbrd-l - A list for Blackboard course administrators and
>faculty [mailto:BLKBRD-L@asu.edu] On Behalf Of Chad Lewis
>Sent: Tuesday, November 22, 2005 1:43 PM
>To: BLKBRD-L@asu.edu
>Subject: Batch Course Unavailable
>
>Is there a way to make courses unavailable through a batch process?
>The thought of changing 450 manually is not attractive. I am running 6.2
>enterprise.
>
>Thanks,
>Chad Lewis
>Catawba College
>cwlewis@catawba.edu
>
>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
>
>

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

// posted by Bill @ 2:42 PM

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

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"

// posted by Bill @ 8:38 AM