Sometimes small requirements take more time.
My colleague wanted to get all the sites that a web application has and to store it in an Excel file.
After spending the whole day he finally came to me and asked me to help him with a script and subsequently publish it.
So here is the code.
- You have to change the web application and the location of your Excel file you want to generate.
- Save it as a .ps1 file and store it to your location.
This code will provide you the following fields in an Excel file:
- Site’s Title
- Url
- Site’s ID
- Parent Web ID
Code
Get-SPWebApplication My web app here | Get-SPSite -Limit All | Get-SPWeb -Limit All | Select Title, URL, ID, ParentWebID | Export-CSV FileLocationHere\File.csv –NoTypeInformation.
- Click on Start
- Under Microsoft SharePoint 2010 Products you have SharePoint 2010 Management Shell.
- Right-click on it and select Run as administrator.
- Run the following ps1 file and you will get the output generated in an Excel file.
- You have the output
Keep Learning ,
Cheers.