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").
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?
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