Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 638
  • Last Modified:

need to get info from large sharepoint 2007 site collection

I have a sharepoint server 2007 farm hosted on SQL 2005 running on windows 2003 with a fairly large site collection and over 500GB content Db. The single site collection has several hundred subwebs under it and it is a publising site. I ran stsadmin command and got the number of subwebs but i was looking for a command (possibly stsadmin) that could enumerate all these subwebs and give information on the number of documents per subwen including information such file name, size, date created, modified, path etc.

Thanks
0
socan
Asked:
socan
  • 2
1 Solution
 
Rainer JeschorCommented:
Hi,
could you please explain, what exactly you want as a result (and the format)?
In general the best way would be some kind of Powershell script, to enumerate through the site collections, webs, subwebs. But then it will be important if you really want to get each and every file information from document libraries or if e.g. a summary for a library is enough.
And how about list item attachments (if activated)?

Thanks and HTH
Rainer
0
 
socanAuthor Commented:
Hi

I am hoping for some sort csv format and the end result needs to be a listing of all documents list with information about the file size, date created, modified, path etc.

Essentially I am trying to look for 2 things:

Old documents that have not been touched in x period that I can archive.
Because if the sheer size of this large site collection I need to find out groupings of suburbs that I can move into a new site collection with new content DBS.

The issue here is the single large site collection with a single content db and multiple sub webs. I need to move to a new farm which has a 150gb limit per content db. So I would try to remove old document and then group suburbs into new site collection with a content db that meets the lower size.
0
 
Rainer JeschorCommented:
Hi,
sorry for the long delay - have been offline due to vacation.
I think the following excellent script should work - just comment the second last line and uncomment the last line (with the export-csv):
http://blog.falchionconsulting.com/index.php/2010/08/getting-an-inventory-of-all-sharepoint-documents-using-windows-powershell/
You might also change the beginning so that you just loop through your single web application.
HTH
Rainer
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now