Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

File-version count required, few options

  Asked By: Geena    Date: Jan 11    Category: Sharepoint    Views: 956

I need to extract a list of all file-versions in a WSS 2003 document repository.
I have been told that there are about 11,000 documents, but I have only found
about 4,100 of them. I don't really want to right-click on each one to see the
version history if I can help it. I've played with the views, but I don't think
they work on that level (I don't see a file attribute called 'version'). I know
that the answer probably involves running an SQL query; however, I am not
familiar enough with WSS to know which table/columns to use and (at the moment)
I don't have direct access to the underlying database. Is there a way to
extract this data using native WSS? If not, where might I find some good
information on the data structure (perhaps I can have a sys admin run the



2 Answers Found

Answer #1    Answered By: Indu Raj     Answered On: Jan 11

Apparently, my Outlook Express is configured to send the alias "Hotmail". I
apologize for that, and take this opportunity to add a few questions to my

The 11,000 documents I mentioned below will have to be categorized and moved
into new repositories for specific teams. To create a strategy for this
migration, I've been swapping files between repositories on the same site
using various methods and was quite pleased to discover that version history
is retained. Will this occur for documents moved to new subsites? On
different servers? Must the variables match? Also, why is a new version
created each time I copy the file?

Answer #2    Answered By: Khushi Srivastava     Answered On: Jan 11

I spent yesterday going through all of the document
repositories on the site and have determined that version control wasn't
actually enabled on any of them. Since this will not always be the case, I
may need this utility in the future. He also has a database explorer
utility available.

Didn't find what you were looking for? Find more on File-version count required, few options Or get search suggestion and latest updates.