Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

need to get info from large sharepoint 2007 site collection

Posted on 2013-06-14
3
Medium Priority
?
628 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 1500 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

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 Backup & Restore 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.
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

636 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