Customized the Permission Matrix Report
What to acheive:
For the business users, we want to hide some columns and have some filtering (e.g. "Permission Levels" is not "Contribute").
Business Case:
We need to run this report quarterly for the business users. And to them, a lot of the fields don’t make any sense and can cause confusion. Therefore, we are hoping if there is an option to set the filters/hide columns.
Can we do this through the Sharegate Shell?
everic.lauziere
shared this idea
-
david.street
commented
I'd like to filter it with things like
- Wildcard selection of sites/site collections by name or by URL, e.g. %/contract/% against the URL. Right now I'm juggling a farm with 3600 site collections, and I'm struggling to run a report to get small enough result set that it will export without causing a corruption in Excel (I know, which problem to solve)
Only show certain types of permissions, e.g. multi-select on the report's Type field. Right now I'm looking for Document/Document Set/Folder permissions specifically, so I don't care about Site/Library permissions which is the vast bulk of them