Report on groups containing all inactive members

[Dolly M]

Need a report on groups containing all inactive members.

[jaheerhattiwale]

@Dolly M it is not iterating through all group members records btw.

But let me optimize the code and come back here 

[Ankur Bawiskar]

@Dolly M 

create a client callable script include which is classless and check this

function getGroups(){
	var arr = [];
	var groupRec = new GlideRecord("sys_user_grmember");
	groupRec.query();
	while(groupRec.next()){
		var group = groupRec.getValue('group');
		var grpMemberGr = new GlideRecord("sys_user_grmember");
		grpMemberGr.addQuery("group", group);
		grpMemberGr.addQuery('user.active', true);
		grpMemberGr.query();
		if(!grpMemberGr.hasNext()){
			arr.push(groupRec.group.toString());
		}
	}
	return arr.toString();
}

This is how you will call the script include

Report will be on Group table and give this filter condition

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Dolly M]

Hi Ankur,

I ran the report but the server became unresponsive and the page got hanged as we have high no. of data in group member table. Also I don't think there is any convenient way to solve this issue. 

Basically, this was a requirement from higher management to see groups which have all members as inactive. But there's a lot that needs to be done at the backend because the query/logic has to be ran against each record in sys_user_grmember.

[Ankur Bawiskar]

@Dolly M 

possibly the query is taking time.

So you better do it for few records first and then use the complete script.

[Dolly M]

Hi Ankur, 

For few records it is working fine. But not working for all records.

By any chance can it be done via Database view ?