Link to home
Start Free TrialLog in
Avatar of Gonzalo Becerra
Gonzalo BecerraFlag for Argentina

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,
Avatar of zaicnupagadi
zaicnupagadi

Tell me what version of sharepoint do you have, and what version of powershell.
Avatar of Gonzalo Becerra

ASKER

Windows 2008 R2 (Powershell V2)

Sharepoint 2010 SP1
ASKER CERTIFIED SOLUTION
Avatar of jessc7
jessc7
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
jessc7 thanks, it's working perfect, how can I calculate the size in MB?

Thanks in advance,
I already discover how to convert to MB

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

Open in new window


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
Thanks a lot for your help:

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

Open in new window

Thanks for the points, and thanks for posting your final solution!