Assess Your SharePoint 2013 Workflows With Our Nintex Workflow Discovery Script

				
					## The following script is provided for informational and entertainment purposes only. The creators and contributors of this script shall ## not be held liable for any errors, omissions, or damages arising from the use, interpretation, or implementation of the content ## contained herein. The users of this script assume all responsibility and risk associated with its usage.

## By accessing or utilizing this script, you acknowledge and agree to release the creators and contributors from any and all liability ## arising from its use. This limited liability statement applies to all individuals or entities who access, view, or utilize this script ## in any form or manner.

## Copyright © 2023 - Propelle Pty Ltd www.propelle.com.au support@propelle.com.au



##Add DLL references if your session requires them
#Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll"
#Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" -IgnoreWarnings
#Add-Type -Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.WorkflowServices.dll" -IgnoreWarnings

#Select $false if you want a quick scan, or select $true if you want detailed info (ie. if Library and List names have changed since workflows were created)
$detailedScan = $true
$exportXML = $true

$username = "usename@domain.com"
$password = "password^" 
$secureString = $password | ConvertTo-SecureString -AsPlainText -Force 
$creds = New-Object System.Management.Automation.PSCredential -ArgumentList $username, $secureString

$sites = @(
    "https://domain.sharepoint.com/sites/Site1",
    "https://domain.sharepoint.com/sites/Site2",
    "https://domain.sharepoint.com/sites/Site3",
    "https://domain.sharepoint.com/sites/Site4",
    "https://domain.sharepoint.com/sites/Site5"
)

$associations = @()
$count = 0

if ($exportXML) {
    $parentFolder = "Workflows-$(Get-Date -Format "yyyy-MM-dd-HH-mm")"
    $supress = New-Item -Path "c:\temp" -Name $parentFolder -ItemType Directory -ErrorAction Ignore
}

foreach($site in $sites) {

    $count++
    Write-Progress -Activity "Reviewing Site Collection" -Status "$($count)/$($sites.Count) - $($site)" -PercentComplete ($count/$sites.Count*100)

    Connect-PnPOnline -Url $site -Credentials $creds

    $ctx = Get-PnPContext

    $Web = $ctx.Web
    $ctx.Load($Web)
    $ctx.ExecuteQuery()

    $WorkflowServicesManager = New-Object Microsoft.SharePoint.Client.WorkflowServices.WorkflowServicesManager($Ctx, $Web)
    $workflowSubscriptionService  = $WorkflowServicesManager.GetWorkflowSubscriptionService()
    $workflowAssociations = $workflowSubscriptionService.EnumerateSubscriptions()
    $ctx.Load($workflowAssociations)

    if ($exportXML) {
        $workflowDeploymentService = $WorkflowServicesManager.GetWorkflowDeploymentService()
        $workflowDeployments = $workflowDeploymentService.EnumerateDefinitions($true)
        $ctx.Load($workflowDeployments)
    }

    $ctx.ExecuteQuery()

    $wfCount = 0

    foreach ($workflowAssociation in $workflowAssociations) {

        $wfCount++
        Write-Progress -Activity "Reviewing Workflows" -Status "$($wfCount)/$($workflowAssociations.Count) - $($workflowAssociation.PropertyDefinitions["SharePointWorkflowContext.Subscription.DisplayName"])" -PercentComplete ($wfCount/$workflowAssociations.Count*100)
        
        $listTitle = $null
        $listURI = $null
        if ($detailedScan) {
            if ($workflowAssociation.PropertyDefinitions["ListId"]) {
                $list = Get-PnPList -Identity $workflowAssociation.PropertyDefinitions["ListId"] -ErrorAction Ignore
                $listTitle = $list.Title
                $listURI = $list.EntityTypeName
            }
        }
        
        $associations += [PSCustomObject] @{
            WorkflowName                = $workflowAssociation.PropertyDefinitions["SharePointWorkflowContext.Subscription.DisplayName"]
            SiteURL                     = $workflowAssociation.PropertyDefinitions["CurrentWebUri"]
            OriginalListName            = $workflowAssociation.PropertyDefinitions["Microsoft.SharePoint.ActivationProperties.ListName"]
            ListName                    = $listTitle
            ListEntity                  = $listURI
            ModifiedBy                  = $workflowAssociation.PropertyDefinitions["ModifiedBy"]
            Enabled                     = $workflowAssociation.PropertyDefinitions["WSEnabled"]
            AppAuthor                   = $workflowAssociation.PropertyDefinitions["AppAuthor"]
            Created                     = $workflowAssociation.PropertyDefinitions["SharePointWorkflowContext.Subscription.CreatedDate"]
            Modified                    = $workflowAssociation.PropertyDefinitions["SharePointWorkflowContext.Subscription.ModifiedDate"]
        }
    }
    Write-Progress -Activity "Reviewing Workflows" -Completed 

    if ($exportXML) {

        $wfCount = 0
        $supress = New-Item -Path "c:\temp\$($parentFolder)" -Name $($ctx.Web.Title) -ItemType Directory -ErrorAction Ignore

        foreach ($workflowDeployment in $workflowDeployments) {
            
            $wfCount++
            Write-Progress -Activity "Exporting Workflows" -Status "$($wfCount)/$($workflowDeployments.Count) - $($workflowDeployment.DisplayName)" -PercentComplete ($wfCount/$workflowDeployments.Count*100)

            if ($workflowDeployment.Properties["RestrictToType"] -eq "List") {
                $list = Get-PnPList -Identity $workflowDeployment.Properties["RestrictToScope"] -ErrorAction Ignore
                $supress = New-Item -Path "c:\temp\$($parentFolder)\$($ctx.Web.Title)" -Name $list.Title -ItemType Directory -ErrorAction Ignore
                $directory = "c:\temp\$($parentFolder)\$($ctx.Web.Title)\$($list.Title)"
            }
            else {
                $directory = "c:\temp\$($parentFolder)\$($ctx.Web.Title)"
            }

            $xml = $workflowDeployment.Xaml
            $xml | Out-File -FilePath "$($directory)\$($workflowDeployment.DisplayName).xml"
            
        }
        Write-Progress -Activity "Exporting Workflows" -Completed 
    }

}

$associations | Export-Csv -NoTypeInformation -Path "c:\temp\$($parentFolder)\List of Workflows.csv"