AI for M365 Admins — Chapter 3: SharePoint Advanced Management (SAM) for Copilot (DAG Reports, RAC & Stale Site Hygiene)

📚 AI for Microsoft 365 Administrators Chapter 3 of 10
View Full Book TOC →
🤖 Chapter 3 · Learning Objectives AI for M365 Admins · SharePoint Advanced Management (SAM)
What You Will Master in Chapter 3
  • Copilot unlocks SAM: Purchasing Microsoft 365 Copilot unlocks core SharePoint Advanced Management (SAM) governance controls directly inside the SharePoint Admin Center.
  • Data Access Governance (DAG) Reports: Identify sites with Everyone except external users (EEEU), anonymous sharing links, and unlabeled sensitive libraries in minutes.
  • RAC vs. RCD (Know the Difference): Restricted Access Control (RAC) hard-blocks site access to specific Entra security groups; Restricted Content Discovery (RCD) leaves normal permissions intact while excluding the site from Copilot and organization-wide search.
  • Stale Data Hygiene: Configure Inactive Site Policies so Copilot stops citing obsolete 2019 policies and abandoned project sites.
Set-SPOSite -Identity "https://contoso.sharepoint.com/sites/Finance" -RestrictContentOrgWideSearch $true

In Chapter 2, we tackled immediate oversharing containment using Restricted SharePoint Search (RSS) (an allowlist of up to 100 approved sites). RSS is an effective emergency brake, but it is a temporary bridge—you cannot leave a 5,000-site enterprise locked to 100 sites forever.

To scale Microsoft 365 Copilot safely across your entire SharePoint Online estate, you need SharePoint Advanced Management (SAM). Even better: Microsoft includes core SAM Copilot-governance capabilities at no extra charge for tenants with Microsoft 365 Copilot licenses.

In Chapter 3, we walk through the four SAM pillars—DAG Reports, Restricted Content Discovery (RCD), Restricted Access Control (RAC), and Site Lifecycle / Access Reviews—with SharePoint Online PowerShell commands ready for production.


SharePoint Advanced Management (SAM) Governance Loop for Microsoft 365 Copilot 1. Discover (DAG) Data Access Governance reports flag top 100: • EEEU overshared sites • Anyone / Org links • Labeled but open sites Baseline Oversharing Risk 2. Shield (RCD) Restricted Content Discovery per site • Users keep normal access • Hidden from Copilot & org-wide search index Zero User Disruption 3. Lock Down (RAC) Restricted Access Control for Crown-Jewel Sites • Enforces Entra Security Group allowlist (up to 10) • Blocks even direct links Hard Zero Trust Boundary 4. Sustain (Lifecycle) Automated Hygiene: • Site Access Reviews • Site Ownership Policies • Inactive Site Archive Prevents Stale AI Citations Use RCD to quickly shield sites under review, RAC to permanently lock HR/Finance hubs, and Inactive Site Policies to archive dead data.

1. Restricted Content Discovery (RCD) vs. Restricted Access Control (RAC)

Administrators frequently confuse RCD and RAC. Use this decision matrix before running PowerShell:

ControlWhat It BlocksDoes It Break User Bookmarks?Best Use Case
Restricted Content Discovery (RCD)Blocks the site from Copilot grounding and organization-wide search (unless the user directly opens or recently edited the file).NoQuickly shielding messy or legacy sites while site owners complete access reviews.
Restricted Access Control (RAC)Hard-blocks all access (browser, OneDrive sync, Teams files, AND Copilot) for anyone outside up to 10 designated Entra security groups.Yes (for non-group members)Crown-jewel sites: HR, Legal, M&A, Executive Board, Payroll.

2. Configuring RCD & RAC with SharePoint Online PowerShell

Connect to the SharePoint Online Management Shell (Microsoft.Online.SharePoint.PowerShell v16.0.25000+):

POWERSHELL
# Connect as SharePoint Administrator
Connect-SPOService -Url "https://contoso-admin.sharepoint.com"

# -------------------------------------------------------------------
# 1. Enable Restricted Content Discovery (RCD) on a sensitive site
#    Excludes the site from Copilot & org-wide search without breaking links
# -------------------------------------------------------------------
Set-SPOSite -Identity "https://contoso.sharepoint.com/sites/Legacy-HR-Archive" `
    -RestrictContentOrgWideSearch $true

# Audit all sites currently shielded by RCD
Get-SPOSite -Limit All |
    Where-Object { $_.RestrictContentOrgWideSearch -eq $true } |
    Select-Object Title, Url, RestrictContentOrgWideSearch |
    Format-Table -AutoSize

# -------------------------------------------------------------------
# 2. Enable Restricted Access Control (RAC) on a Crown-Jewel Finance Site
#    Only members of the specified Entra Security Group GUID can open or ground on it
# -------------------------------------------------------------------
$financeGroupGuid = "11111111-2222-3333-4444-555555555555"

Set-SPOSite -Identity "https://contoso.sharepoint.com/sites/Executive-Finance" `
    -RestrictedAccessControl $true `
    -RestrictedAccessControlGroups @($financeGroupGuid)

# Audit all RAC-protected sites across the tenant
Get-SPOSite -Limit All |
    Where-Object { $_.RestrictedAccessControl -eq $true } |
    Select-Object Title, Url, RestrictedAccessControl, RestrictedAccessControlGroups |
    Format-Table -AutoSize

3. Running Data Access Governance (DAG) Reports & Site Access Reviews

Inside SharePoint Admin Center → Reports → Data access governance:

  1. Run the "Sharing links" report (identifies sites with the highest count of Anyone and People in your organization links created in the last 28 days).
  2. Run the "Content shared with Everyone except external users (EEEU)" report.
  3. Click Initiate site access review directly from the report row: SAM automatically emails the site owner with a guided checklist to remove overshared groups, revoke stale links, or confirm business justification—shifting cleanup from central IT to the business owners who actually know who belongs in the site.

4. Eliminating "Stale AI Hallucinations" with Inactive Site Policies

Oversharing is only half the SharePoint problem—stale data is the other half. If your tenant has a 2019 travel expense policy sitting on an abandoned SharePoint site alongside your 2026 travel policy, Copilot may blend both documents together and give employees wrong reimbursement limits.

In SharePoint Admin Center → Policies → Site lifecycle management:

  1. Create an Inactive site policy targeting sites with no user activity for 180–365 days.
  2. Set the automated action to Notify site owners (monthly for 3 months), then Move to Read-Only or Archive via Microsoft 365 Archive if uncertified.
  3. Create a Site ownership policy requiring every active SharePoint site to maintain at least 2 active owners so no site becomes an unmonitored orphan.

5. Chapter 3 Lab Checklist

  • [ ] Run DAG reports in SharePoint Admin Center and export the top 25 EEEU-exposed sites.
  • [ ] Apply Restricted Content Discovery (-RestrictContentOrgWideSearch $true) to any legacy/unreviewed site before assigning Copilot licenses.
  • [ ] Apply Restricted Access Control (RAC) to HR, Legal, and Executive Finance sites bound to dedicated Entra ID security groups.
  • [ ] Enable Site Lifecycle Inactive Policies (365-day threshold) to archive stale documents out of Copilot's Semantic Index.

💬 Reader Comments & Feedback

Did this runbook help, or did Microsoft change a cmdlet or UI menu? Share your feedback below.