SKILL.md— paste into Microsoft 365 Copilot or ClaudeDownload▸ View skill file▾ Hide skill file
---
name: SharePoint Advanced Management Site Governance Audit
description: Audits the Microsoft SharePoint Advanced Management feature set — data access governance reports, restricted access control, site ownership policies, and AI readiness signals — to identify governance gaps in the SharePoint estate.
---
# SharePoint Advanced Management Site Governance Audit
> **TL;DR:** This skill audits the Microsoft SharePoint Advanced Management capability set — data access governance, restricted access control, site ownership policies, and Copilot readiness — to surface governance gaps in the SharePoint estate and produce a prioritised remediation table.
## What does the SharePoint Advanced Management site governance audit cover?
Microsoft SharePoint Advanced Management (SAM), included in Microsoft 365 E5 and available as an add-on, provides a set of governance capabilities that extend beyond the base SharePoint Online feature set. It includes data access governance (DAG) reports surfacing over-shared sites, restricted access control for site-level data perimeters, site ownership policies that enforce minimum active-owner requirements, and change history for governance events. As organisations roll out Microsoft 365 Copilot, SAM's restricted access control becomes a critical data perimeter control: it limits which users' prompts can return content from high-sensitivity sites. This skill audits the SAM configuration and reports, identifies sites without active owners, surfaces sites flagged in DAG reports as over-shared, confirms whether restricted access control is deployed for Highly Confidential sites, and checks whether the site lifecycle policy is configured.
## When should you run this skill?
- "Audit SharePoint Advanced Management configuration"
- "Which sites are flagged in data access governance reports?"
- "Find SharePoint sites with no active owner"
- "Check if restricted access control is enabled for sensitive sites"
- "Review SAM governance configuration before Copilot rollout"
- "Audit SharePoint site ownership policies"
## How this skill works, step by step
1. Open the SharePoint admin centre → Reports → Data access governance
2. Export the "Sites shared externally" and "Sites with sensitivity labels" DAG reports
3. In the SharePoint admin centre → Policies → Sharing, confirm the site-level sharing override is set to require admin approval for new guest invitations on sensitive sites
4. Navigate to SharePoint admin centre → Sites → Active sites → filter for sites with no owners or only inactive owners (last activity > 90 days) using the site ownership policy report
5. Run `Get-SPOSite -Filter {RestrictedAccessControl -eq $true}` via SharePoint Online Management Shell to list sites with restricted access control (RAC) enabled
6. Identify Highly Confidential or PROTECTED-labelled sites that do NOT have RAC enabled — these are Copilot grounding risks
7. Review the site lifecycle policy: SharePoint admin centre → Policies → Site lifecycle management — confirm active-owner attestation is enabled and the expiry period is set
8. Export the change history report for governance events in the review period
9. Score each finding: High (Highly Confidential site without RAC or no active owner), Medium (over-shared site in DAG report, no lifecycle policy), Low (minor configuration gap)
## Output format
| Site | Sensitivity Label | Restricted Access Control | Active Owner | DAG Flag | Risk | Recommendation |
| --- | --- | --- | --- | --- | --- | --- |
| /sites/ExecComms | Highly Confidential | No | Yes | No | High | Enable restricted access control |
| /sites/ProjectAlpha | Confidential | Yes | No | Yes | High | Assign active owner, trigger attestation |
| /sites/HRPolicies | Confidential | Yes | Yes | No | Low | Compliant |
Summary:
- Sites with restricted access control: N of N sensitive-labelled sites
- Sites with no active owner: N
- Sites flagged in DAG over-sharing reports: N
- Site lifecycle policy active: Yes/No
- High-risk sites: N
## Scope and safety
Read-only by default — this skill does NOT:
- Modify site permissions or sharing settings
- Enable restricted access control on any site
- Assign or remove site owners
## Licensing and permissions
### Licences and add-ons
| Capability used | Minimum licence |
| --- | --- |
| SharePoint Advanced Management (DAG reports, site ownership policy, restricted access control) | Microsoft 365 E5, or SharePoint Advanced Management add-on |
| Restricted access control (RAC) for Copilot data perimeter | SharePoint Advanced Management add-on |
### Least-privilege roles
- SharePoint Administrator (read DAG reports, site ownership policy, restricted access control status)
- Global Reader (read-only tenant-wide SharePoint admin centre access)
### Microsoft Graph permissions (read-only)
- `Sites.Read.All` — enumerate SharePoint sites and their configuration properties
- `Sites.FullControl.All` is NOT required — read-only review only
- DAG reports and site ownership policy data are accessed through SharePoint admin centre and SharePoint Online Management Shell (`Get-SPOSite`, `Get-SPOSiteGroup`)
## Sources and compliance
- [SharePoint Advanced Management overview (Microsoft Learn)](https://learn.microsoft.com/en-us/sharepoint/advanced-management)
- [Restricted access control for SharePoint sites (Microsoft Learn)](https://learn.microsoft.com/en-us/sharepoint/restricted-access-control)
- [Data access governance reports for SharePoint (Microsoft Learn)](https://learn.microsoft.com/en-us/sharepoint/data-access-governance-reports)
- Supports Essential Eight ML2 evidence for Control 4 (restrict administrative privileges — SharePoint site ownership governance)
- Aligns with PSPF protective marking requirements: restricted access control limits Copilot grounding for PROTECTED content
- Pair with SharePoint Oversharing Audit and External Sharing Deep Audit for complete SharePoint governance coverage
- Output in Australian English
How to use this skill
- Get the file. Download or copy the
SKILL.mdfrom the panel above. - Load it into your host:
- Microsoft 365 Copilot / Copilot Studio — add it as the instructions of a declarative agent or Copilot Studio agent.
- Claude (Cowork / Claude Code) — drop the file into your skills folder; it loads as an Agent Skill automatically.
- Any chat host — paste the file contents as your prompt.
- Grant read-only access. Assign the least-privilege roles and Microsoft Graph scopes listed in Licensing and permissions below.
- Provide your tenant scope and run it (a site, a collection, or the whole tenant).
- Review the report and action the risk-ranked recommendations.
This skill is read-only by default — it inspects and reports, and never changes your tenant.
SharePoint Advanced Management Site Governance Audit
TL;DR: This skill audits the Microsoft SharePoint Advanced Management capability set — data access governance, restricted access control, site ownership policies, and Copilot readiness — to surface governance gaps in the SharePoint estate and produce a prioritised remediation table.
What does the SharePoint Advanced Management site governance audit cover?
Microsoft SharePoint Advanced Management (SAM), included in Microsoft 365 E5 and available as an add-on, provides a set of governance capabilities that extend beyond the base SharePoint Online feature set. It includes data access governance (DAG) reports surfacing over-shared sites, restricted access control for site-level data perimeters, site ownership policies that enforce minimum active-owner requirements, and change history for governance events. As organisations roll out Microsoft 365 Copilot, SAM’s restricted access control becomes a critical data perimeter control: it limits which users’ prompts can return content from high-sensitivity sites. This skill audits the SAM configuration and reports, identifies sites without active owners, surfaces sites flagged in DAG reports as over-shared, confirms whether restricted access control is deployed for Highly Confidential sites, and checks whether the site lifecycle policy is configured.
When should you run this skill?
- “Audit SharePoint Advanced Management configuration”
- “Which sites are flagged in data access governance reports?”
- “Find SharePoint sites with no active owner”
- “Check if restricted access control is enabled for sensitive sites”
- “Review SAM governance configuration before Copilot rollout”
- “Audit SharePoint site ownership policies”
How this skill works, step by step
- Open the SharePoint admin centre → Reports → Data access governance
- Export the “Sites shared externally” and “Sites with sensitivity labels” DAG reports
- In the SharePoint admin centre → Policies → Sharing, confirm the site-level sharing override is set to require admin approval for new guest invitations on sensitive sites
- Navigate to SharePoint admin centre → Sites → Active sites → filter for sites with no owners or only inactive owners (last activity > 90 days) using the site ownership policy report
- Run
Get-SPOSite -Filter {RestrictedAccessControl -eq $true}via SharePoint Online Management Shell to list sites with restricted access control (RAC) enabled - Identify Highly Confidential or PROTECTED-labelled sites that do NOT have RAC enabled — these are Copilot grounding risks
- Review the site lifecycle policy: SharePoint admin centre → Policies → Site lifecycle management — confirm active-owner attestation is enabled and the expiry period is set
- Export the change history report for governance events in the review period
- Score each finding: High (Highly Confidential site without RAC or no active owner), Medium (over-shared site in DAG report, no lifecycle policy), Low (minor configuration gap)
Output format
| Site | Sensitivity Label | Restricted Access Control | Active Owner | DAG Flag | Risk | Recommendation |
|---|---|---|---|---|---|---|
| /sites/ExecComms | Highly Confidential | No | Yes | No | High | Enable restricted access control |
| /sites/ProjectAlpha | Confidential | Yes | No | Yes | High | Assign active owner, trigger attestation |
| /sites/HRPolicies | Confidential | Yes | Yes | No | Low | Compliant |
Summary:
- Sites with restricted access control: N of N sensitive-labelled sites
- Sites with no active owner: N
- Sites flagged in DAG over-sharing reports: N
- Site lifecycle policy active: Yes/No
- High-risk sites: N
Scope and safety
Read-only by default — this skill does NOT:
- Modify site permissions or sharing settings
- Enable restricted access control on any site
- Assign or remove site owners
Licensing and permissions
Licences and add-ons
| Capability used | Minimum licence |
|---|---|
| SharePoint Advanced Management (DAG reports, site ownership policy, restricted access control) | Microsoft 365 E5, or SharePoint Advanced Management add-on |
| Restricted access control (RAC) for Copilot data perimeter | SharePoint Advanced Management add-on |
Least-privilege roles
- SharePoint Administrator (read DAG reports, site ownership policy, restricted access control status)
- Global Reader (read-only tenant-wide SharePoint admin centre access)
Microsoft Graph permissions (read-only)
Sites.Read.All— enumerate SharePoint sites and their configuration propertiesSites.FullControl.Allis NOT required — read-only review only- DAG reports and site ownership policy data are accessed through SharePoint admin centre and SharePoint Online Management Shell (
Get-SPOSite,Get-SPOSiteGroup)
Sources and compliance
- SharePoint Advanced Management overview (Microsoft Learn)
- Restricted access control for SharePoint sites (Microsoft Learn)
- Data access governance reports for SharePoint (Microsoft Learn)
- Supports Essential Eight ML2 evidence for Control 4 (restrict administrative privileges — SharePoint site ownership governance)
- Aligns with PSPF protective marking requirements: restricted access control limits Copilot grounding for PROTECTED content
- Pair with SharePoint Oversharing Audit and External Sharing Deep Audit for complete SharePoint governance coverage
- Output in Australian English