Thanks, guys, for these suggestions. I will take them with me when I
visit the office of the Expert. Glad to know that I will be able to
pursue my quest and find out what's going on.
Much obliged,
John Green
-----Original Message-----
From: Blackboard/Courseinfo userslist
[mailto:[log in to unmask]] On Behalf Of Matt Elton
Sent: 02 November 2007 16:25
To: [log in to unmask]
Subject: Re: Wild Cards in Search boxes
Hello John,
The easiest way will be to access the database, you can use a
building
block or put a simple jsp page somewhere but I'd just ask your DBA for
help.
Try;
select D.batch_uid, U.* from users U inner join data_source D on
U.data_src_pk1 = D.pk1 where len(user_id) = 7 and user_id like '%1'
(you might need to tweak the query for Oracle)
This will output the users and the name or the data source key. From the
data source key you should be able to tell if the users were created
manually, replicated or via snapshot.
Hope this helps,
Matt
On 2/11/07 14:42, "John Green" <[log in to unmask]> wrote:
> Hello Matt,
> We use a 6 character student ID as User Name but I have discovered a
few
> examples this week of 7 character usernames. I would like to see how
> extensive this is and get a handle on how it might have occurred. I do
> not know how to run SQL searches so am trying to find a way of
> identifying all the rogue users with the search boxes, without
trawling
> through hundreds of pages. The additional character seems always to be
a
> 1 - I suspect it is caused by Course Restore operations.
>
> Grateful for any suggestions you can make,
>
> John Green
>
> -----Original Message-----
> From: Blackboard/Courseinfo userslist
> [mailto:[log in to unmask]] On Behalf Of Matt Elton
> Sent: 02 November 2007 14:17
> To: [log in to unmask]
> Subject: Re: Wild Cards in Search boxes
>
> I don't think the Bb searches use wildcards, regular expressions or
data
> source key, what did you need to do?
>
> Matt
>
>
> On 2/11/07 09:21, "John Green" <[log in to unmask]> wrote:
>
>> Has anyone found a wild card that works in Blackboard Search boxes? I
> am
>> trying to search for a rogue batch of users whose user names have 7
>> characters and appear to all end in 1....Version 7.2 Enterprise
>>
>> John Green
>> Northbrook College, Sussex
|