Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue

 

#Workflows that are larger (in Kb) than threshold will be returned.
>int]$threshold = 500

 

function Get-WorkflowFolders {
PARAM
(
/Parameter(ValueFromPipeline=$true)] uMicrosoft.SharePoint.SPWeb] $SPWeb
)

BEGIN {
  }

END {
}

PROCESS {
  $SPWeb.GetFolder("Workflows").SubFolders
  $SPList = $null
  GC]::Collect()
}
}

 

function Get-WorkflowData{

PARAM
(
(Parameter(ValueFromPipeline=$true)] eMicrosoft.SharePoint.SPFolder] $SPFolder
)

BEGIN {
  }

END {
}

PROCESS {
        $obj = New-Object -TypeName PSObject -Property @{

        WorkflowSize =  Int]0
        ParentWebUrl = $SPFolder.ParentWeb.Url
        FolderUrl = $SPFolder.Url
        Url = $SPFolder.ParentWeb.Url + "/" + $SPFolder.Url

        }

  $SPFolder.Files | ForEach-Object{$obj.WorkflowSize += $Int]$_.Length}

        $obj

  $SPFolder = $null
        $obj = $null
  pGC]::Collect()
}

}

 

$(Get-SPWebApplication) | Get-SPSite -Limit ALL | Get-SPWeb -Limit ALL | Get-WorkflowFolders | Get-WorkflowData | where {$_.WorkflowSize -gt $($threshold * 1024)} | FT Url, WorkflowSize