skills.rest
pnp
pnpOFFICIAL
Explore all skills by this author →
Website𝕏@m365pnpGitHub

unpublished-content-report

Generate an HTML governance report of unpublished SharePoint documents and pages sorted by staleness.

128|50|Updated May 4, 2026
Search Tags:#governance#sharepoint#copilot#HTML report#draft documents#unpublished content#site pages
One-click install
npx skills add https://github.com/pnp/sharepoint-skills --skill unpublished-content-report-pnp
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: unpublished-content-report
Source: https://github.com/pnp/sharepoint-skills/tree/main/Skills/unpublished-content-report/unpublished-content-report
Command: npx skills add https://github.com/pnp/sharepoint-skills --skill unpublished-content-report-pnp

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Site owners and governance teams struggle to find draft, pending, or checked-out content that has gone stale across SharePoint libraries, making it hard to clean up or publish aging work. ## Core Features & Use Cases - Stale Draft Detection: Identifies documents and site pages that are unpublished and have not been edited for a configurable number of days, using moderation status, version numbers, and checkout state rather than filenames. - Sorted HTML Report: Produces a report with KPI cards and a table sorted by days since last edit descending, saved to a destination document library such as Reports. - Live Refresh: Optionally builds the report with LiveData so results refresh from source libraries each time the file is opened. - Use Case: A site administrator asks for all content not published and not edited in 30 days, and receives a link to a governance report saved in the Governance Reports library. ## Quick Start Ask Copilot in SharePoint to create an HTML report of documents and pages that are not published and have not been edited for 30 days, saved in the Reports library.

Frequently Asked Questions about unpublished-content-report

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I find unpublished documents and pages in SharePoint?▼

Run this skill in Copilot in SharePoint with an inactivity threshold in days. It queries user-facing document libraries and the Site Pages library, detects unpublished items via moderation status, version numbers, and checkout state, and produces a sorted HTML report.

How to report stale draft content on a SharePoint site?▼

Ask for a report of content not published and not edited for a given number of days, such as 14 or 30. The skill calculates whole days since the Modified date, keeps items at or above the threshold, and sorts stalest items first.

Does the report include system libraries like style or asset libraries?▼

No. System, asset, style, preservation, template, report, and AgentAssets libraries are excluded by default. The scope covers user-facing document libraries plus the Site Pages library unless you explicitly include others.

What happens if publication state cannot be determined for a library?▼

Items are not classified as unpublished just because a library lacks moderation or minor versions. If no reliable publication-state signal exists, the item is omitted and the skipped library is noted in the report.

Does the SharePoint report refresh with new data?▼

When built with the LiveData template, the HTML report refreshes from the source libraries each time it is opened. Otherwise it is a point-in-time snapshot, which the completion message states explicitly.

Related Skills

Explore More Data & Analytics Skills→
afoxnyc3afoxnyc3

permission-audit

Audit SharePoint site and library permissions for over-sharing and high-privilege access.

Community
Intermediate
JYeswakJYeswak

linear-aging

Generate aging reports that assign one named owner to every stale issue in a tracker export.

Community
Intermediate
devCharuzudevCharuzu

ms365-tenant-manager

Automate Microsoft 365 tenant setup and administration with PowerShell scripts.

Community
Advanced
Miosa-osaMiosa-osa
226

graph

Analyze knowledge graphs to reveal structural patterns, gaps, and opportunities.

Official
Advanced