is there a way to remove duplicates from a report?

[a99920]

I have a report that tells me all users who have a particular role but users can be listed many times (depending on how many groups they are in that the role might have been inherited from).

[ian_cox]

a group by in the use case would still show 2 records grouped by user Ian

[a99920]

You are exactly right. The fact the records exist is clearly necessary but I was in hopes someone would have found a way to de-dup such reports inside SN.

[Lena_Latham]

Hi Joe.   If you measure this via premium Performance Analytics, there is a way to get it done.

1. Create an Indicator Source from the User Role [sys_user_has_role]. I dot.walked to apply a filter to only pull in Active users.

2. Create an Automated Indicator that references your new Indicator Source. In the "Aggregate" field, select Count Distinct (which means unique or count each person only once) AND the field is User.

NOTE: It is important to select "User" rather than "SysID" because there is a different SysID in the User Role table for each user/role combination. In this case, User is the unique name.

3. Create a Data Collection job for the Indicator. I created a monthly collection job since I had selected a Monthly Frequency for the Indicator Source and Indicator.

NOTE: because this Indicator does not use dates to perform its measurement, you can't collect historic scores for it.   So, I only selected to look back 1 month.   As it collects data each month, you will begin to see a trend.

4. Associate your new Indicator to the job, then click Execute Now.

5. View the Scorecard for the Indicator. Because there is only 1 score to begin with, click the Scores tab to view it:

I hope this helps.

Lena

[Vance1]

For those of us that dont have PA, might there be a short piece of code that can be inserted into a filter. Similar to how "javascript:getRoledUsers()" gets inserted into the sys_id filter here.

[Tony12]

https://community.servicenow.com/community?id=community_question&sys_id=2a51ece7dbd45f8c0e3dfb651f96...