Solved

need to get info from large sharepoint 2007 site collection

Posted on 2013-06-14
3
605 Views
Last Modified: 2013-09-25
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
Comment
Question by:socan
  • 2
3 Comments
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 39250414
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
 

Author Comment

by:socan
ID: 39250465
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
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
ID: 39320235
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question