[rt-users] [SOLVED] how to dump out all users from database ?

[Philip]

I managed to dump out usernames by logging in as root in the web GUI and 
doing a user search.
Job done

regards, Philip

On 18/01/13 12:55, Philip wrote:
> Hi
> I am using RT 4.0.5-3 from debian squeeze-backports and ExternalAuth
> pointing at the company AD.
>
> I'm not much of a database admin. The database is mysql 5.1.63.
>
> Can someone tell me the commands that would tell me:-
>
> All users
> whether they are privileged or not?
> what RT thinks their AD username is?
> what RT thinks their email address is?
>
> thanks, Philip