Need to help on pulling report of ITIL Users

[shaik_irfan]

Hello,

Can anyone please help me out how to pulled ITIL User reports ?

I created report on Sys_user_has_role table table with below filter conditions:

Role is ITIL, Active is True. Which is working fine but the problem is we are getting duplicate records the reason we usually grant roles by groups we have multiple group with ITIL role like ITIL, ITSM ITIL, PM Admin these all the group contains itil role now we have few users aded to all the groups then we see the same record multiple times.

Ex: User name: Test User who is added to ITIL, ITSM ITIL, PM Admin groups now when i pull the report i can see Test User 3 times can anyone please help me out how to make it Unique ?

[Padmanabam Tiru]

Hi,

Please create a scripted filter for this , this will help you to get unique username records. Please refer below how to create scripted filter:

https://docs.servicenow.com/bundle/jakarta-platform-user-interface/page/use/using-lists/task/t_ScriptedFilters.html

[palmen · Accepted solution]

You need to make the report on the sys_user table.

In the condition field use this filter
Sys ID is javascript:getRoledUsers('IN','itil')

If you run the report on the sys_user_has_role table, you'll get one hit for each time the itil role has been assigned to the same user.

[shaik_irfan]

Hello Palmen,

Thanks it works but the problem is i unable to show Role field in the column since User table & user has role table is differnt is there anyway where i can add up that option ?

[palmen]

Since all these users shown will have the ITIL role I would name the report to give the info about it's ITIL users.

Report name: Users with ITIL role

There is no point in displaying the role in a report if it's always going to say ITIL.