cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List of all Nintex Forms in use by list/library for each site?

Jump to solution

What would be the best (easiest) way to find all lists/libraries in which currently use Nintex Forms 2010.  Does each have to be combed through individually and opened, or is there a possible script (PowerShell perhaps) that could query each site level that someone has had success with?  (Looking to make some uniform changes and we want to be sure we have all our sites covered)

Labels: (3)
Tags (2)
0 Kudos
Reply
8 Replies
Community Manager Community Manager
Community Manager

Re: List of all Nintex Forms in use by list/library for each site?

Jump to solution

You should look I to the following link. I think this would greatly help you achieve what you are looking for.

https://community.nintex.com/community/tech-blog/blog/2015/02/06/know-your-workflow

Eric

0 Kudos
Reply
Not applicable

Re: List of all Nintex Forms in use by list/library for each site?

Jump to solution

We have ran the script, and unfortunately it did not return any results from our NintexForms database (it did from all of our NintexWorkflow databases, so I believe it worked correctly)

We went directly to the NintexForms database and ran a query against all of the tables within...which returned no results.

Is it safe to assume then we have no NintexForms in use anywhere in our farm if there were no performance results, nor records returned??  (Or do we not have our database configured correctly and it is not capturing anything?)  We are attempting to confirm we don't have any in use, and if so...where.

0 Kudos
Reply
Workflow Hero

Re: List of all Nintex Forms in use by list/library for each site?

Jump to solution

I would say its probably not safe to assume, since the description of the script only talks about workflows.  I'd contact support to see if they have something to run to determine forms in use.

0 Kudos
Reply
Not applicable

Re: List of all Nintex Forms in use by list/library for each site?

Jump to solution

Unfortunately Support advised me this is not something they support (only things like errors and breakages) and to pose the question to the Community...

0 Kudos
Reply
Workflow Hero

Re: List of all Nintex Forms in use by list/library for each site?

Jump to solution

Someone asked me the same question so I started checking properties of list content types with PowerShell looking for something that would indicate that there was a Nintex form associated with the content type. This worked for me on my 2013 farm:

$site = Get-SPSite "your site collection url here"

# loop through webs

foreach ($web in $site.AllWebs)

{

  <# These properties are on the content type with a customized Nintex Form

        DisplayFormTemplateName     : NFListDisplayForm

        EditFormTemplateName          : NFListEditForm

        NewFormTemplateName         : NFListEditForm

        NewFormUrl                             :

        MobileNewFormUrl                  : _layouts/15/NintexForms/Mobile/NewForm.aspx

        EditFormUrl                              :

        MobileEditFormUrl                   : _layouts/15/NintexForms/Mobile/EditForm.aspx

        DisplayFormUrl                        :

        MobileDisplayFormUrl             : _layouts/15/NintexForms/Mobile/DispForm.aspx

    #>

# Loop through the lists and content types    

    foreach ($list in $web.Lists) {

        foreach ($ct in $list.ContentTypes){

            if ($ct.NewFormTemplateName -eq "NFListEditForm")

            {

                write-host "List Name: " $list.Title" - "$web.Url"/"$list.RootFolder.Url

                write-host "Content Type Name: " $ct.Name

                write-host ---------------------------

            }

        }

    }

    $web.Dispose()

}

$site.Dispose()

Hope this helps get you started!

0 Kudos
Reply
Workflow Hero

Re: List of all Nintex Forms in use by list/library for each site?

Jump to solution

I modified 's script a bit to loop through the entire farm and export the results to a CSV.  Just as a disclaimer for anyone using this, it will be a bit more resource intensive than Sabrina's as it will be parsing through the content types across the entire farm. I tested this in 2013 and it functioned as expected.

Add-PSSnapin Microsoft.SharePoint.PowerShell
function Get-NintexForms()
{$SPWebApps=Get-SPWebApplication
foreach($SPwebApp in $SPWebApps)
    { foreach ($SPSite in $SPWebApp.Sites)
        {
            if ($SPSite -ne $null)
            {
                # loop through webs
                foreach ($web in $SPsite.AllWebs)
                {
                    foreach ($list in $web.Lists) {
                        foreach ($ct in $list.ContentTypes){
                            if ($ct.NewFormTemplateName -eq "NFListEditForm")
                            {
                             $index = @{"[URL]"=$web.Url;"[List Name]"=$list.Title;"[Content Type Name]"=$ct.Name}
                                New-Object PSObject -Property $index | Sort-Object
                            }
                        }
                    }
                }
            }
        }
    }
}
Get-NintexForms | Export-Csv C:\FormsOutput.csv
$web.dispose()
$SPSite.dispose()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Hope this helps for anyone trying to track down all of their forms!

Reply
Workflow Hero

Re: List of all Nintex Forms in use by list/library for each site?

Jump to solution

Is there a way to export the latest version of forms to a folder?

Reply
Workflow Hero

Re: List of all Nintex Forms in use by list/library for each site?

Jump to solution

If you add $list.Id =  "List ID" to the index line in the script, you could use the generated csv file to export the XML for each list form. The SDK will provide a web service reference to retrieve the form XML based on the list ID, so I'm sure the two could be patched together to meet that need. 

SDK GetFormXML Reference

Reply