This is an idea I had recently about workflow logging within SharePoint –
When it comes to workflow event logging – SharePoint has a number of limitations:
The OOTB ‘Workflow History List’ is very un-user friendly, it also can only be accessed through a number of menus from the list item itself. In addition there is a scheduled cleanup job which cleans out the workflow history of items that are over 60 days old with no workflow running on them.
To get round this there is another option, log to a custom list from the workflow:
- Log the event/description and perhaps an incremental ID number to determine which order the events occurred in to a custom list within the SharePoint site
- Report on this list using SQL Reporting Services
SQL Reporting Services can be configured to get data from SharePoint lists so this makes it ideal for a workflow report/audit. This will make much more sense to end users and they will not be confused by the workflow history list.