Posts Tagged SharePoint; PowerShell; site collection size

SharePoint–Displaying Site Collection Size Using PowerShell

Let’s say we have to display SharePoint site collection size using PowerShell. We can easily use Client Object Model and PowerShell to accomplish that. Let’s do it step by step:


PS > $spsite = Get-SPSite “http://sharepoint:100”

PS > $spsite.Usage

It will display data like this:


Hmmm, interesting. It shows the size and also some other user information like visits and bandwidth. But, we just care for the size. So let’s modify the code:

PS > $spsite.Usage.Size

Now the output looks like this:


Ok, we have the size but it’s in bytes. Let’s convert that to MB.

PS > $spsite.Usage.Size / 1000000
or alternatively we can use this code:
PS > $spsite | select @{Name=”Size”; Expression={$_.Usage.Size / 1000000 }}

The output looks like this:


Still doesn’t look good. Now we can use the expression formatting to make it human friendly:

PS > $spsite | select @{Name="Size"; Expression={"{0:N2} MB" -f ($_.Usage.Storage/1000000)}}

Bingo, now it shows up as:

3.51 MB

0:N2 is the standard .NET based format. 0 would means the argument position and N2 means number format with 2 decimal places. –f is used for pass the argument to the format.

No Comments