Is a user in a group

[OpenIT Solutions]

Hi,

Is there a way via the automation interface to check is a user is in a specific group ?

Regards,

Jon.

[qwerty]

You need to write a query reading t_secusergroup.

q.

[Eve]

I use the following sql in EA's search window and group by GroupName to see group membership.

[Geert Bellekens]

I use the following sql in EA's search window and group by GroupName to see group membership.

Simon you forgot to include the actual SQL  

Geert

[Eve]

select t_secgroup.GroupName, t_secuser.FirstName, t_secuser.Surname from t_secgroup, t_secusergroup, t_secuser where t_secgroup.GroupID = t_secusergroup.GroupID and t_secuser.UserID=t_secusergroup.UserID