[rt-users] How to look for dsabled user in the database

[Ruslan U. Zakirov]

Asif Iqbal wrote:
> Hi All
> 
> I know how to look for disabed user in the RT gui. But how do I look for the
> same in the rt3 database ? What flag should I look for ?
select u.Name from Users u, Principals p where u.id = p.id and 
p.Disabled = 1 and p.PrincipalType = 'User';

> 
> I dod a select * from Users where name='testuser' \G but did not see anything
> different with this disable user from a user with privilege rights to access
> webrt.
> 
> I am trying to compile a mailing list of valid users who have access to the
> webrt
> 
> Please help
> 
> Thanks
>