How to pull unique users from User has role table

shaik_irfan · ‎10-25-2018

Hello,

We are getting duplicate users with the same role can be exclude or pull only unique records.

Ex: We have 2 groups in place 1) ITIL 2) Project Manager. both groups contains role itil. For some users we have added to both the group ITIL, Project Manager with this user granted with itil role more than once.

When i pull a report i am getting user more than once can we filter to pull only unique records or any other table from where i can pull a report to get only unique record.

Sindhu B1 · ‎10-26-2018

Hello,

Please refer this link , it may help you

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

If it is helpful ,Please mark it as helpful

Thanks and regards ,

Sindhu B

View solution in original post

Andrew Barnes - · ‎10-25-2018

Greetings Shaik,

The easiest thing you can do is to install https://docs.servicenow.com/bundle/london-platform-administration/page/administer/roles/task/Role-Mg... which remove role duplication from your instance. In a report, you can use group by user to get an accurate count of unique users.

-Andrew Barnes
Developer Advocate
Flow Designer London Learning Module: http://bit.ly/2ypjKUX

shaik_irfan · ‎10-25-2018

Hello Andy,

Thank you for the reply. We still in Kingston by any chance we have an option to do so ?

Or any other alternative solution ???

shaik_irfan · ‎10-25-2018

Hello Andrew,

We see that the plugin is available in Kingston too, can you please help me out will it affect any of the existing functionality ???

vinothkumar · ‎10-25-2018

Hi Shaik,

You can group by user to get the exact count.