BLKBRD-L Notes

-----Original Message-----
From: blkbrd-l - A list for Blackboard course administrators and faculty
[mailto:BLKBRD-L@asu.edu] On Behalf Of Grubbs, Owen
Sent: Thursday, June 02, 2005 3:36 PM
To: BLKBRD-L@asu.edu
Subject: Re: [BLKBRD-L] SQL Query needed - all enrolled faculty and
students

Maybe something like this:

select u.firstname, u.lastname, u.email from users u where exists
(select 'x' from course_users cu where cu.users_pk1 = u.pk1) order by
u.lastname, u.firstname

Owen Grubbs
Database Analyst
Information Technology and Resources
Lynchburg College
1501 Lakeside Drive
Lynchburg, VA 24501-3199
434-544-8069

-----Original Message-----
From: blkbrd-l - A list for Blackboard course administrators and faculty
[mailto:BLKBRD-L@asu.edu] On Behalf Of Michael Robinette
Sent: Thursday, June 02, 2005 3:16 PM
To: BLKBRD-L@asu.edu
Subject: SQL Query needed - all enrolled faculty and students

I need to retrieve a list of all faculty and students currently enrolled
in at least one Blackboard course. I need email address as well as first
and last name (three fields, preferably).

We are Windows 2000, running SQL.

Would anyone care to share such a script with me?

Thanks in advance,

Mike Robinette
Blackboard Administrator
Indiana Wesleyan University

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 @ 3:09 AM