How to pull unique users from User has role table

[shaik_irfan]

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.

[shaik_irfan]

Thanks Vinoth. But that doesn't work since we are facing issue after pulling the report. 

[Sindhu B1 · Accepted solution]

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

[shaik_irfan]

Thanks Sindhu that solve my issue.

But a Change in the report i did is we need to pass the parameters along with calling OOB Business Rule like:

In the condition field use this filter

Sys ID is javascript:getRoledUsers('IN','itil')