Need to connect three tables to fetch a report to get user who utilised licenses?

[Prasanna13]

I need to create an report to fetch the number of people whose role type is fulfiller who is having CSM license. Here there are three tables involved. License_role, sys_user and sys_user_has_role. I have created a report with user table. But how to link user table with other two tables and get the Desired result of users who is having license. Anyone can help?

[Dr Atul G- LNG]

Hi @Prasanna13 

Did you check the Subcontract Management for this? That will provide you with more accurate data.

https://www.servicenow.com/community/developer-forum/how-to-pull-a-report-of-users-having-fulfiller-...

https://www.servicenow.com/community/developer-forum/find-people-that-have-a-fulfiller-licence-but-a...

[Ankur Bawiskar]

@Prasanna13 

You will require 4 tables the 4th one is sys_user_role

the field "User Role" on license_role table refers to sys_user_role table

There is already 1 OOTB database view for this, did you check that

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@Prasanna13 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏