SharePoint Workflow Audit Kit — SP2010 & SP2013 Workflows

Workflows are the #1 cause of SharePoint migration delays. SP2013 workflows are not automatically compatible with SharePoint Subscription Edition — you need to know exactly what you have, where it is, and whether it's active.

This kit gives you five production-ready scripts to fully audit your workflow landscape before a single database moves.

What's Included

Get-SPWorkflowAudit.ps1 Scans all site collections for SP2013 workflows (both list and site workflows). Reports workflow name, association, status, number of instances, last run date, and platform. Exports to CSV.

Get-SPWorkflowAudit-SQL.ps1 Direct SQL-level workflow audit for environments where the SharePoint API is incomplete or throttled. Queries workflow tables directly for a complete picture. Useful for large farms and farms with performance constraints.

Add-WorkflowPlatformToCSV.ps1 Enriches the workflow inventory CSV with platform classification (SP2013 native vs Nintex vs Power Automate). Prepares the data for stakeholder reporting.

Generate-WorkflowReports.ps1 Converts raw workflow data into formatted HTML reports — one per site collection and one farm-wide summary. Ready for steering committee sign-off.

Fix-SPContentDatabasePermissions.ps1 Fixes content database permission issues that block workflow audit queries — a common blocker when running audits in locked-down environments.

Who This Is For

• SharePoint admins who need to assess workflow migration risk
• Project managers who need a workflow inventory for stakeholder sign-off
• Consultants running pre-migration assessments for enterprise clients

Requirements

• SharePoint 2019 (farm with SP2013 workflows or Nintex)
• PowerShell 5.1+
• Farm Administrator permissions
• SQL Server access for the SQL audit script

What You Get

• 5 PowerShell scripts (.ps1)
• README with step-by-step usage guide
• Sample HTML report output
• Single-farm license

Time Saved A manual workflow audit on a 50-site-collection farm takes 2–3 days. These scripts do it in under 2 hours.