MOSS Custom Workflow Reporting/Logging

MOSS Custom Workflow Reporting/Logging

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.

:-)

6 thoughts on “MOSS Custom Workflow Reporting/Logging

  1. Mitch

    Alex:

    Your idea that you outline for custom reports on MOSS workflows is pretty good, and I am grappling with the best way to solve the same problem. I was wondering if you had actually taken the idea and coded it? If you have, I would love to know how it works, and how I might be able to do something similar.

    thanks,
    Mitch

    1. alex350r

      Hi Mitch,

      Thanks for your comment – to answer your question yes I have implemented the idea into my workflows and it is working well. I have used a ‘Code’ activity within the workflow itself and have written some custom SharePoint object model code to add an item to the custom list. The custom list contains various columns such as – Workflow Event, Workflow Name, Event Descripton and Event Date/Time.

      To report on the items in the list I have created an SQL Reporting Services Report that the users can open and filter to view the events that occured in the workflow. If you would like any more details just let me know.

      Thanks,

      Alex

  2. Mitch

    Alex:

    I would love to get a copy of the code that you used to add items to the custom list, as well as your reporting services report. This is exactly the problem that I am trying to resolve.

    Mitch

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">