Gonzalo Becerra
asked on
List size of each web application into excel file
Dear All,
I need help to create an script to list from Sharepoint the size of each web application and send to csv file.
Thanks in advance,
I need help to create an script to list from Sharepoint the size of each web application and send to csv file.
Thanks in advance,
Tell me what version of sharepoint do you have, and what version of powershell.
ASKER
Windows 2008 R2 (Powershell V2)
Sharepoint 2010 SP1
Sharepoint 2010 SP1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
jessc7 thanks, it's working perfect, how can I calculate the size in MB?
Thanks in advance,
Thanks in advance,
ASKER
I already discover how to convert to MB
I'm using the following script:
But I cannot see the complete name of the Web Application I see like this: SPWebApplication...
I would like to see the fullname of the Web Application
I'm using the following script:
Get-SPWebApplication | ForEach {$_.ContentDatabases} | Select WebApplication, Name, @{Label ="Size in MB"; Expression = {$_.disksizerequired/1024/1024}}, CurrentSiteCount | Out-File gonza.txt
But I cannot see the complete name of the Web Application I see like this: SPWebApplication...
I would like to see the fullname of the Web Application
ASKER
Thanks a lot for your help:
This is the final version of the script:
This is the final version of the script:
Get-SPWebApplication | ForEach {$_.ContentDatabases} | Select WebApplication, Name, @{Label ="Size in MB"; Expression = {$_.disksizerequired/1024/1024}}, CurrentSiteCount | Sort-Object "Size in MB" -Descending | Out-File WebAppSize.txt
Thanks for the points, and thanks for posting your final solution!