I am trying to write a report that shows what privileges users have on the system. I need to do this so the administrator can see what privileges a user has in regards to the license they need. This is to ensure compliance with the new Microsoft Licensing
model.
To produce the report I need I need to join on the following tables: RolePrivilegesBase and PrivilegeBase
CRM does not let you include non filtered views in a query so does anyone know of any way of doing this?
We host CRM for quite a number of customers and we want to be able to deploy this report to all of them.