Skip to main content

3.Broken Inheritance > SP_BrokenInheritance Job

Tracking directly applied permissions at scale isn't realistic. The SP_BrokenInheritance job analyzes data and generates SharePoint broken inheritance reports at the site level, showing site broken inheritance and the trustees assigned to those sites where inheritance is broken. Use this report to remove that access and grant access through group membership instead.

3.Broken Inheritance > SP_BrokenInheritance Job in the Jobs Tree

The SP_BrokenInheritance job is located in the 3.Broken Inheritance Job Group.

Analysis Tasks for the SP_BrokenInheritance Job

Navigate to the Jobs > SharePoint > 3.Broken Inheritance > SP_BrokenInheritance > Configure node and select Analysis to view the analysis tasks.

warning

Don't modify or deselect the selected analysis tasks. The analysis tasks are preconfigured for this job.

Analysis Tasks for the SP_BrokenInheritance Job

They need to remain in the default order:

  • 1. Create Inheritance View – Creates the SA_ENG_SPAA_Inheritance view accessible under the job’s Results node
  • 2. Unique Trustees Table. Identifies where Trustees have been Added/Removed – Creates the SA_SP_BrokenInheritance_UniqueTrustees table accessible under the job’s Results node
  • 3. Pivot Unique Trustees Table – Creates the SA_SP_BrokenInheritance_UniqueTrusteesPivot table accessible under the job’s Results node
  • 4. Summarize by Site Collection – Creates an interim processing table in the database for use by downstream analysis and report generation

In addition to the tables created by the analysis tasks which display resources with broken inheritance, the SP_BrokenInheritance Job produces the following pre-configured report:

ReportDescriptionDefault TagsReport Elements
Broken InheritanceThis job analyzes data and generates SharePoint direct permission reports at the site level. It shows site broken inheritance and the trustees assigned to those sites where inheritance is broken.NoneThis report is comprised of two elements:
  • Bar Chart – Displays top 5 site collections by resources with permission changes
  • Table – Provides a site collection summary
  • Table – Provides broken inheritance details