SharePoint Products TechCenter >
SharePoint Products and Technologies Forums
>
SharePoint - Workflow
>
Workflow History
Workflow History
- Can anyone tell me what table the workflow history is stored in? i am looking to write a report for users that show workflows in progess, complete, ect.
All Replies
- Its usually stored in a list called Workflow History that is hidden from the View All Site Contents section.
To get to that list, type the URI manually:
Http://<siteUrl>/Lists/Workflow History/AllItems.aspx
But sometimes the workflow history list would have a different name (if you create a new workflow with a new workflow history list, the name will appear in the workflow settings association form), if that is the case with you, then just replace Workflow History with whatever name you get from workflow settings
Dennis Alzoubi - You can also view workflow history for a specific item by clicking on item's dropdown then selecting 'Workflows'.
Then under 'Running Workflows' select the workflow you want to view the history for.
The workflow history is on the next page that loads at the bottom. - I know that you have the option to do that nab89. I am trying to write reports of what workflows have run for what users so that really doesnt help me much
- Dennis my workflow is not writing anything to this list. the list is still blank yet I have started and completed workflows. Is it possible that it is writing information to somewhere else?
- As I mentioned in the first reply, check your workflow settings for the namer of the workflow history list that your workflow is attached to. and " just replace Workflow History with whatever name you get from workflow settings"
Dennis Alzoubi- Edited byDennis Alzoubi Friday, November 06, 2009 6:10 PMfixed typo mistake
- I guess I dont understand where I am suppose to change this setting. I need some clarification . if I go into my list setting and click on workflow settings I dont see where I adjust workflow history. can you step me through it?
- Hi David,
To get the workflow history list name, go to List Seetings->Workflow settings -> click on the Workflow name -> Find the name fo the History list from this page.
Then goto http://<siteUrl>/Lists/[HistoryListName]/AllItems.aspx - If you're using VS workflows then the History List is specified when you first create the worfklow. You can change it afterwards by clicking on the worfklow in the Solution Explorer and changing the history list in the properties window. Of course you would need to redeploy the worklow once you've made that change.
EDIT: The above is correct but you can edit this in workflow settings as stated by Remya and Dennis above, only if it is a VS workflow though. For designer WFs you will just get an error saying that you need SharePoint Designer to edit the workflow. - Ok I dont know if I am being clear. This workflow is being created in designer it is checking a couple of conditions and if the item meets the condition it sends an email. I can not access the workflow in the workflow setting cause it was created in designer. I need to have this informaiton written out the the workflow history page. Is it not possibble using designer??? do I have to use visual studio???
Are you sure you're typing in the right URL? I have several designer workflows and I can view the workflow history by typing in the default list http://domain/site/subsite/lists/Workflow History/AllItems.aspx, where 'subsite' is where my workflow is deployed on a list. Perhaps you accidentally viewed the Workflow History list for the wrong site?
- I viewed the correct site. i double checked and I have nothing in the workflow history list
- I've been looking through the workflow history lists for the designer workflows and noticed that everything that's been logged is to do with errors, for example 'Error updating a list item', 'Modified by unauthorised user' and 'The email message cannot be sent' etc.
Is it possible that only errors are logged to the history list, and maybe that is the reason there isn't anything in your workflow history? - I am not sure. this workflow as of right now just looks for 1 field it the field is equal to yes it send an email. So I am not sure how I would get that to error out.
- You could try sending an email in the workflow, and putting a made up email address to send it to. Or you could use a lookup of an empty field in the item, that must generate an error.
EDIT:
David, you can use a 'Log to history list' activity in SPD, that should write to the history list. Or are you doing that already?
