none
How do I find the size of MySite?

    Question

  • Hi All,

    I am trying to find the size occupied by MySite of a specific user can anybody please suggest as how to go about the same .

    Regards
    Srujan.N
    srujan
    • Changed type Mike Walsh FIN Wednesday, December 30, 2009 8:28 AM always use the Question Type so people get credit for their replies
    • Edited by Mike Walsh FIN Wednesday, December 30, 2009 8:29 AM Title made into a question
    • Moved by Mike Walsh FIN Wednesday, December 30, 2009 8:29 AM MySite q so Social Computing forum (From:SharePoint - Setup, Upgrade, Administration and Operation)
    Wednesday, December 30, 2009 7:48 AM

Answers

  • Hi,

    You could also try using stsadm -o enumsites?

    For example, to get a list of all mysite sites as an XML output which you could then open in Excel showing the number, URL, owner, content database, storage used, storagewarning and storagemax try on the server:

    1: stsadm -o enumsites -url http://mysites >mysites.xml
    2: Open the mysites.xml in Excel
    3: Search for the mysite of the specific user in the users url column

    Or, you could try using the GEListAllSites located on codeplex which will give you more info located at http://gelistallsites.codeplex.com/

    Cheers

    Geoff

    • Marked as answer by Lu Zou-MSFT Monday, January 04, 2010 2:32 AM
    Wednesday, December 30, 2009 9:48 AM

All replies

  • Hi,

    Try this from SQL management studio from a query selecting your content db

    select FullUrl As SiteUrl, 
    CAST((CAST(CAST(DiskUsed as decimal(18,2))/1024 As 
    decimal(18,2))/1024) AS Decimal(18,2))   AS  'Total Size in MB'
    from sites


    this will give you a list of all sites and its size
    Best Regards, Ammar MCT
    Wednesday, December 30, 2009 9:24 AM
  • Hi,

    You could also try using stsadm -o enumsites?

    For example, to get a list of all mysite sites as an XML output which you could then open in Excel showing the number, URL, owner, content database, storage used, storagewarning and storagemax try on the server:

    1: stsadm -o enumsites -url http://mysites >mysites.xml
    2: Open the mysites.xml in Excel
    3: Search for the mysite of the specific user in the users url column

    Or, you could try using the GEListAllSites located on codeplex which will give you more info located at http://gelistallsites.codeplex.com/

    Cheers

    Geoff

    • Marked as answer by Lu Zou-MSFT Monday, January 04, 2010 2:32 AM
    Wednesday, December 30, 2009 9:48 AM