How to get total size used for each site & sub site? RRS feed

  • Question

  • Hello

    We have 100's of SP2003 teams sites. We are planning to migrate to SP2010. Before migrate to SP2010, we want to analyze the all the team sites and document libraries that how sites and document librarues are old and when it was accessed last time. Is there any sql query to generate this type of information in CSV or in spreadsheet in four columns i.e. site collection url, creation date, last accessed date and total size.

    I saw http://www.codeproject.com/KB/dotnet/QueriesToAnalyzeSPUsage.aspx, but somehow I could not able to manage it.

    Let me know if someone having better idea.


    Tuesday, November 15, 2011 9:36 AM


All replies

  • This isn't a very easy one to manage, as the STSADM Commands for this version of SharePoint are quite raw and as such don't give you much to work with.  Because this is quite an old version of SharePoint, I doubt they';ll be many commercial tools available for it.

    What I did for this was to set a threshold for my site collections and any that fell under a particular size I didn't look at.  I also checked the analytics for each site and anything that hadn't been accessed for 30 days either I excluded.

    One product I DID find useful was Metalogix Site Migrator for SharePoint.  I'm not affiliated with the firm but as a tool it allowed me to bypass having to have SP2007 handy for my upgrade.

    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    Tuesday, November 15, 2011 10:05 AM
  • Avi

    See this http://www.vyapin.com/products/sharepoint/sps-2003/arksp/sharepoint-2003-reports.htm.

    Hope this helps you.



    Ashish Kanoongo, MCP, MCSD, MCTS
    Tuesday, November 15, 2011 3:04 PM
  • Ashish

    Thanks for url. Is thee any limitation for their trail version and after installing there should be conflict in the DLL?

    Is there any other site or forum where I can see the SQL Queries?

    Wednesday, November 16, 2011 9:31 AM
  • Hi Avikumar,

    As I know, ARKSP tool as Ahsish has suggested, is a convenient tool to meet your requirement, you can try to download a correct version of it to check, as your SharePoint version is 2003, the Admin Report Kit for SharePoint 2003 is suitable, it will not influence your environment and be conflicted with the files.


    Thursday, November 17, 2011 2:55 AM