Same user added multiple times in a group. How to take this report ?

[KingshukM]

Same User added more than once in a group.I want to make a report I tried with sys_user_grmember table, but it didn't help.

#reports

[Tanushree Maiti]

Hi @KingshukM 

Create a function in a scriptInclude to find duplicate user

function getDupGrpMember (){
	var dupRecord = [];
		var gaDupCheck =new GlideAggregate('sys_user_grmember');
		gaDupCheck.addAggregate('COUNT','user');
		gaDupCheck.addNullQuery('user');
		gaDupCheck.groupBy('user');
		gaDupCheck.addHaving('COUNT','>','1');
		gaDupCheck.query();
		while (gaDupCheck.next()) {
			dupRecord.push (gaDupCheck.getValue('user'));
		}
		return dupRecord;
}

Then Go to Report ->Sys_user table 

call that function from report condition:

Then add a related list condition "greater than 1" on the table "Groups" with the filter "group.roles is pps_resource"

Refer: https://www.servicenow.com/community/spm-forum/report-to-show-duplicate-group-members-using-a-script...