Solved

need to get info from large sharepoint 2007 site collection

Posted on 2013-06-14
3
617 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

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

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

705 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