?
Solved

need to get info from large sharepoint 2007 site collection

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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

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…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

770 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