Checking if current user is manager of any group

[codedude]

I am trying to check if the current user is a manager of any group. I have checked if the current user is a group member of any group and it works great. I am just not sure of the table and what not to check if the current user is a manager of any group. Can anyone advice?

Group Member Logic:

var uID =   g_user.userID;

var grmember = new GlideRecord('sys_user_grmember');

grmember.addQuery('user', uID);

grmember.addQuery('group.active', true);

grmember.query();

Thanks

[Pradeep Sharma]

The below link should help you further.

http://wiki.servicenow.com/index.php?title=Getting_a_User_Object#gsc.tab=0

[srinivasthelu]

You have manager field in Group table. so something like below should work

var grmember = new GlideRecord('sys_user_group');

grmember.addQuery('manager',uID);

grmember.addQuery('active', true);

grmember.query();

[codedude]

Srinivas,

Will try this now, could not find the manager field.

[Pradeep Sharma]

Hi Josh,

Here is the updated script : This will check if the current user is manager of any group. You can add one more query here if you want only active records.

var uID =   g_user.userID;

var grmember = new GlideRecord('sys_user_group'); 

grmember.addQuery('manager', uID);

grmember.query(); 

while(grmember.next()) 

{ 

//your logic

} 

[puchu]

how can we add these conditions in condition box?