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
query).