Hi,
Generally post migration it is really tough to compare unique permissions of each list and library under each subsite.
Recently we have notified the team through calculation metrics through power pivot using excel.
First we have exported permissions of source and target using Permissions Matrix in the Share gate.
After that opened Exported source excel, removed if there are any empty columns.
Selected all the cells, clicked Pivot Table under Insert Tab
Click Ok on the Create Pivot Table pop up
Now select URL, Inheritance, Principal Type which comes under Rows section as below
Drag the selected field Principal Type under Values section as below
Repeat the same for the exported permissions matrix of the target site.
Now open both the files, minimize and compare source and target.
Through this, shall be able to figure in which site the unique permissions are missing in bulk
No comments:
Post a Comment