When you are working with CRM and trying to evaluate if the security roles are compliant with the security policy currently in place, It can be a bit of a pain going from role to role to check each one. An even bigger pain if you need to take periodic snapshots of the roles. Yeah you can write yourself an nice little SSRS style report, or a console app that talks to the web services, or even buy a tool like CRM audit, but there is an easier way !
There is a great little tool called RoleSheetExporter by Johninfant on codeplex that you can download and use to do the job for you.
Basically it is a standalone app that you point at your CRM system. It produces an Excel workbook with a sheet for each security role, see example screen grab. Because it creates an Excel document, you can then apply whatever fonts and formatting you want to make it stand out, e.g. you can use a conditional format on the delete column to highlight any value that is not 'NONE'.
A great, simple to use tool that can save you hours of effort, I highly recommend it.

No comments:
Post a Comment