Therefore here script number 1: Check for large Nintex workflow lists!
When using Nintex Workflow 2007 and activating the site feature, a hidden list is created in that site called NintexWorkflowHistory. Even time a workflow starts, a Log History action is used, etc an entry is written in this log. Unfortunately this list is not cleaned automatically, potentially becoming a feared "Large List". On one occasion a user had created a workflow that added 200.000 items in just five days to that list. Because it is a hidden list, it does not appear in the GUI and you cannot easily see the size of these lists.
In order to be able to determine where large Nintex lists exist, I have created a PowerShell script.
How to use it:
- Download the PowerShell script
- Open it in a text editor like Notepad
- Change the <url> into the URL of the web application you would like to check
- Run the script
- Open the output in Microsoft Excel and use "*" as separator
http://examples.sharepoint.com/sites/NintexSite * 8927
http://examples.sharepoint.com/sites/NintexSite/SubSite * 5304
http://examples.sharepoint.com/sites/NintexSite2 * 3840
http://examples.sharepoint.com/sites/NintexSite2/SubSite * 10239