Need to help on pulling report of ITIL Users

shaik_irfan · ‎02-18-2018

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 ?

palmen · ‎02-19-2018

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.

View solution in original post

Scott Jordheim · ‎02-19-2018

If he ever would need to for some reason, only admin-level users have the ability to add that Roles column to the report out of the box on the sys_user table.

Goran WitchDoc · ‎02-19-2018

Hi Shaik,

If you need this for reporting on licenses and so on, I would recommend looking into subscription management that exists OOB: https://docs.servicenow.com/bundle/jakarta-servicenow-platform/page/administer/subscription-management/reference/subscription-management-landing-page.html

//Göran

shaik_irfan · ‎02-20-2018

Hello Goran,

Yes it is for Auditing the itil roles licensing purpose, currently we are using Helsinki Version do we need add any plugin i am not pretty much sure about Subscription management, can you please help me out with screen shot ?