Report showing users with particular role

[konrad_jaworski2]

Hi Experts!

Among data sources available in C4C I can see following ones:

1. CCABUSINESS_ROLE - All Business Roles
Shows the authorization assigned in the business role

Use case: shows business role details but not to whom it's assigned

2. CCAB01 - User - Current Status Details
Provides data about the current status of users, including assigned work center, work center views, validity dates, and whether the user is inactive.

Use case: shows which business roles are assigned to users

I'd like to see which users have or don't have specific role assigned. Are you aware of such data source or whether it it's possible to create it?

Basicaly, I need a way to identify users who are missing specific business role and I can't achieve that with CCAB01 data source. It's because evein if exclude that specific role, I'll still see the same users if they have any other role assigned. The only idea I have is to make a first report that will list all users having any role assigned, make a second report that lists users having that specific role and then make delta between those reports...

Thanks in advance for your support.

Cheers,

Konrad