Report: how many users got itil access this year and through which group

[GauriSharma]

Hello Team,

How can I create a report to get the details of how many users got itil access this year and through which group they got it.

I am aware that we have different tables for groups and users, can anyone guide me with dot walking or maybe filters, or maybe I create a database view ( which tables and what filters should be applied).

Thanking in anticipation,

Gauri 

[ersureshbe]

Hi, Is my answer helped you? Can you mark as correct answer or helpful and help to close the thread?

[Aditya Raute]

Not sure what you mean here exactly. Could you please rephrase your query?

[ersureshbe]

Hi,

You can join only 2 tables not required 'sys_user_has_role' table. The mentioned 2 table derives the requirement info.

1. Group name,

2. Role Name,

3. When the group added to the user

4. When you clicked the try it button the result will be display. In that, click the gear icon and call the remaining fields from Available to Selected. You can understand the reason why many entries displays and which user is assigned to etc.,