Get version history of all items in a list

Question

I'm looking for a way to get a list of all the status changes of every item in a SP2007 document library. I want to build some reports that show the average length of time a document spent in a given status, how frequently a given chain of status changes occurred, and other analyses of this type.

I know I can get this data with web services by using Lists.GetVersionCollection() to get the history of the Status field and calling this function on every item in the collection obtained from Lists.GetListItems(). But this seems like an unnecessarily complicated way to handle the problem, and also a slow one because as the list size grows, the number of SOAP calls performed to get the list data will increase.

Is there a more direct way to get the data I'm looking for?

Answer 1

In Sharepoint 2007, there are only two ways to get data from list. One is server object model and other is from web services. Client object model and REST API's are not supported in Sharepoint 2007.

So either you can use server object model or the sharepoint webservices.