Search All Nintex Forms in a Site Collection or Web App

Hi @jsupchurch you are right, I knew something would not work, it’s probably been 5 years since I used this script, looks like it’s called OpenBinaryStream() now, I’ve updated the code but I haven’t tested it because I don’t have a environment to hand, let me know how you get on. 

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"

$siteUrl = "http://your-sharepoint-site-url"
$username = "your-username"
$password = "your-password"
$searchString = "your-search-string"
$newString = "your-new-string"
$outputFile = "C:\Path\to\output.csv"

$securePassword = ConvertTo-SecureString -String $password -AsPlainText -Force
$credentials = New-Object -TypeName System.Net.NetworkCredential -ArgumentList $username, $securePassword

$foundFiles = @()

function SearchNintexForms([Microsoft.SharePoint.Client.Web]$web, [string]$listTitle, [string]$searchString, [string]$newString) {
    Write-Host "Searching for NintexForms in $($web.Url)/$listTitle"
    $context = $web.Context
    $web.Lists.EnsureSiteAssetsLibrary()
    $list = $web.Lists.GetByTitle($listTitle)
    $context.Load($list)
    $context.ExecuteQuery()

    if ($list.BaseType -eq "DocumentLibrary" -and $list.BaseTemplate -eq 101 -and $list.Title -eq "NintexForms") {
        $camlQuery = New-Object Microsoft.SharePoint.Client.CamlQuery
        $camlQuery.ViewXml = "<View Scope='RecursiveAll'><Query><Where><Eq><FieldRef Name='File_x0020_Type' /><Value Type='Text'>xml</Value></Eq></Where></Query></View>"
        $items = $list.GetItems($camlQuery)
        $context.Load($items)
        $context.ExecuteQuery()

        foreach ($item in $items) {
            $fileUrl = "$($web.Url)/$($list.Title)/$($item["FileLeafRef"])"

            $fileRef = $item.File
            $fileStream = $fileRef.OpenBinaryStream()
            $context.Load($fileRef)
            $context.ExecuteQuery()

            # Use a stream reader to read the content of the file
            $sr = New-Object System.IO.StreamReader $fileStream.Value
            $fileContent = $sr.ReadToEnd()
            $sr.Close()

            if ($fileContent -match $searchString) {
                Write-Host "XML File Location: $fileUrl"
                $foundFiles += [PSCustomObject]@{
                    "FileUrl" = $fileUrl
                }

                $newContentString = $fileContent -replace $searchString, $newString
                $newContentBytes = [System.Text.Encoding]::UTF8.GetBytes($newContentString)

                $fileRef.SaveBinary([Microsoft.SharePoint.Client.ClientContext]::new($fileUrl, $credentials), $newContentBytes)
                $context.ExecuteQuery()
            }
        }
    }

    $subwebs = $web.Webs
    $context.Load($subwebs)
    $context.ExecuteQuery()
    foreach ($subweb in $subwebs) {
        SearchNintexForms $subweb $listTitle $searchString $newString
    }
}

$context = New-Object -TypeName Microsoft.SharePoint.Client.ClientContext -ArgumentList $siteUrl
$context.Credentials = $credentials

$web = $context.Web
$context.Load($web)
$context.Execute Query()

SearchNintexForms $web “NintexForms” $searchString $newString

$context.Dispose()

$foundFiles | Export-Csv -Path $outputFile -NoTypeInformation

Hi @jsupchurch 

yes that scenario can exist and it is done by design, this allows for lists to be transported, restored or Nintex to be completely uninstalled and forms definitions not lost. It causes far more disruption to attempt to link forms to list status. 
 

there is version history on the forms list but I don’t know if it is available on all versions, any file you see in those lists will be the latest version. 
 

as for finding active forms is possible but again for on-prem sadly not straight forward but there are powershell scripts that exist, you essentially need to store a sites list GUIDs, those GUIDs are used in the file name of the form definition, if a form definition exists with a GUID that doesn’t match a list GUID it is an orphan. 
 

I am glad the script is assisting you. 
 

Let me know if I can assist you further.