Wednesday, April 08, 2009 3:30 PMAll
I need to run a report against version history information. Specifically, show all instances where a column value was changed to 'X' on a specific date. I'm not sure how to approach this problem.
What is the DB table name?
Can the report be done inside SharePoint?
Is there a third party tool that anyone is using for history reporting?
Open to all thoughts
Thursday, April 09, 2009 7:48 AMhi wbbdev,
Go to the list settings of your list-> versioning settings->select yes in item version histry. Save it. So every time yuo go to display form or edit form you will get the link for verson history. Hope this will be helpfull
Thursday, April 09, 2009 7:59 AMHi Pete,
Are you using MOSS or WSS? If you're in MOSS then you could use the content query web part to query all the list and libraries for the change - you can include columns such as modified date and the column that became "X". But I think the CQWP only returns the most recent approved version.
I'm sure you know that you can see one items history through the UI but you can't see lots of them. I can't find any any tools that do the job. So the best solution I can think of is to write some custom code. Rather than read directly from the DB, you should use the UI to query SharePoint. Do you have Visual Studio? If so its quite easy to write out information from the version history - see code below.
Dim listitem As SPListItem = SPContext.Current.ListItem Dim versionhistory As SPListItemVersionCollection = listitem.Versions Dim version As SPListItemVersion For Each version In versionhistory Response.Write(version.VersionLabel & " - " & version.Created.Date & "<BR>") Next
Thursday, April 09, 2009 5:08 PMThanks Mike
I'll give a shot
Monday, July 27, 2009 7:55 PMHi Pete,
Did you ever find a reporting tool for this? I have been looking for weeks and there doesn't seem to reaaly be any documentation or forum threads helping to address this.
Monday, April 26, 2010 7:04 PMAre you still looking for one?
Thursday, May 20, 2010 3:30 PM
Hey WbbDev, I am in the same situation now.Can you reply me how you solved this issue ? Thanks a millions for your time.
You can reach me at email@example.com
Wednesday, April 27, 2011 2:30 PM
Hey anilchow22 and WbbDev,
I am also in this same situation. I have a large list that is on versioning that I need to develop reports off of the changed data.
How can I get to this data?
You can reach me at firstname.lastname@example.org
Wednesday, April 27, 2011 4:20 PM
Here is how you do it:
Get your field names in the xml from Fields information.
Loop through each version of each list item to find the fist version of the list item that has the value changed.
Pull the Modified date from that version.
I just wrote up a blog post with the complete proceses and SQL query here:
Saturday, November 26, 2011 4:43 AM
Check the following post,i am trying to build a List item version report using SP object model
Saturday, March 31, 2012 6:15 PMHere is the codeplex utility to generate detailed versioning report with Version count, size, last modified, etc fields : http://versioningsizereport.codeplex.com/
- Proposed As Answer by Salaudeen Rajack Thursday, September 06, 2012 10:54 AM