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...

[KingshukM]

The screenshot you pasted shows report to be created on Sys_user_grmember table
but your text says sys_user.

can you please validate and confirm once?

[Kingshuk Mazumd]

This didnt work.The screenshot you pasted shows report to be created on Sys_user_grmember table
but your text says sys_user.

[Tanushree Maiti]

Screen shot is sample screen shot.. Please do it on sys_user table and check how it is going on