Skip to content
tenantcraft
( All guides)

SharePoint Discovery & Inventory Worksheet

Catalogue every SharePoint site before you move anything: size, owners, customizations, and a migrate / consolidate / archive / retire decision for each. A fill-in worksheet, plus where to find every number.

Email me the PDF Free, one email with the link
Topic
Migration
Stage
Discover
In print
7 pages
Last reviewed
May 16, 2026
Cover page of the SharePoint Discovery & Inventory Worksheet

In this guide

  1. 01 One fill-in record per site collection: size, owners, customizations, decision
  2. 02 Where every field comes from: PowerShell, Central Admin, and the SPMT scan
  3. 03 A four-way call on every site: migrate, consolidate, archive, or retire
  4. 04 An exceptions log for the lists, forms, and workflows that can't move as-is

Before you start

Catalogue first, decide second

Every migration mistake traces back to something nobody knew was there: an abandoned site, a form with no owner, a list too large to move cleanly. Discovery is where you find those things while they are still cheap to fix. Work through the whole environment once, write down what you find, and only then decide what moves.

The worksheet has three parts
PartWhat it captures
A · Site collection record One record per site collection, its size, owners, customizations, and migration decision. Copy the page once per site.
B · Environment summary Filled in once: the farm-wide facts that do not belong to any single site.
C · Exceptions & blockers log A running list of the specific objects that need individual attention before they can move.

How to use it

  1. 1Gather the datapage 3 shows where each field comes from
  2. 2Fill a record per sitework Part A site by site, then Part B once
  3. 3Log the blockersanything that cannot move as-is goes in Part C

Section one

Gather the data

Most of the worksheet is counts and dates. Here is where each one comes from, and which fields are genuinely hard to get without help.

Where to find each piece of discovery data
What you needWhere to get it
Site collections, URL, storage, subsites PowerShell: Get-SPSite and Get-SPWeb with -Limit ALL. Or read it from Central Administration.
Content databases and sizes Central Administration → Manage content databases, or Get-SPContentDatabase.
Lists or libraries over 5,000 items A short PowerShell loop over each list’s item count.
Customizations, workflows, large-list and permission blockers An SPMT scan. Its assessment report flags every one. (SMAT, the old tool, no longer works.)
Admin-deployed InfoPath templates Central Administration → Manage form templates.
InfoPath forms on lists, true activity dates, permission sprawl The hard ones. Deeper scripting, or a tool such as ShareGate. Expect to dig.

Work in this order, and avoid these

  • Central Admin first, then a PowerShell farm inventory, then an SPMT scan for the blockers, then targeted deep-dives.
  • Use -Limit ALL on Get-SPSite and Get-SPWeb. Without it you only see the first 20 sites.
  • Count subsites, not just site collections. A small-looking site can hide a dozen.
  • Date your snapshot. A live farm changes daily; re-check the numbers close to cutover.

Part A

Site collection record

21 fields

Complete one record per site collection. Copy or reprint this page as many times as you have sites.

A1 · Identity

Site collection URL
Title / friendly name
Root template (Team / Publishing / Records Centre / other)
SharePoint version (2016 / 2019)

A2 · Ownership

Business owner (name, department)
IT / technical contact
Site collection administrator account(s)

A3 · Size & scale

Storage used (GB) / quota
Subsite count
List & library count
Lists or libraries over 5,000 items (count)

A4 · Activity

Last content change date
Stale? no change in 12+ months (Y / N)

A5 · Complexity flags

Customizations (.wsp, master pages, web parts, SharePoint Designer, note which)
InfoPath forms (count) and 2010 / 2013 workflows (count)
Permissions risk (broken inheritance or unique-permission lists, Y / N)

A6 · Disposition

Decision (migrate / consolidate / archive / retire)
Wave / priority
Target URL (or site to consolidate into)
Remediation needed before move? (Y / N, log in Part C)
Notes

Part B

Environment summary

Fill once

The farm-wide facts that do not belong to any single site. Fill this in once for the whole environment.

The whole environment

SharePoint farm version(s) and number of web applications
Content databases, count and combined size
Managed metadata / term store in use (Y / N, and size)
Workflow / forms platforms (Nintex, K2, other; Y / N, which)
Third-party add-ins and integrations (list them)
Identity: is Entra Connect syncing on-prem AD to the cloud? (Y / N)
Target Microsoft 365 tenant URL
Discovery snapshot date

The four dispositions in Part A

  • Migrate: the site moves as-is to SharePoint Online.
  • Consolidate: its content folds into another site; record that target.
  • Archive: kept read-only for reference or records; not actively migrated.
  • Retire: nothing moves; delete it after any required hold period.

Sort the finished Part A records by decision and wave and you have a migration plan: a schedule, a consolidation map, and a deletion list.

Part C

Exceptions & blockers log

One line for every object that cannot simply move as-is. This is where migration risk actually lives, and the list a consultant will want first.

Exceptions and blockers log
Object / location Issue Detail Action needed Status

Issue types to log: a list over 5,000 items · a surviving InfoPath form · a 2010 or 2013 workflow (both already retired in SharePoint Online) · a custom solution (.wsp) · a list with thousands of unique permissions · an unsupported web part or page. Each one is a decision or a rebuild, not a thing the migration tool will handle on its own.

If the inventory turns up trouble

A finished worksheet is the start of a migration plan.

Discovery is where a migration gets its first honest look at itself: the abandoned sites, the forms nobody owns, the permissions nobody can explain. If your filled worksheet has more in Part C than you expected, that is exactly the conversation TenantCraft's Migration Readiness Assessment is built for. Fixed fee $4,900, five days, and it turns this worksheet into a scoped plan. A discovery call is free, 25 minutes, and ends with a written scope, not a sales pitch.

Web
tenantcraft.ca
Email
hello@tenantcraft.ca
Discovery call
Free · 25 minutes

SharePoint Server 2016 and 2019 reach end of support on July 14, 2026. A full inventory is the first step of any migration, and the one most often rushed.

(Printable copy)

Work from paper, or hand it to someone who will

The PDF is the same document laid out for printing.

You get one email with the link. That's the only email.

Sneak peek

Document preview

100%

Loading the document…