locked
How to fiind a list of site collections in web applications RRS feed

  • Question

  • Hi,

    I had 300 to 400 site collection in one web application is there any way to find the list of site collections in that web application or list of site collection in total farm.  

    I know we can see one by one in central admin under site collection list but i want ot make a list of all site collections in web application it will take lot of time if I go one by one.

    Thanks in advance

    Thursday, November 17, 2011 7:31 PM

Answers

  • Hi,

    use 

    stsadm -o enumsites -url http://xxxxxxxx > T:\sitecollectionlists\list.txt

    please let us know if this will help you or not

     


    Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/ | Posting is provided "AS IS" with no warranties, and confers no rights
    • Edited by Pratik Vyas Thursday, November 17, 2011 8:25 PM
    • Marked as answer by Emir Liu Friday, November 25, 2011 4:16 PM
    Thursday, November 17, 2011 8:24 PM
  • You can write a VB macro in Excel to strip out the remainder of the information you don't need, or spend 10 minutes with create use of Find-Replace.  It's not too challenging.
    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    • Marked as answer by Emir Liu Friday, November 25, 2011 4:16 PM
    Thursday, November 17, 2011 9:41 PM
    Answerer
  • Hi,

    you can redirect your output to .xml and open the xml file in excel.

    Eg:

    stsadm -o enumsites -url http://xxxxxxxx > T:\sitecollectionlists\list.xml


    VinodKumar Pottal
    • Marked as answer by Emir Liu Friday, November 25, 2011 4:16 PM
    Friday, November 18, 2011 9:13 AM

All replies

  • Hi Mimi,

    use following stsadm command

    stsadm -o enumsites -url <SITE URL> > filename.txt

    this will generate a text file with a list of all site collection under a SITE URL, you have to manually write each web portal name.

    hope this helps.


    Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/ | Posting is provided "AS IS" with no warranties, and confers no rights
    Thursday, November 17, 2011 7:51 PM
  • Hi I tried to use the below script, but it is no working

    stsadm -o enumsites -url http://xxxxxxxx filename "T:\sitecollectionlists\list.txt"

    did i made any mistake.

     

    Thursday, November 17, 2011 8:22 PM
  • Hi,

    use 

    stsadm -o enumsites -url http://xxxxxxxx > T:\sitecollectionlists\list.txt

    please let us know if this will help you or not

     


    Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/ | Posting is provided "AS IS" with no warranties, and confers no rights
    • Edited by Pratik Vyas Thursday, November 17, 2011 8:25 PM
    • Marked as answer by Emir Liu Friday, November 25, 2011 4:16 PM
    Thursday, November 17, 2011 8:24 PM
  • Thanks it worked, but it gives all site collection lists, owner, database name, storage limit.

    is there any way that I get only list of site collections.

    Thanks in advance.

    Thursday, November 17, 2011 8:54 PM
  • You can create Excel file instead a txt file and from excel file you can filter them out 
    Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/ | Posting is provided "AS IS" with no warranties, and confers no rights
    Thursday, November 17, 2011 9:28 PM
  • You can write a VB macro in Excel to strip out the remainder of the information you don't need, or spend 10 minutes with create use of Find-Replace.  It's not too challenging.
    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    • Marked as answer by Emir Liu Friday, November 25, 2011 4:16 PM
    Thursday, November 17, 2011 9:41 PM
    Answerer
  • Hi,

    you can redirect your output to .xml and open the xml file in excel.

    Eg:

    stsadm -o enumsites -url http://xxxxxxxx > T:\sitecollectionlists\list.xml


    VinodKumar Pottal
    • Marked as answer by Emir Liu Friday, November 25, 2011 4:16 PM
    Friday, November 18, 2011 9:13 AM