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

[Philip]

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