Skip to main content

SP_UnresolvedSIDs Job

This job identifies Unresolved SIDs that have permissions to any SharePoint resources. Unresolved SIDs can be safely cleaned up without affecting user access.

Analysis Tasks for the SP_UnresolvedSIDs Job​

Navigate to the Jobs > SharePoint > 1.Direct Permissions > SP_UnresolvedSIDs > Configure node and select Analysis to view the analysis tasks.

CAUTION: Do not modify or deselect the selected analysis tasks. The analysis tasks are preconfigured for this job.

Analysis Tasks for the SP_UnresolvedSIDs Job

They need to remain in the default order:

    1. Create Function – Creates an interim processing table in the database for use by downstream analysis and report generation
    1. Find Unresolved SID ACLs – Creates the SA_SP_UnresolvedSIDs_DirectPermissions table accessible under the job’s Results node
    1. Find Affected Resource Count per SID – Creates the SA_SP_UnresolvedSIDs_ResourceCount table accessible under the job’s Results node
    1. Rank Resources by SID Count – Creates the SA_SP_UnresolvedSIDs_DirectPermissions table accessible under the job’s Results node

In addition to the tables created by the analysis tasks which display direct permissions for unresolved SIDs, the SP_UnresolvedSIDs Job produces the following pre-configured report:

ReportDescriptionDefault TagsReport Elements
Unresolved SID PermissionsUnresolved SIDs can be safely cleaned up without affecting user access.NoneThis report is comprised of three elements: - Bar Chart – Displays top 5 unresolved SIDs by affected resources - Table – Provides details on resources with unresolved SIDs applied - Table – Provides details on unresolved SIDs by affected resources