Hi Gary,
Surely if you just go to the Sys Admin control panel and List/Modify Users > List All > List All the listing you get back includes the Username and e-mail.
We're on 6.2 and I can't remember what things are like in v5 but think it should be the same??
If I was doing a query on our databases to get this info. I'd probably just try:-
USE bb_bb60
SELECT USER_ID,
EMAIL
FROM USERS
GO
Not sure about the database name (in the USE statement), table names (in the FROM statement) or the column names (in the SELECT statement) in v5 though?? If you know these then just substitute them for what I use in v6.
Hope this is of some use.
......................................................
Gerard Elder
VLE Systems Development Officer
Blackboard Administrator
City of Sunderland College
[log in to unmask]
tel: 0191 5116005
fax: 0191 5116163
......................................................
-----Original Message-----
From: Blackboard/Courseinfo userslist
[mailto:[log in to unmask]]On Behalf Of CLAY Gary M
Sent: 29 April 2005 15:43
To: [log in to unmask]
Subject: Extracting data from the Blackboard system database
Hello,
We are in the process of planning what courses should be migrated when
we move from v5 to v6 later this year. The person leading this exercise
has asked for the following :
A procedure to check Blackboard usernames to match them up to email
addresses (or a procedure to extract username and email addresses from
the Blackboard databases)
Can anyone out there provide the relevant query?
----------------------------------------------
Gary Clay
Learning Development Manager
Information Services
Telephone 01785 35 3648
e-mail [log in to unmask]
The information in this email is confidential and is intended solely for
the addressee. Access to this email by anyone else is unauthorised.
If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on
it, except for the purpose of delivery to the addressee, is prohibited
and may be unlawful. Kindly notify the sender and delete the message and
any attachment from your computer.
|