Skip to main content
Nintex Community Menu Bar
Question

How do I get a list of all Nintex forms, their site location and their Development/Published status?


Forum|alt.badge.img+2

What’s the best way to get a list of all Nintex forms, their site location and their Development/Published status in our SharePoint 2016 on-premises environment?

Translate
Did this topic help you find an answer to your question?

4 replies

Forum|alt.badge.img+12
  • Apprentice
  • 292 replies
  • May 21, 2024

Did you try checking in the SharePoint 2016 central administration site under Nintex section? 

Translate

Forum|alt.badge.img+2
  • Author
  • Novice
  • 6 replies
  • May 21, 2024

Definitely, - I’ve also tried the Know Your Workflows and other PowerShell scripts we’ve been sent over the years.  

 

The closest we’ve been able to get so far is with the script below, but it doesn’t seem to be differentiating between TEST and PROD forms:

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
Get-SPSite -Limit ALL | Get-SPWeb -Limit ALL | ForEach-Object {

  # For each subsite ($_), get the items in the "NintexForms" list. 
  foreach ($item in $_.Lists["NintexForms"].Items)
  {
      #For each list in the NintexForms list
      #Write-host "Beginning search for Nintex Forms in :" $_.url
      $List = $_.Lists | where {$_.ID -eq $item["FormListId"]}

      if($List -ne $null )
      {
        #if (($item.Level -notcontains "Draft") -and ($item.Level -eq "Published") -and($_.ContentType.Name -eq "Document"))
        if ($item.Level -eq "Published")
        {

            $_.url + " " + $List.Title 

        }
      }
  }

 

Translate

bamaeric
Forum|alt.badge.img+13
  • Apprentice
  • 463 replies
  • May 21, 2024

I have had good luck in the past finding forms in our environment using the FORMulator tool from Kudzu Software. Here is link to more information about it: https://formulator.kudzusoftware.com

I would also look into the Nintex Analytics application if you have that available as part of your license.

Translate

Forum|alt.badge.img
  • Novice
  • 1 reply
  • June 19, 2024

# Get all Nintex Forms

$datestamp = Get-Date -Format "MMddyyyy"
$output = "C:\NintexForms_$datestamp.csv"
$erroroutput = "C:\NintexFormsErrors_$datestamp.csv"
$results = @()
$errorresults = @()

$sites = Get-SPWebApplication | ?{$_.Url -match "webapp"} | Get-SPSite -Limit All

foreach ($site in $sites){
    foreach ($web in $site.AllWebs){
        try{
            $formlib = $web.Lists | ? { $_.Title -eq "NintexForms" }
            if ($formlib.Title -ne $null){
                $forms = $formlib.GetItems() # | ? { $_.Name -notlike "*.preview.xml" } #Exlude Draft forms
                foreach ($form in $forms){
                    [xml]$xml = $form.Xml
                    $list = $web.Lists | ? { $_.ID -eq $form.Properties.FormListId }
                    $result = [pscustomobject]@{
                        Form             = $form.Name
                        FormModifiedDate = $xml.ChildNodes.ows_Modified
                        FormStatus       = $form.level
                        SiteID           = $site.ID
                        SiteURL          = $site.Url
                        WebId            = $web.ID
                        WebURL           = $web.Url
                        ListID           = $list.ID
                        ListType         = $list.BaseType
                        ItemCount        = $list.ItemCount
                    }
                    $results += $result
                }
            }
        }
        catch{
            $ErrorMessage = $Error[0].Exception
            $errorresult = [pscustomobject]@{
                Site   = $site.Url
                SiteID = $site.ID
                Error  = $ErrorMessage 
            }
            $errorresults += $errorresult   
        }
    }
}
$results | Export-Csv -Path $output -NoTypeInformation
if ($errorresults.Count -ne 0) { $errorresults | Export-Csv -Path $erroroutput -NoTypeInformation }
 

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings